Feb 23, 2023 02:55 PM
I'm wondering if there is a way to restrict a date field to a range of dates. We have a base that grants people access to our website. In order to get access, they need to fill out a form saying how long they need access for, but we want to restrict it to dates that are 1 or two months from now so they don't put 2025 or something ridiculously far away. Does anyone know how I could accomplish this? Thanks!
Solved! Go to Solution.
Feb 23, 2023 11:51 PM
I don't think this is possible with Airtable forms I'm afraid
If I were you, and assuming confirmation emails get sent after the form gets submitted, I think I'd just throw in a disclaimer in the form that says bookings can only be made 2 months from today. Then I'd add a "Created Time" field to the form submissions table, run a formula check to see whether the selected dates were past two months, and then just send them a rejection email heh
Feb 23, 2023 11:51 PM
I don't think this is possible with Airtable forms I'm afraid
If I were you, and assuming confirmation emails get sent after the form gets submitted, I think I'd just throw in a disclaimer in the form that says bookings can only be made 2 months from today. Then I'd add a "Created Time" field to the form submissions table, run a formula check to see whether the selected dates were past two months, and then just send them a rejection email heh
Feb 24, 2023 11:14 AM
Ah, gotcha. Thanks for your advice!