The following is a list of functions that are available in the Formula Builder.
|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).
|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).|