Is it possible to create a URL to an external page using a report field in text mode?

[CamiD]

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!

[lgaertner · Accepted solution]

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

[_Manish_Singh]

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.