How to limit selections to one time?

Hey ​@tzuhouse!

Could you please share some additional details on your data base architecture?

If your time slots are a specific table on its own, and via a Scheduling table you are linking a given person with a given slot, then you can set your form to filter out any slots for which the linked field to schedules is not empty.

However I do have some further questions for you:
1. What tables do you currently have in place? (same question as above)
2. Are slots a single select or a linked records?
3. Are you familiar with Calendly or similar scheduling tools? These could be easily integrated with Airtable if you want to keep track of scheduled meetings.
4. What form provider are you using? Airtable native forms? You might want to consider using Fillout, which has an integration with Calendly.


Would love to get some details. I’d be happy to check out your base and make sure you have the correct schema. Feel free to schedule a brief call if needed/interested.

Mike, Consultant @ Automatic Nation

My form is two questions.  Student Name and then selecting the timeslot, which is linked to another table so I can see who is coming in, in what order, easily.  I am not familiar with scheduling tools.  I haven’t ever tried something like this before, but if I can figure it out, can definitely use it in the future.  I can always use signupgenius, which is what we’ve done before.  Just wanted to see if this was possible.  Trying to use airtable for as much as I can to learn as much since we are paying for it.

​@tzuhouse I see!

Does your base look smth like this?

 

When creating the form, did you get to play around with Selection/Filters? -see image below.

 

Please feel free to share some screenshots for further reference!
 

Smaller.  Only two fields.  I’m not seeing how to get to that box in the last picture.  https://airtable.com/appfiL2KRXz5OnhHx/shrdNFrrQseiruGmK

​@tzuhouse

Sorry, I’m jumping in on Mike’s answer here, but you are using Airtable’s old form.

In the old form, you would need to set the filter for your linked record field at the Data layer. In other words, you’ll need to set the filter on the field itself.

I demonstrate how to accomplish this in this Airtable podcast episode.

If you’re using Airtable’s new form, then you can use ​@Mike_AutomaticN’s solution above.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Editing the form, select the field and in the configuration on the right select to filter the selections, by condition, then select the field and IS EMPTY is the filter you want.  Then when they click the list is filtered to just the ones whos timeslot assigned person (or whatever field you are using) is not filled in and available.

Want to shout out Scott’s form knowledge because this is also kind of addressed in another podcast episode he did recently here (relevant bit at 37 min mark), showing how with proper base setup the forms will prevent doublebooking. His example there is tickets, but having them as date/time would work just the same. 

Thanks, ​@DisraeliGears01! 😀

- ScottWorld, Expert Airtable Consultant