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
Best answer by Bodo_Hoenen1
OK, thank you! One messy workaround is for me to create a copy of the state field for each country :frowning: 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/: 
+20Hi @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.
+29This 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 :frowning: 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/:
+35On2Air 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 with Fillout’s advanced forms for Airtable.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything 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.