I want to have a calculated field where the user either sees a link to click on (which redirects to a document), or sees a message "The document hasn't been uploaded yet".
I tried to do this by having the following in a calculated field:
CASE
WHEN [@field:File]<>'' THEN [url="[@field:File]"]Click here to read the document[/url]
ELSE 'The document hasn't been uploaded yet.'
END
But this doesn't work. When I want to go the the details page I get Error in formula.
Do you have any sug
I want to have a calculated field where the user either sees a link to click on (which redirects to a document), or sees a message "The document hasn't been uploaded yet".
I tried to do this by having the following in a calculated field:
CASE
WHEN [@field:File]<>'' THEN [url="[@field:File]"]Click here to read the document[/url]
ELSE 'The document hasn't been uploaded yet.'
END
But this doesn't work. When I want to go the the details page I get Error in formula.
Do you have any sug