Join us for our *FREE LIVE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration
@User_PC_Loadletter
3 жыл бұрын
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.
@chantalencalada7010
3 жыл бұрын
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!
@GarethPronovost
3 жыл бұрын
Are you building this digest automation inside of your Airtable Automations?
@williamho161
3 жыл бұрын
Finally I understand my problem!! Thanks a LOT!
@AndresAndrade-k6o
8 ай бұрын
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?
@GarethPronovost
8 ай бұрын
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
@Londya
3 жыл бұрын
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.
@GarethPronovost
3 жыл бұрын
Exactly!
@TheRemyRomano
3 жыл бұрын
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.
@techcavetoday
2 жыл бұрын
Hey Gareth is there a way to pre-populate holidays in an airtable calendar?
@GarethPronovost
2 жыл бұрын
They would need to be added manually, I'm afraid
@HannahBrewster-mt2uh
Жыл бұрын
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
Жыл бұрын
You can choose a different trigger to send emails at a scheduled date/time
@HannahBrewster-mt2uh
Жыл бұрын
@@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
@KevinJones-uj2im
3 жыл бұрын
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?
@KevinJones-uj2im
3 жыл бұрын
See the "anomaly" referenced in this video - kzitem.info/news/bejne/uK2dt4itrJihf20
@GarethPronovost
3 жыл бұрын
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
Пікірлер: 18