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
Jul 26, 2022 06:51 PM
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
Jul 27, 2022 12:46 AM
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
Inventory table, view that contains all the records
Inventory table, view that only contains records with status Available
:
Not sure if I fully understand what we’re trying to do here tho