How to create a calculated field to convert links to text when using the Reports and Timesheets for Jira app

This article provides step-by-step instructions to convert links to text and display a specific string using the calculated field in the Reports and Timesheets for Jira app.

Instructions

1. Navigate to Apps > Reports and Timesheets > My Area > My Calculated Fields.

2. Click Create New Field > Create new field using SUBSTRING() method as shown in the screenshot.

Open

3. value: Add the hyperlink field.

4. startPos: Based on the exact URL, define the start position to pull the text. Count the URL characters, including the spaces, to define the start number.

   • Example URL used for the above:

     <a href=\"https://support2-jira.devops.appfire.net/secure/insight/assets/HAR-5\" target=\"_blank\">Firewall </a>

5. endPos: Based on the exact URL, define the end position to remove the characters. -5 is used in the above example to remove </a>

Example result

Open