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
