How can I accomplish the following: In a form I want to dynamically alter the choices available in Field B when a certain option is chosen in Field A.
E.G
Hi @Bodo_Hoenen1 ,
you can do it from the form editing view. When you import the B field in your form there is an option at the end of the field’s tab “Show field when conditions are met”. Click there and then you can add your conditions. As you will see the conditional choices include only the fields which are stored above the field you are editing.
Please when you try it post us back your results.
Hi @Bodo_Hoenen1 ,
you can do it from the form editing view. When you import the B field in your form there is an option at the end of the field’s tab “Show field when conditions are met”. Click there and then you can add your conditions. As you will see the conditional choices include only the fields which are stored above the field you are editing.
Please when you try it post us back your results.
@Dimitris_Goudis This was one of the first things I tried, and the issue is that I cant add multiple filters that are dependent on inputs from a preceding field. It allows you to add only one, I.E if country 1 is selected, then show states from country one. You cannot then add another filter that says if country 2 is selected then show all the states from country 2.
This is not possible to do neatly in an Airtable form. One way is to have a different pick list for each single select value. For example, have one single-select for country. The. Have a different single select for each country with the states for that country. Then use conditions to determine which country’s pick list to show. Finally, have an automation to consolidate the data from the multiple pick lists into a single field.
OK, thank you! One messy workaround is for me to create a copy of the state field for each country 
and then use the “show field when conditions are met” logic, but as you can imagine this is messy. The other option is to purchase a plugin for a ridiculous sum from https://on2air.com/: 
On2Air Forms no longer exists, but this is now a natively built-in feature of Airtable with Airtable’s dynamic filtering in linked record fields feature.
This feature is also available in Fillout's advanced forms as well. Fillout is 100% free and offers hundreds of advanced features for Airtable that are not available with Airtable’s built-in forms.
Hope this helps!
If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.