Follow

Contextual

The following is a list of functions that are available in the Formula Builder.

Name Function Description
Current Date TODAY() The current local date reported by the device.
NOTE: Device dates can be inaccurate if the local time is not correct.
Current Date & Time NOW() The current local date and time reported by the device.
NOTE: Device times can be inaccurate if the local time is not correct.
Current UTC (GMT) Date UTCTODAY() The current Greenwich Mean Time (GMT) date reported by the device.
Current UTC (GMT) Date & Time UTCNOW() The current Greenwich Mean Time (GMT) date and time reported by the device.
User's Email Address USEREMAIL() Email address of the user that is logged into the device.
User's First Name USERFIRSTNAME() First Name of the user that is logged into the device.
User's Last Name USERLASTNAME() Last Name of the user that is logged into the device.
User's External Id USEREXTERNALID() External ID of the user that is logged into the device.
Organization Name ORGNAME() Organization Name of the user that is logged into the device.
Global Value GLOBALVAL('keyname') Sets specified Global Value.
Organization Meta Value ORGMETA('key')

Gets the Provider Meta Data Value for the specified key (if any).
For example, if your Organization setup contains a Meta Data key of billing_id, then you may access this value across the platform with ORGMETA('billing_id').

User Meta Value USERMETA('key') Gets the User Meta Data Value for the specified key (if any).
For example, if your User setup contains a Meta Data key of billing_id, then you may access this value across the platform with USERMETA('billing_id').
Device Name DEVICENAME() Retrieves the name of the device.
Device Operating System DEVICEOS() Retrieves the Operating System of the device.
Device OS Version DEVICEOSVERSION() Retrieves the Operating System version of the device.
App Version APPVERSION() Retrieves the current version of the app installed on the user's device
Screen Version SCREENVERSION() Retrieves the current version of the Screen.
Screen Last Updated (UTC) SCREENDATE() The date & time on which the current screen on the device was last updated for GMT (UTC) time zone.
Direct Value VAL('dataname') Returns the current answer value of the given field. Useful for avoiding circular reference issues, e.g. when filtering repeated values in a Choices field based on its own current value.
Sequential Counter COUNTER(padwidth) Simple counter that increments by 1 every time a new Form entry is created in the app.
Will left pad the counter with zeros to the specified padwidth length.
Concatenate counter() with user data to generate unique numbers.
NOTE: Counter numbers are device-specific.
Screen Parameter PARAM1() The value passed into the Form from the calling Screen's User Interaction Value (if any).
     

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk