Help

Re: Different timezone with automation from google sheet to AT

Solved
Jump to Solution
196 0
cancel
Showing results for 
Search instead for 
Did you mean: 
SpelaU
7 - App Architect
7 - App Architect

Hi guys!

I'm using Ubiqod for attendance tracking in our company. When you scan code, you click on the correct button (arrival, break, going home). After you submit it, the data comes to google sheet and with automation it gets to the Airtable. 

Now the problem occured. The timestamp from the google sheets it's not the same in the airtable. My guess is that this has got to do something with the different timezones. In googlesheet it's correct timestamp, in airtable it's 2 hours later.

This is timestamp from google sheet:

SpelaU_0-1715776296498.png

This is timestamp from AT:

SpelaU_1-1715776335812.png

How can I transform this date in AT so that the hour will be correct (it was supposed to be "14:07" not 16:07). 

Thanks!

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

It's likely that it's a display issue and not a data issue.  Could I confirm your date field is set to the desired timezone? 

Screenshot 2024-05-16 at 10.19.49 AM.png

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

It's likely that it's a display issue and not a data issue.  Could I confirm your date field is set to the desired timezone? 

Screenshot 2024-05-16 at 10.19.49 AM.png

SpelaU
7 - App Architect
7 - App Architect

Omg, it's that simple. This was the issue yeah. Thank you @TheTimeSavingCo !

JeromeSkiply
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi @SpelaU, Jérôme here from Skiply team (Ubiqod publisher).

(Thank you to @TheTimeSavingCo for the solution).

Do you think that a native integration of Ubiqod with Airtable could be useful? You can already use webhooks to link both systems directly, but it is always interesting to have feedback.

Jerome - Skiply CTO - Ubiqod Publisher
JeromeSkiply
5 - Automation Enthusiast
5 - Automation Enthusiast

If it helps, here is a tutorial to connect Ubiqod to Airtable to create a timesheet with webhooks (without Google Sheets): https://www.skiply.eu/en/docs/airtable-timesheet/

You can also use Make or Zapier, but the webhook system of Airtable is so good that I don't really see an interest to do so.

Cheers,

Jerome - Skiply CTO - Ubiqod Publisher