Using a form to filter

Welcome to the community, @Kyrstin_Graves! :grinning_face_with_big_eyes: Unfortunately Airtable forms don’t support that kind of conditional logic between fields. The only logic option currently available is to control whether or not a field will display based on what happens with another field.

I don’t do a lot of work with forms, so I’m a little rusty on which third-party form solutions might offer this ability. One option to check, though, is the On2Air:Forms product for JotForm created by @openside. It’s got some really robust features, though I’m not 100% certain how deeply the conditional logic options go.

Welcome to the Airtable community!

In Airtable, forms are typically used for data entry, not for setting filtering criteria for what records to display.

Are you looking for a tool for external customers, or a tool for internal users who are collaborators on the Airtable base?

If your users are Airtable collaborators, the built-in tools for filtering a view work well. It won’t work exactly like you described with the gradual filtering, but users can pick years, brands, models, etc.

Another option for base collaborators is a custom script that will ask for the year, make, model, etc. The script could provide the gradual filtering (e.g. only show models for the given brand). There are some limitations (such as always having to pick filter parameters in the same order), but it could work.

Thanks for replying!

So, we want this to be a customer facing form so they wouldn’t be collaborators. I have an excel sheet that I think I can turn into a table in airtable that will house all of the necessary data. I’m just trying to find a way that in the form, the customer could select 1999 and it only show the make of vehicles within that year. Then they could select the correct make and the next form field down would only show the models for the selected year and make. Then after selecting the correct model, it would show the corresponding price for that vehicle.

I know you can make conditional fields and lookup fields, I guess I’m just trying to find a way to combine the two. I’d even manually build it out for now, if I knew of a way to make certain options in a from conditional on which option was chosen above.

I feel like it has to be possible in airtable and I’m hoping someone knows a way to set it up. I’m just hoping I’m not wrong because using airtable for customer facing order forms would be amazing.

Like I said above, that kind of logic isn’t currently possible for customer-facing, non-collaborator interfaces unless you use a third-party system that a) retrieves the data from Airtable, and b) dynamically filters that data for display based on user selections. As @kuovonne said, Airtable forms don’t do that. They are only designed for data entry. They only have a very minimal connection to the data from the source table (only enough to retrieve what options are needed for certain field types). Editing fields in a form does nothing to your Airtable data in real-time. Only when you submit the form does the data that you entered get saved into a new record.

2025 Update:

You can now do this natively in Airtable by using Airtable’s dynamic filtering in linked record fields.

And this dynamic filtering feature has always been available in Fillout’s advanced forms for Airtable, which also offers hundreds of advanced features that Airtable’s native forms don’t offer, such as the ability to update Airtable records from a form or the ability to generate a custom PDF file from a form submission.

Hope this helps!

If 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