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
Restrict date range on a form
+3Best answer by TheTimeSavingCo
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
+31I 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
+3I 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
Ah, gotcha. Thanks for your advice!
+35HI
One of the easiest ways to restrict date ranges on a form to a dynamic date range — such as “this date can’t be more than 2 months from today” — is to use Fillout’s advanced forms for Airtable.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields on forms, and much more.
In terms of setting a dynamic date range in Fillout, check out the screenshot below.
I also show off a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.