Forum Discussion

damienpage's avatar
damienpage
Qrew Cadet
4 months ago

Rich text field using URL

Good afternoon all....

I have created a formula that check for the existence of a file.

The premise is that if no file exists, create text that says no record, or if it does create a 'URL LINK' to the file. The following is what I have come up with but not working...

If([COPY OF INDEMNITY]="","NO RELEASE","<a href=" & [RELEASE URL] & "CLICK HERE FOR RELEASE</a")

If anyone can assist it would be appreciated.

Cheers,

Damien

  • If([COPY OF INDEMNITY]="","NO RELEASE","<a href=" & [RELEASE URL] & "CLICK HERE FOR RELEASE</a>")

     

    You are missing a closing angle bracket.