Feb 21, 2020 06:41 PM
Is it possible to create a form that asks for a date range or for multiple dates to be submitted? Is there a workaround if not? All I’m seeing is that we’d have to have multiple forms submitted to cover multiple dates.
Thanks!
Feb 21, 2020 09:10 PM
A date field can contain only one date.
In order to enter multiple dates or a date range, you need to have multiple date fields. For a date range, you would need a {start date} and an {end date}.
A possible workaround is have your input field be a linked field, instead of a date field.
Link to a record
in that [calendar] table. Make sure to Allow linking to multiple records
.An added benefit of this method is that you can limit which dates users can pick by omitting those dates from the [calendar] table. For example, you can omit weekends and holidays. You can also setup the link so that it only allows users to select a filtered view of future dates.
A disadvantage is that users will not see a traditional date picker. However, they will still be able to start typing their desired date to quickly get to it.
Tip for quickly generating multiple rows of consecutive dates:
You can quickly populate the dates in the [calendar] table:
shift+enter
.Airtable will recognize that you increment the dates by one for each row and do the same when it fills the rows.