This workaround is meant to help projects where it is necessary to run JQL queries for the fields related to the form.
At the moment, unless we map every Forms field to a Jira field, they will not be searchable through the JQL query, we have a request feature created for this topic:
Therefore, you can link form fields to Jira fields to ensure the JQL work as usual.
Create a new custom Jira field:
Select > Issues.
Under FIELDS, select Custom fields.
Click Create custom field. Make sure to select All to view the available field options.
Select the type of field you want to create and click Next. See a list and descriptions for the available custom field types in company-managed projects.
Add the details for your field.
The name you select appears as the custom field's title wherever the field appears. The description appears below the field when creating and editing issues, but not when browsing issues.
When you have entered the field details, select Create.
Add the new custom field to one or multiple screens by ticking the corresponding box and click Update.
To link a form field to a Jira field:
From the navigation on the left, select Project settings or Service project settings > Forms.
Find the form you want to edit, and select More (...) > Edit.
Find and select the field you want to link to a Jira field.
In the right-hand panel, under Linked Jira field, select the Jira field you want to populate with the information in your form field:
Select Save changes.
Note: To link form fields with Jira fields, certain criteria must be satisfied, or your form may not work as expected, please refer to Link a form field to a Jira field for more information.
And now the form field will be searchable:
Tips and plus alternatives
You can export a spreadsheet of form responses following the steps below:
- Open your service project > Project settings > Forms
- Locate the form > Click on the ••• dropdown menu > Select Export in XLSX.
An XLSX file with the issue keys and all responses that have been submitted for the form will be downloaded.Just note that only Project administrators are able to see the Export in XLSX option.
Or you can also export a spreadsheet by selecting specific issues and including Jira fields in the export. To do that, please follow the steps below:
- Select Filters in the top bar > View all issues
- You can use either basic or advanced JQL search modes to define your search criteria
- Make sure you are under the List view.In the Columns dropdown, select the columns you want to include. These will be the Jira fields that are included in the export.
- Click on the Export option and select Export XLSX (form data).
- A new screen will open and you can select the Project and the Form.
- The export will include the selected Jira fields as well as the form fields for any issues in the original query that have the selected form.
Bruno Altenhofen
Atlassian Engineer - The guy from Proforma(Jira Forms)
e-Core
Krakow - Poland
1 accepted answer
9 comments