Dynamic reference for Link to URL fields
Currently we are leveraging Link to URL field format for couple of reports and referring current column value in a link by Specifying ## in url,
but we have a requirement to make it dynamic to achieve some use cases,
Use Case -
Our source system generates two ID's when any request gets created in Application,
1. DISPLAY ID
Display Id is something visible on UI and should be displayed in Report but Source will not recognize it in URL and GUID is something system generated long alphanumerical value which doesn’t look good in Report its only acceptable in Report.
We are expecting we will put both fields in a Report and we will put hyperlinks on a Display ID but we provide ## reference of GUID column, So when user clicks on Display ID URL internally URL will pick up Value of GUID column in same Row,
It will make behaviour dynamic and provide flexibility to choose which column to hyperlink and what value to replace in URL.
Hope it explains the use case,
Let me know your thoughts.