nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Plugin to Create and Update Forms in Confluence

RV_51d3a0

We would like to create a Form in confluence which does the following:

1) First time the user logs in, shows the user a blank form (meaning all questions are unanswered), will let the user answer the questions and saves the response. The user need not answer ALL the questions.

2) Next time the user logs in, shows the same form but populates the form with already answered questions. The user can answer the rest of the questions and also change the answers to the already answered questions.

3) Don't want to create a separate page for each users form data.

Is that possible with any existing plugins?

Preferably, can we store the data in an external DB so that confluence is not overloaded with 1000's of FORM data.

Accepted answers

All comments

Davin Studer

The one I am most familiar with and use on an almost daily basis is ConfiForms. It can do what you are asking ... except for store the data in an external database. The data is stored with the page that the form is defined on. Technically, it is in the Confluence database and you could query it if you are proficient with SQL as it is stored in an xml format in the OS_PROPERTYENTRY table.

RV_51d3a0

Hi Davin,

Thank you so much for responding. Our main concern is we only want to use only 1 page (standard form) and point users to this page.

Say the user needs to answer a set of questions for each JIRA issue. Since the number of questions is in 20's, we don't expect the users to answer all these questions in one go. For the first time, its a blank form, user answers few questions. Next time, the user first selects the issue number, so if there is already a record in the DB for this issue, we want to populate the form with already answered questions.

In short, we want to define issue number as a unique field/key in the DB, and query the DB to get the data related to issue id and populate the form with that data.

Is that possible? I didn't see any examples of this use case in ConfiForms. Can you please confirm if you have encountered any such case?

Davin Studer

Yes you can do that. You can even hook it up to JIRA to have it create JIRA tickets if you want or you could have a smart drop down that get's its data from the JSON of a JQL search (for looking up JIRA ticket numbers). It can do TONS of different kinds of things. I would say download a 30 trial to a non-prod server if you have one or production if you don't and you're ok with that. Honestly, it is one of the most useful add-ons we have purchased for Confluence in my organisation.

RV_51d3a0

Hi Davin,

I have installed the trial version and played around with it. I was able to pull data from JIRA and update JIRA fields as well based on certain actions in the confiforms form. Thanks for your suggestions!

I have a question: I have a field called "Jira Issue ID" and I am making it unique. If the form has say 10 questions, and a user has answered only 6 of them for a particular "issue id" and saves it. If the user comes back next day and searches/types that issue ID, I want to pull the data that he has already saved and populate the form with those saved responses. The user can answer only the rest of the questions and not all the questions again!

I am not able to achieve the above use case. I have seen that we can pull data from an external DB, or from JIRA issues etc. But how do I pull the data that was already stored in the same form's DB?

Do you have any pointers on how to implement that?

Thanks,
Rahul

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

atlassian-marketplace

forms