I'm working on a report where one of the columns pulls an ID from a custom form field and I was wondering if it's possible to use that ID to create a clickable URL to an external page where the ID is a part of the URL, for example:
https://example.net/CustomFormField/view
If it is possible, how would that look like in text mode?
Thank you!
Solved! Go to Solution.
Views
Replies
Total Likes
Hello,
yes you can do that by changing value= to valueexpression= and use the CONCAT() function:
valueexpression=CONCAT("https://example.net/",{<customFormField>},"/view")
Regards
Lars
Hello,
yes you can do that by changing value= to valueexpression= and use the CONCAT() function:
valueexpression=CONCAT("https://example.net/",{<customFormField>},"/view")
Regards
Lars
Hello @lgaertner - On the top of this, is it possible to add an abbreviation for the external page hyperlink like 'Click here'?
At the moment, my best idea is to create a calculated field, then incorporate this calculated field into the text mode.
Views
Replies
Total Likes