# I used the Google Calendar integration and facing issue with the Time that I filled with the time it is showing on the calendar

**URL:** <https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405>\
**Category:** Ask for Help\
**Created:** [December 6, 2023, 6:28am UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405 "2023-12-06T06:28:26Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brij\_Mohan\_Sharma](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brij_mohan_sharma/32/63672_2.png) [@Brij\_Mohan\_Sharma](https://community.glideapps.com/u/Brij_Mohan_Sharma)\
**Post date:** [December 6, 2023, 6:28am UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/1 "2023-12-06T06:28:26Z")

</div>

Hey Glidder I used the Google calendar integration and applied it using the form submission to create the event in the calendar and the issue is that the time which I am specifying is not correctly updated on the calendar, let’s say for example I am specifying the time would be 09:00 am to 09:30 am but It get updated as 05:00am to 05:30 am which is incorrect, please If anyone knows why it is behaving like that ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 6, 2023, 6:34am UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/2 "2023-12-06T06:34:18Z")

</div>

It’s probably a timezone issue. Is your timezone UTC+4?  
What is your data source?

---

<div class="post-metadata">

**Author:** ![Brij\_Mohan\_Sharma](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brij_mohan_sharma/32/63672_2.png) [@Brij\_Mohan\_Sharma](https://community.glideapps.com/u/Brij_Mohan_Sharma)\
**Post date:** [December 6, 2023, 6:36am UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/3 "2023-12-06T06:36:09Z")

</div>

I don’t know how to check for it ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 6, 2023, 6:38am UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/4 "2023-12-06T06:38:53Z")

</div>

Your data source?  
Is it Google Sheets, Airtable, Excel, Glide Native Tables…?

---

<div class="post-metadata">

**Author:** ![Brij\_Mohan\_Sharma](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brij_mohan_sharma/32/63672_2.png) [@Brij\_Mohan\_Sharma](https://community.glideapps.com/u/Brij_Mohan_Sharma)\
**Post date:** [December 6, 2023, 6:42am UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/5 "2023-12-06T06:42:15Z")

</div>

yeah, Google Sheet is my Data source. you are correct it is the time zone problem, my time zone is

 ![Screenshot (37)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/2/a268d57379ed21fd668b2ff2e5b7451941422ad7.png)

Now, it will be visible to you I guess, so whatever the time that I am specifying the it get +05:30 ahead, How can it be solved ?, I changed it to the +0:00 universally but it is behaving the same

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 6, 2023, 2:28pm UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/6 "2023-12-06T14:28:56Z")

</div>

Can you show us the columns you’re using to populate the Google Calendar integration? Are they stored in Glide Tables, Google Sheets or somewhere else?

---

<div class="post-metadata">

**Author:** ![Brij\_Mohan\_Sharma](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brij_mohan_sharma/32/63672_2.png) [@Brij\_Mohan\_Sharma](https://community.glideapps.com/u/Brij_Mohan_Sharma)\
**Post date:** [December 7, 2023, 7:11am UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/7 "2023-12-07T07:11:51Z")

</div>

> [@ThinhDinh](#):
>
> Are they stored in Glide Tables, Google Sheets or somewhere else?

I solved this problem, Solution to this problem is we can make a new column named “New Start Date” where we can use the concat(start time, -5:30) Gsheet formula in my GLide app column and now I can use this column which will update the desired time in the google Calendar.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 7, 2023, 3:05pm UTC](https://community.glideapps.com/t/i-used-the-google-calendar-integration-and-facing-issue-with-the-time-that-i-filled-with-the-time-it-is-showing-on-the-calendar/68405/8 "2023-12-07T15:05:13Z")

</div>

Wouldn’t you want to use the template column if it’s purely for concatinating info?
