Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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!

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 7

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.