Nov 22, 2024 03:41 AM
I 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.
Solved! Go to Solution.
Nov 22, 2024 05:48 AM - edited Nov 22, 2024 05:51 AM
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 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
Nov 22, 2024 05:48 AM - edited Nov 22, 2024 05:51 AM
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 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
Nov 22, 2024 06:04 AM
So helpful! Thanks Scott. I may well be enlisting your help at some point. Many thanks, Danny
Nov 22, 2024 06:08 AM - edited Nov 22, 2024 06:09 AM
You'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.
Nov 22, 2024 08:30 AM
Done. Just set this all up in Fillout. It's a great product. Hard to understand why Airtable doesn't replicate this basic functionality.
Nov 22, 2024 02:54 PM - edited Nov 22, 2024 02:55 PM
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