Display different text for File column in email notification

M_Felix
Participant II

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.

0 4 227
4 REPLIES 4

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)

Top Labels in this Space