Special Functions

Function Description
Between Checks if the value is greater than or equal to min and less than or equal to max.
Case This function checks if an expression is equal to multiple values and returns the corresponding result; otherwise, the else-result is returned.
DeviceLatitude This function records the GPS coordinates of the mobile device when the user clicks the "Send" button.
DeviceLongitude This function records the GPS coordinates of the mobile device when the user clicks the "Send" button.
DeviceLocation This function records the GPS coordinates of the mobile device when the user clicks the "Send" button.
DeviceTimestamp This function records the timestamp on the mobile device when the user clicks the "Send" button.
FileName This function returns a file name for the file stored in the file attachment column.
FileType This function returns the media type of a file stored in the file attachment column.
Hash Calculate Hash for third-party API calls.
HMAC Calculates HMAC for third-party API calls.
If This function checks multiple conditions and returns the corresponding result for the first one that is true; otherwise, the else-result is returned.
In Returns true if the value is equal to any of the values in the list.
ParentKey This pseudo-function returns a key value for populating a reference column.
Response Returns the data from the server response.
ResponseHeader Retrieve information kept in an HTTP header.
ResponseStatus Returns the response status code.