SpreadsheetWEBdata

SpreadsheetWEBdata(ApplicationID,FieldValue,FieldName,DisplayFieldName)

The Application ID is the same ID that can be found in the URL of the application from which you want to retrieve data. The FieldName is the name of the column that filtering will be applied. For example, if the Column name is  “Name” then the FieldName in this case is ‘Name’. The FieldValue is the filter value that will be applied on the column. DisplayFieldName is the name of the column whose value will be returned from the formula with respect to filtering. If DisplayFieldName is blank then FieldName column will be used to return the value.

=SpreadsheetWEBdata(“5b82e9eb-f006-4641-a96f-5a537810fdf9″,”John”,”NAME”,”Occupation”)

=SpreadsheetWEBdata(“5b82e93b-f006-4641-a96f-5a537810fdf9″,”33″,”Age”,”Gender”)

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

=IF(SpreadsheetWEBdata(“5b82e9eb-f006-4641-a96f-5a537810fdf9″,”John”,”NAME”,”Occupation”)=”#N/A”,””,SpreadsheetWEBdata(“5b82e9eb-f006-4641-a96f-5a537810fdf9″,”John”,”NAME”,”Occupation”))