Hi Community,
I have an application with a File column ex. <<[DOCREVIEWED]>>where the user will upload a final reviewed document then the application will send an email to a specific recipient with the link. I am having a problem with showing a different text in the email notification.
I tried Hyperlink but the URL is still visible. ex. email body is shown below.
Dear User,
This is to inform you that the final reviewed contract has been uploaded by LCG <<NOW()>>.
Reviewed Contract: HYPERLINK("<<[DOCREVIEWED]>>", โFILEโ)
Description:<<[DESCRIPTION]>>
You help will be greatly appreciated.
change to:
<<HYPERLINK( [DOCREVIEWED] , โFILEโ )>>
Hi @Marc_Dillon ,
Tried this but I get an error saying HYPERLINK has invalid inputs.
โRequesterNotifโ task โNotifyRequesterFinalโ Body template. Expression โHYPERLINK([ATTACHMENT10], โFILEโ)โ is invalid due to: HYPERLINK has invalid inputs.
A File column is not a URL. To build the public URL you need to replicate that template/gettablefileurl that you see there. Read this doc for more info (near the bottom)
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |