Webflow Form to Google Sheet - Wrong Data for Time Submitted

Hi, so I build a connection of webflow form and google sheet, so every form submitted will add new row on gsheet and input the data there, and it works perfectly, but the submit time data from webflow is wrong, how do I fix this?

For context : submitted at will populate “Waktu Submit” (Submit Time) cell

I thought the problem was on the webflow timezone, but it’s correct

Here’s the google sheet rows, and let me tell you, the time is wrong lol, it should be using Indonesia’s time, but it’s wrong, and I don’t know how to change it

I think it’s wrong because it’s taking data from Make’s time zone (?), but I don’t know how to change it, any ideas?

Thank you!

Welcome to the Make community!

You’ll have to translate the datetime into English before you can use/parse it.

For more information, see parseDate does not work for German Month names of March/May/October/December

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

1 Like

thank you for your response,

I think the problem is not that, I’m fine with the current format, but the time is wrong, I think it’s from different time zone, and I wonder how do I change the time zone received by make, I think the problem is from make time zone, not webflow because like the screenshot I provide it’s on the correct local time zone,

so I think the better question is how do I change time zone of the received data on Make? thank you!