Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Form that can automatically have option that connect to Airtable database

Topic Labels: Automations
181 1
Showing results for 
Search instead for 
Did you mean: 

Hi, I would like to ask If we have this inventory database, we want people who want to borrow our inventory to fill out a form that automatically shows only the product that has an “available” status on our Airtable inventory database. How do we do this? is it feasible?

I have tried airtable form, but I don’t find a way to do this by only using airtable form.

Thank you so much

1 Reply 1

Hi Stevi, sort of. If you’re using a linked field to the table in your Airtable form, you can utilize the “Limit record selection to view” option, resulting in a field in a form that would only show records with the status Available

Limit to view

Inventory table, view that contains all the records
Screenshot 2022-07-27 at 3.44.50 PM

Inventory table, view that only contains records with status Available:
Screenshot 2022-07-27 at 3.44.41 PM

Not sure if I fully understand what we’re trying to do here tho