🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com
Conditional Logic in On2Air Forms for Airtable allows you to create powerful conditions in your form, such as displaying or hiding fields, adding or removing field values, making fields required if another field option is selected, and much more.
Condition Options
You can use these Conditions to determine when your Logic activates the Trigger action
- Is Empty - when the field IS empty and has no value or data
- Is Not Empty - when the field is NOT empty and has a value or data
- Not Starts With - when the field does NOT start with a specific value, such as a letter, word, number, or symbol
- Starts With - when the field DOES start with a specific value, such as a letter, word, number, or symbol
- Not Ends With - when the field does NOT end with a specific value, such as a letter, word, number, or symbol
- Ends With - when the field DOES end with a specific value, such as a letter, word, number, or symbol
- Contains - when the field CONTAINS a specific value, such as a letter, word, number, or symbol or a value or option from another field
- Not Contains - when the field does NOT contain a specific value, such as a letter, word, number, or symbol or a value or option from another field
- Is Exactly - when the field IS EXACTLY a specific value, such as a letter, word, number, or symbol or a value or option from another field - must match EXACTLY
- Evaluate - use operators, such as =, >, <, and others to compare data to other field values, select options, or custom values you manually enter
Evaluate Operators
= - equal to
> - greater than
< - less than
>= - greater than or equal to
<= - less than or equal to
!= - does not equal to
- Length Evaluate - use operators, such as =, >, <, evaluate the length (number of characters) of the field values, select options, or custom values you manually enter
Length Evaluate Operators
= - equal to
> - greater than
< - less than
>= - greater than or equal to
<= - less than or equal to
!= - does not equal to
Trigger Options
You can perform these actions based on what the form user selects and enters in another field
- Show Fields - show the field on the form (editable)
- Hide Fields - hide the field on the form
- Optional Field - make the field optional to be completed
- Require Field - require the field the be completed
- Display Field - display the field (non-editable)
- Edit - make the field editable
- Active - make the field active (optional to complete it or not)
- Disable - disable the field (non-editable but can still view on form)
- Set Value - add an actual value or response in the field
- Clear Value - clear the value or response in the field
- Set Options - add select field options or options from other fields
- Set Template - create field templates and display them dynamically depending on user response