+5I am using the new form builder and want to filter the values of a dropdown field, Product, based on the value of another field, Designer, on the same form.
Although I found the "filter records by a condition" option, I cannot see a way to use the Designer field's value as the condition for the filter. Any help appreciated.
Best answer by ScottWorld
Yes, this is possible with the new interface forms (not the view forms).
However, you have to configure this at the field level, not the form level.
What this means is that you can’t make your dynamic condition for the field work ONLY on the form. That field has to work dynamically throughout all of Airtable, no matter where you place that field.
If you want a field to only act conditionally on a specific form, you could always create a new field that you only use on your form.
Alternatively, if you’d like more flexibility than that (i.e. you want pre-existing fields to only act dynamically on a particular form), or if you’d like more flexibility in the dynamic conditions that you can specify, then you can get all of this extra functionality by using 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 dynamically & conditionally filter linked record fields, update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, 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
+35Yes, this is possible with the new interface forms (not the view forms).
However, you have to configure this at the field level, not the form level.
What this means is that you can’t make your dynamic condition for the field work ONLY on the form. That field has to work dynamically throughout all of Airtable, no matter where you place that field.
If you want a field to only act conditionally on a specific form, you could always create a new field that you only use on your form.
Alternatively, if you’d like more flexibility than that (i.e. you want pre-existing fields to only act dynamically on a particular form), or if you’d like more flexibility in the dynamic conditions that you can specify, then you can get all of this extra functionality by using 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 dynamically & conditionally filter linked record fields, update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, 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
+5Yes, this is possible with the new interface forms (not the view forms).
However, you have to configure this at the field level, not the form level.
What this means is that you can’t make your dynamic condition for the field work ONLY on the form.
That field has to work dynamically throughout all of Airtable, no matter where you place that field.
If you want a field to only act conditionally on a specific form, you could always create a new field that you only use on your form.
Alternatively, if you’d like more flexibility than that (i.e. you want pre-existing fields to only act dynamically on a particular form), or if you’d like more flexibility in the dynamic conditions that you can specify, then you can get all of this extra functionality by using Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
So helpful! Thanks Scott. I may well be enlisting your help at some point. Many thanks, Danny
+35You're welcome! 🙂 If you don’t mind, could you please mark my answer as the solution above? This will help others in the future, because it should rise to the top of the search results.
+5You're welcome! 🙂 If you don’t mind, could you please mark my answer as the solution above? This will help others in the future, because it should rise to the top of the search results.
Done. Just set this all up in Fillout. It's a great product. Hard to understand why Airtable doesn't replicate this basic functionality.
+35Done. Just set this all up in Fillout. It's a great product. Hard to understand why Airtable doesn't replicate this basic functionality.
So glad you love Fillout! It is one of the most successful & most highly acclaimed add-on products for Airtable.
Yeah, it’s crazy that Airtable hasn't bought Fillout by now, or that Airtable hasn’t implemented more of the features of Fillout into Airtable!
Although Airtable could never catchup at this point — Fillout offers nearly 1,000 features that Airtable doesn’t offer, and they keep adding new ones every week!
- ScottWorld, Expert Airtable Consultant
+10Hi All–
Assuming there isn’t a way to do this same filtering on the AT native form builder?
I have a date field I want to filter the date links different based on the submission type of the form as it’s being filled out.
Seems like fillout is the only option to do that outside of building the form using an interface page, which would require an editor license.
+4Hello
Another tool you can try is Plumsail Forms, which allows you to filter dropdown options. You can set up either a static or dynamic filter based on another field's value. The condition can be as simple as "Price equals 10" or as complex as you need.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.