Hyperlink in workflow template.
Need a help from community.
I generated the virtual column to pick up a url link to the image.
The app formula is something like ;
hyperlink(concatenate(“https://www.appsheet.com/template/gettablefileurl?appName=APPID&tableName=TABLENAME&fileName=”,[Photo]), ‘Link to URL’)
This VC is named as ‘Link to Image’
This generates hyperlink to the image file, opening a browser to view the image which is stored in the same field, column name [Photo].
What I m trying to do is to put a hyperlink (shortened) into the workflow template.
On the template, i put expression of ‘<<[Link to Image]>>’ to create the link to image file so that the user can hit the link text and jump the images.
However, currently i only get the full path of the image URL instead of shortened text.
I just want to show and display ‘Link to URL’ on the final output report instead of full path.
How can I achieve ?