Date from Google Calendar to Smartsuite

Getting Started
,
1

Hi,
I am quite new to Make, so excuse me if this is a simple question.
I am trying to map the start and end date from google calendar to a date range field in smartsuite. I have tried formatting different ways, but it never actually populates into smartsuite. Does anyone have any advice for me? Thank you.

image
image1113Ă—496 43.9 KB

image
image907Ă—142 5.68 KB

3

Hi GH,

If I well understand, you want to compute a duration, there is an interesting sub-subject here.

Hope this helps.

PBI

2 Likes
4

Hi @GH

To solve your issue, please check the format that support in the “Hours worked” field. Map the value accordingly with the format.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

1 Like
5

I finally got it to populate, but it’s putting the wrong times. how do i solve it?

image
image521Ă—563 36 KB

image
image1106Ă—80 3.3 KB

6

What do you mean by: " it’s putting the wrong times" ?

1 Like
7

Ex: in Gcalendar it says 9:45 pm, in Make outcput it also says 9:45 pm, but in Smartsuite, ts coming up as 4:45 pm

8

Which timezone do you use?
It could be a “problem” between your local time and UTC…

2 Likes
9

I use EST, GCalendare is set to EST, I put it into the [format date] formula, and Smartsuite is also set to EST.

1 Like