Example Formulas

Modified on Wed, 17 May, 2023 at 8:35 PM

Available in: Axsy Mobile for Salesforce, Axsy Field Service, Axsy Public Sector, Axsy Retail Execution

Please see the table below for some example formulas and their functions:

Formula	Function	Usage
Element != 'Value'	Will only trigger visibility when ‘Value’ is the input for Element	Visibility Formulas
Element1 != 'Value1' && Element2 != 'Value2' && Element3 != 'Value3'	Will only trigger visibility if ANY ONE of the conditions are met	Visibility Formulas
NOT(AND(Element1 == 'Value1', Element2 == 'Value2, Element3 == 'Value3'))	Will only trigger visibility if ALL of the conditions are met	Visibility Formulas
NOT(Element > 3 && Element <100)	Will trigger visibility only if Element is greater than 3 AND less than 100	Visibility Formulas
Element > 3 && Element < 100	Will only accept an input larger than 3 and less than 100 where Element is referencing itself	Validation Formulas
REGEX(Element, "^[a-zA-Z0-9]*$")	Will only allow letters and numbers as input	Validation Formulas
REGEX(Element, "^[a-zA-Z0-9\n]*$")	Will only allow letters, numbers and new lines as input	Validation Formulas
REGEX(Element, "^[a-zA-Z0-9/ ]*$")	Will only allow letters, numbers and spaces as input	Validation Formulas
REGEX(Element, "^[a-zA-Z0-9.,/-]*$")	Will only allow letters, numbers and special characters '.,/-' as input	Validation Formulas
Element	Will set the default value to the value of Element. Element needs to be in a previous Section or separated by a Loop/Page Break	Default Formulas
Element1 * Element2	Will set the default value to the value of Element1 multiplied by Element2	Default Formulas