Skip to main content
Solved

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

  • April 21, 2022
  • 1 reply
  • 25 views
L
Forum|alt.badge.img

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.

Best answer by Vivid-Squid

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

1 reply

V
Forum|alt.badge.img+16
  • Vivid-Squid
  • Inspiring
  • Answer
  • April 22, 2022

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
ScottWorld
Terms & ConditionsAccessibility statement