I'm building a base to track volunteer sign-ups for a project.
-
Table 1 stores Volunteer info
-
Table 2 contains available Timeslots
When a new volunteer signs up via a form on the Volunteer table, an automated email is sent confirming the timeslots they’re registered for.
The issue: When I include a grid of timeslots (using a Find Records step in the automation), all of the times are showing in UTC. I need them to display in EST.
Here’s what I’ve tried:
-
I created a formula field to convert the time to EST using
SET_TIMEZONE
, and also tried -
A single-line text field that gets updated by a separate automation
But when I try to include either of those fields in the grid, the grid shows the correct number of records, but all the cells are blank.
Has anyone figured out a way to include times in the correct time zone (EST) inside a grid in an Airtable automation email? Would appreciate any tips!