date()

Date Syntax Function: DATE(val) Parameters: val = given value Outputs: a string in a date format Description: Convert a…


globalval()

Global Value Syntax Function: GLOBALVAL(‘keyname’) Parameters: keyname  = the name of the ‘key’ in a key/value pair Outputs:…


param1()

Parameter Syntax Function: PARAM1() Parameters: The input value is passed from the form sending the value from an…


counter()

Current organisation name Syntax Function: COUNTER(padwidth) Parameters: padwidth =  number of zeroes to left-pad the counter with. Outputs: a…


userexternalid()

Current organisation name Syntax Function: USEREXTERNALID() Parameters: none Outputs: a string value Description: The USEREXTERNALID() function returns the FormsFly account user identification…


orgname()

Current organisation name Syntax Function: ORGNAME() Parameters: none Outputs: a string value Description: The ORGNAME() function returns the FormsFly account organisation name…


userlastname()

Current user’s last name Syntax Function: USERLASTNAME() Parameters: none Description: The USERLASTNAME() function returns the FormsFly account user’s first name Used: in a Formula…


userfirstname()

Current user’s first name Syntax Function: USERFIRSTNAME() Parameters: none Description: The USERFIRSTNAME() function returns the FormsFly account user’s first name Used: in a Formula…


useremail()

Current user’s email address Syntax Function: USEREMAIL() Parameters: none Description: The USEREMAIL() function returns the FormsFly account user’s email address Used: in…


utcnow()

Current utc GMT  Date Time Syntax Function: UTCNOW() Parameters: none Description: The UTCNOW() function current Greenwich Mean Time…