Templating This feature allows you to insert variables into spreadsheet spreadsheets and fill it them out with specified issue data. It can be used for creating to create templates and fill it them out in real time (powered by Excel).
It contains consists of 2 two sections:
| Table of Contents |
|---|
This feature is available cross worksheets, it means that if on all worksheets. If you import issues in to sheet1, automatically, this feature it will also be available also in sheet2, sheet3 etc., even if you didn’t fetch there any issues there.
Import
| Info |
|---|
Work on already fetched issues or import issues, without displaying them on worksheet. |
You can work on already fetched issues or import issues 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
| Info |
|---|
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. |
...
manually, by typing it into desired celcell
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
...
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:
...
To reverse template fill, use the back ' → ' button → it will show variables again, then just chose next issue and use the fill option
...
| Info |
|---|
To learn more about Templating visit our step by step instruction from the previous version: Templating [v1.5.0] |