Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jun 02, 2021 01:21 PM
Good afternoon from a relatively newbie!
I am working on a volunteer project where the organization is giving away certain items “first come, first serve.” I have created a form for interested people to make a request for an item, but, when the inventory is 0, I want a “pop-up” message on the Form to say “Sorry! That item is no longer available. Please select a different item.” What I would prefer is a conditional lookup for the item field that would not display it as an item if the inventory table says the quantity is 0.
Any ideas would be much appreciated!
Tim
Jun 02, 2021 02:51 PM
Welcome to the Airtable community!
Airtable forms cannot run scripts, so finding and implementing a system that will give you a pop up may be more effort than it is worth.
However, if you put the items in a linked record field that tracks inventory, you can create a filtered view that includes only in-stock items. Then have you form limit selection to the filtered view.