I’m so glad you made a video on this. Super helpful. I’ve run into time formula issues many times, and almost threw my 486 across the room. This answered a lot for me.
I am having a hard time sending a "daily digest" set up through an Airtable automation because it is not sending the start time with my local time zone. It is sending the time in UTC, but the "GMT" option is toggled off in the field. HELP!
Great video! I am currently working on managing a Volunteer Data base and gathering their information which is not the difficult part. The struggle I currently have is on how to record their time without creating duplicate entries for returning volunteers. Any ideas on how to better manage this?
Hi Gareth! Thanks for making this video. This cleared a lot up for me. So if we have a team, we essentially don't have to do anything to the dates since AirTable is already set up to work with the time zone set up in our computer.
That’s good information but I still haven’t figured out how to accurately adjust for daylight savings time. Everything is always an hour off during DST and I can’t seem to fix it.
Good video. However, I've noticed that when you run the TODAY() formula inside another formula, it always returns "TODAY" as whatever current day it is in GMT. For example, I am trying to figure out if today is after a project start date with the following formula: IS_AFTER(TODAY(),{Start Date_CST}). I'm in CST time, but the TODAY() formula returns the GMT date. This throws off the whole formula. Know of any work arounds?
Yeah, you'll want to nest a timezones formula in there too tell Airtable to adjust from GMT. If that doesn't work, add or subtract the number of hours to reach your timezone. Not sure why Airtable does this, but it's a common issue
My issue is that my automated emails go out at like 1 am - when the automation is set to go out "when date is today". I tried setting a time on the base but that made no difference. How can I automate emails to go out but at an appropriate business hour. It can't be at a scheduled time as the dates are all different
@@GarethPronovost Thanks for getting back to me. I have set it to "when the date is today" but it still sends it out at like 1 am. I'm not sure how to rectify it
Join us for our *FREE LIVE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration
I’m so glad you made a video on this. Super helpful. I’ve run into time formula issues many times, and almost threw my 486 across the room. This answered a lot for me.
Finally I understand my problem!! Thanks a LOT!
I am having a hard time sending a "daily digest" set up through an Airtable automation because it is not sending the start time with my local time zone. It is sending the time in UTC, but the "GMT" option is toggled off in the field. HELP!
Are you building this digest automation inside of your Airtable Automations?
Great video! I am currently working on managing a Volunteer Data base and gathering their information which is not the difficult part. The struggle I currently have is on how to record their time without creating duplicate entries for returning volunteers. Any ideas on how to better manage this?
Typically we see a record created for time entries that links to the user. Allow them to add a start and end time for each record
Hey Gareth is there a way to pre-populate holidays in an airtable calendar?
They would need to be added manually, I'm afraid
Hi Gareth! Thanks for making this video. This cleared a lot up for me. So if we have a team, we essentially don't have to do anything to the dates since AirTable is already set up to work with the time zone set up in our computer.
Exactly!
That’s good information but I still haven’t figured out how to accurately adjust for daylight savings time. Everything is always an hour off during DST and I can’t seem to fix it.
Good video. However, I've noticed that when you run the TODAY() formula inside another formula, it always returns "TODAY" as whatever current day it is in GMT. For example, I am trying to figure out if today is after a project start date with the following formula: IS_AFTER(TODAY(),{Start Date_CST}). I'm in CST time, but the TODAY() formula returns the GMT date. This throws off the whole formula. Know of any work arounds?
See the "anomaly" referenced in this video - ruclips.net/video/WwgQTwsfpL8/видео.html
Yeah, you'll want to nest a timezones formula in there too tell Airtable to adjust from GMT. If that doesn't work, add or subtract the number of hours to reach your timezone. Not sure why Airtable does this, but it's a common issue
My issue is that my automated emails go out at like 1 am - when the automation is set to go out "when date is today". I tried setting a time on the base but that made no difference. How can I automate emails to go out but at an appropriate business hour. It can't be at a scheduled time as the dates are all different
You can choose a different trigger to send emails at a scheduled date/time
@@GarethPronovost Thanks for getting back to me. I have set it to "when the date is today" but it still sends it out at like 1 am. I'm not sure how to rectify it