🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com
You can map Single-Select, Multi-Select, and User options to a Parent field value with the filtering/mapping feature. This allows you to display specific options from your Select and Users fields based on another field’s value. You can use any Field Type as your Parent Value and map them to your Single-Select, Multiple-Select or User fields.
EXAMPLE:
When an Industry is chosen in a field, it will display only specific Users
In this tutorial
- What Field Types can be used as Parent Fields to map to Single-Select, Multi-Select, and User fields?
- How to Map Your Fields in On2Air Forms
- Define Settings If No Match is Found
- Additional Mapping Settings
- Final Results on Form
What Field Types can be used as Parent Fields to map to Single-Select, Multi-Select, and User fields?
You can use most Field Types as the Parent field and then map the Parent field values to Single-Select, Multi-Select or Users. For Parent fields that aren’t Select or User fields, you’ll be able to enter in Values.
How to Map Your Fields in On2Air Forms
- Choose your Single-Select, Multi-Select, or User field from the Fields menu
- Choose the Parent Mapping menu and click Enable Parent Mapping
- Select your Parent Field
- Click Field Mapping
Your Parent Field is the field your form user will complete first. The value from this field determines the Single-Select, Multi-Select, or User Field options. Parent Fields can be almost any field type.
- If your Parent Field is a Single-Select, Multi-Select, or User Field, you’ll see a list of values from your Airtable field in the Parent Values column
- If your Parent Field is not a Single-Select, Multi-Select, or User Field, you’ll need to create Values in the Parent Values column.
- To create Values, click Add New, enter in a Value, then click Done. Add as many Values as you need.
- Example: If your Parent Field is an Email field, click Add New, then enter in an Email address and click Done. You can enter in multiple Email values
- Click on each Parent Value, then click the corresponding Child Options to map the Parent to Child. You can select multiple Child Options per Parent Value. Complete this for each Parent Value as needed
- Click Done
- To remove mapping from a Parent Value, click the Parent Value, then select the Child Option again
- You’ll see your mappings in the Mappings field
Define Settings If No Match is Found
- Set your If No Match options. This allows you to decide what the form user can view in the Select or User mapping options if there is not Parent Value match
Options:
Display All Options - Displays all options from Single-Select, Multi-Select or User field
Display No Options - Displays no options from Single-Select, Multi-Select or User field
Additional Mapping Settings
- Case Sensitive Matching - if enabled, the field value entered by the form user be an exact match with upper case and lower case to the Parent Values
- Allow Partial Match - if enabled, a parent field value can partially match the parent values and the form user will be able to choose from the mapped options
- Disable on Empty Parent - if enabled, the Select or User field will be disabled completely if no value is entered into the Parent Field
Final Results on Form
Now, you can see when an Email is entered that matches the Parent Value (Email), it will display the corresponding Child values (Industries)
Form View