SpreadsheetWEBFile

You are here:

SpreadsheetWEBFile(ApplicationID,RecordIdentifier,FieldName,Label)

The FieldName in this case is a file type other than an image. This equation will create a hyperlink in the web application. When the user clicks on the hyperlink, the web application will download the file. Label parameter allows to edit hyperlink’s text. Leave Label parameter blank to file’s name.

=SpreadsheetWEBImage(“862ce249-da29-499f-b2c3-9a5dadda8a97″,”1″,”attachment”,”Click to download”)=SpreadsheetWEBImage(“862ce249-da29-499f-b2c3-9a5dadda8a97″,”1″,”attachment”,””)

If there is no data or file corresponding to the parameters of SpreadsheetWEBFile, the formula returns “=SpreadsheetWEBFile(#N/A)”. To avoid error message:

=IF(SpreadsheetWEBImage(“862ce249-da29-499f-b2c3-9a5dadda8a97″,”1″,”attachment”,”Click to download”)=”=SpreadsheetWEBFile(#N/A)”,””,SpreadsheetWEBImage(“862ce249-da29-499f-b2c3-9a5dadda8a97″,”1″,”attachment”,”Click to download”))