This feature is available cross worksheets, it means that if you import issues in sheet1, this feature will also be available in sheet2, sheet3 etc. even if you didn’t fetch there any issues.
Work on already fetched issues or import issues, without displaying them on worksheet.
You can work on already fetched issues or import issues without displaying them. We will use the templating build-in import.
Using build-in import in Templating section
Start by selecting filter (1) from the dropdown list, if needed you can change default limit of fetched issues (2). When you click Import (3) button, issues will be fetched in background and you will unlock new “Template” section.
Build a template using prefix and field ID. Select an excel cell and use ‘Set Variable’, when you choose issue and use ‘Fill’ action, it will change variable into value from chosen issue.
You can use multiple variables in 1 template, ‘Fill’ option work on selection and fills all variables (with values) matching current prefix.
If you want to revert changes (filling variables) use the back button.
To build a template you need to have some building blocks like variables, which will be filled with data of the selected issue.
Variables are build of prefix and Field ID, by default variable prefix is set to ec365 (but you can change it easily). For example: if you would like to use assignee field in the template, you should use (prefix.fieldID) → ec365.assignee variable in any of the cells,
You can insert variables in worksheet in few ways: