This feature allows to insert variables into spreadsheets and fill them out with specified issue data. It can be used to create templates and fill them out in real time (powered by Excel).
It consists of two sections:
This feature is available on all worksheets. If you import issues to sheet1, automatically, it will be available also in sheet2, sheet3 etc., even if you didn’t fetch any issues there.
Import
You can work on already fetched issues or import them, without displaying them on the worksheet. We will use the templating build-in import.
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.
Template
Build a template using prefixes and field IDs. Select an Excel cell and use ‘Set Variable’, after choosing an issue and then use ‘Fill’ action. It will change variable to value from the chosen issue.
You can use multiple variables in one template. ‘Fill’ option works on selections and fills out all variables (with values) that are matching current prefix.
If you want to reset changes (filling variables) use the back/arrow 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:
manually, by typing it into desired cel
by copy & paste the field ID with prefix, from the field section: https://psc-software.atlassian.net/wiki/spaces/ECSD365/pages/2412445711/Visible+Fields#Checkboxes%3A-Field-ID%2C-Prefix into cell
with ‘Set Variable’ button, which will insert variable into currently active cell
select field from the dropdown list
in the worksheet select cell, where you want to insert variable
use ‘Set Variable’ button
To fill variables select cell (or cell range), then Select issue from the dropdown, then click Fill button, your variables will be filled with data from the selected issue.
When you click fill and the cell is empty, it means that it doesn’t have any data
You can reverse changes with the back button, remember to select all affected cells
Example
Here you can see a template with some basic issue details, and selected all issue (in the dropdown), the whole cell range is selected with variables:
Using Fill on selection, will update data with details from issue:
To reverse template fill, use the back button → it will show variables again, then just chose next issue and use the fill option
Notice there is special app variable: ec365.appVariable->currentDate, it can be used to add the timestamp of the template filling
To learn more about Templating visit our step by step instruction from the previous version: Templating [v1.5.0]