• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Help with Formatting 24-Hour Time from Google Forms for Google Calendar

Status
Not open for further replies.

NITE

Member
I'm setting up a workflow where I need to create Google Calendar events from a Google Form submission. I've got everything mapped out in Pabbly Connect, but I’m running into an issue with formatting the time correctly. The time from my form is in 24-hour format (HH:mm:ss), and I need to convert this to the ISO 8601 format required by Google Calendar (YYYY-MM-DDTHH:mm:ssZ).

The specific problem is that the year is showing as "20248" when it should be "2024", and the time is shifting from "8:00:00" to "02:00:00", which is incorrect. I’ve checked my Date/Time Formatter settings, and it looks like I'm not selecting the correct 'From Format' since all options include AM/PM, and there isn't an option without AM/PM for a 24-hour format.

Has anyone faced this issue before or could provide guidance on the correct way to format the time for Google Calendar using Pabbly Connect? Below are the details of my current setup for clarity:

  • Date from Google Form: 2/04/2024 8:00:00
  • Expected format for Google Calendar: YYYY-MM-DDTHH:mm:ssZ
  • Timezone: Europe/Madrid
Your insights or suggestions would be greatly appreciated!
 
P

Pabblymember11

Guest
Hey @NITE

Can you please share the workflow URL once in which you have experienced the same?
 
P

Pabblymember11

Guest
You have to change the time format and the Timezone from your "Google Calendar" action event since the data you are providing is already in UTC , so you do not need to change the timezone from your Google Calendar action event. Kindly change it to UTC to balance the Timezone when the event gets created.

However, with the help of Date Time Formatter, you can change the time zone to your desired time zone accordingly. Kindly review your workflow once we have made certain changes to it accordingly.

1712062016805.png


You can add a Date/Time Formatter to your workflow, subtract 2 hours from the time, and then map that time in Google Calendar.

1712062032800.png
 

NITE

Member
I appreciate the support provided thus far. However, I am still facing challenges with the Date/Time Formatter configuration. If it is possible, may I request the assistance of the Pabbly support team to directly make the necessary adjustments to my workflow configuration? Here are the issues that need addressing:

  1. The year is incorrectly being concatenated as 20248 when merging the event date and start time, resulting in an incorrect date format.
  2. I am unable to find a 'From Format' option in the Date/Time Formatter that accommodates a 24-hour clock without AM/PM, which my Google Form data requires.
If the support team is willing to make these adjustments on my behalf, I would be incredibly grateful. Please feel free to make the pertinent changes as deemed appropriate to correct the formatting issue, ensuring that the dates and times align correctly for Google Calendar event creation.

Should you require any additional information or access to perform these adjustments, please let me know, and I will provide it promptly.

Thank you very much for your time and assistance.
 
P

Pabblymember11

Guest
Hey @NITE

Please check your workflow once and then try again. I hope this will work for you.

1712126479178.png
 

NITE

Member
Thank you, I replicated the procedure for the end time.
however, when setting the google calendar block it returns bad request. Where is the errror?
1712159491337.png
 

NITE

Member
I don't know if you have modified anything, now the date is correct, but it books the time with extra +2 hours.
I booked from 9pm - 10pm and it shows at 11pm - 00 am in Google Calendar
 

ArshilAhmad

Moderator
Staff member
To fix this issue, you can add a Date/Time Formatter to your workflow to subtract 2 hours from the original time and then map the resulting time in Google Calendar. This will help you create events with the correct time in Google Calendar.
1712185570888.png
 
Status
Not open for further replies.
Top