A simple app for booth selection for conference events

[ClayG]

We have lots of conference events each year with vendors who exhibit at our conference. We have them pick a booth number from a list of maybe 50 potential booth locations.

I'm thinking of building a simple app for vendors to see a list of available booths and after they choose an available booth, that booth number becomes unavailable. 

I don't think this will be hard but I thought I'd ask if anyone has already created an app like that?

 

[ParkLoey]

Hi @ClayG! This seems to be a pretty simple app. Here's my suggestion:

• create a table where you will put all the booth locations
• create a table where the system will record who picked what booth
• create a submission form where vendors will choose a booth and submit a record
• vendors can choose a booth using a dropdown field which gets the options from the table where you put all booth locations

Now, the thing you need to do to make the booth unavailable when a vendor has already chosen it is to use triggered actions. Make the trigger delete the booth on the booth table after it has already been chosen. Here's a sample of the trigger 

Hope this gives you an idea.

[imJihyo]

Hey! You guys might find this helpful as well given the suggestion above

 

Submission Forms - Caspio Online Help Lookup Tables - Caspio Online Help https://howto.caspio.com/datapages/forms/form-element-types/#Dropdown

[ClayG]

Thank you @ParkLoey and @imJihyo! That's very helpful.