Help

Form that links to a record of dates- how to have dates expire

Topic Labels: Base design
Solved
Jump to Solution
513 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lila
4 - Data Explorer
4 - Data Explorer

Hello, I have set up a form that has a dropdown menu of dates. I’ve linked them to a table of dates.

Things I need help figuring out:
1) I need the dates to only be available in the dropdown menu if they are at least 24 hours from the current date.
2) I need the table of dates to auto-populate for every Mon, Wed, and Fri and to each have a label depending on the day.
3) I would like to include a time with the date table as well, they are all at 4pm EST but I have had trouble with timezones before.

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

Hi @Lila

  1. In your table of dates, create a view called tomorrow. Apply a filter to only show records where date is tomorrow. In another table add a filed that is link to another record > Dates table, Limit Selection Record view to Tomorrow. Add this field to your form and only those dates will be selectable.
  2. An automation can create update a record on a schedule
  3. Here is some documentation on working with Time Zones:https://support.airtable.com/hc/en-us/articles/360058239594

See Solution in Thread

1 Reply 1
Vivid-Squid
11 - Venus
11 - Venus

Hi @Lila

  1. In your table of dates, create a view called tomorrow. Apply a filter to only show records where date is tomorrow. In another table add a filed that is link to another record > Dates table, Limit Selection Record view to Tomorrow. Add this field to your form and only those dates will be selectable.
  2. An automation can create update a record on a schedule
  3. Here is some documentation on working with Time Zones:https://support.airtable.com/hc/en-us/articles/360058239594