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