FORMULA LANGUAGE


Examples: @Matches
1. This example returns 0.
2. This example returns 1.
3. This example converts the contents of the State field to lowercase, and returns 1 for any value in the field that contains "mont," for example Vermont or Montana.
4. This example is the default value formula for a field named SalesNumber. The formula returns the number 224 if the content of the Division field is either Central or Midwest. If the content of Division is anything else, the formula returns the number 124.
5. This code, when added as the validation formula for a number field called input, displays the error message, "Value cannot be a letter" if the user enters any lowercase or uppercase letter between A and Z.
6. This code, when added as the validation formula for the US_State editable text field, displays the error message, "Entry must be a valid two-letter state abbreviation" if the user enters anything besides two upper-case letters.
7. This example returns 0 because no item in the second list matches an item in the first list.
8. This example returns 1 because one item in the second list matches an item in the first list.
See Also