Help

Forcing date options to be 3 days out in form

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

Hi! On a form I’m trying to create, I’m trying to ask users their first preferred date for a booking. However, I would need the date field to only allow users to select a date at least 3 business days out from the current date that the user is filling out/viewing the form. Is this a feature that is available, or is there a user friendly work around for this?

1 Reply 1

Welcome to the Airtable community!

Airtable forms cannot enforce this with a date field. One alternative is to used a linked record field to a table of dates. You would have to create all the dates in advance, then add a filtered view to only show dates at least 3 business days in the future. You would probably need a formula field to calculate how many business days each date is from the current date. Then in the form limit record selection to the filtered view. Your users would loose the calendar picker and have to use a drop-down record picker instead.

Or you can go with a third party form system that has advanced data validation features.