Overlapping Dates in Forms and Calendars

Topic Labels: Views
983 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m creating a workflow to help with video production and scheduling. Is there a way to give feedback immediately when someone is filling out a date box on a form that will block that date from being submitted if another submission is already set for that date?

For example, the client puts in a production date of January 1st. But a previous submission is already booked for that day, so their form will get feedback that date is already in use and another will have to be selected.

1 Reply 1
4 - Data Explorer
4 - Data Explorer

This is possible just not with Airtable alone.  For one airtable forms don't allow for input validation.  You would need to link the form to airtable and run a query for that date first.  Better than that would be to not allow the client to pick that date to begin with.  This could be coded or depending on your interface and data source there are probably plugins.