In my Google Form to Google Detailed Calendar Event zap, the dateTime value assigned (TIME) is not being generated to the calendar correctly.
Instead, the zap is pulling my current time, but with the correct date data (DATE) assigned.
As you can see, the data from the sheet has a date value of 2/15 (correctly pulled by zap) and a time value of 7:30am which is incorrectly pulled by the zap.
The zap instead applies the current timestamp when the event is generated.
Hi
Check this help link:
There are a few reasons why events might be created for the wrong time or date by a Zap...
"Is your detailed event appearing in the calendar for the same time the Zap ran?
This may happen if the start and end time/date are invalid. Events created with an invalid start or end date will be created for the time your Zap runs"
This is the closest help tip to my problem, but how a default Google start and end time could be invalid doesn't track for me.
Can you provide screenshots of how the data is on the GSheet in order to trace and troubleshoot?
The TIME on the screenshot of the GSheet shows 7:30AM so it appears the Zap is pulling the correct data point value.
Try setting a different END TIME for the event.
e.g. Is the event 30 minutes long?
The end time is set to +1H spaced once from the time. And yes, it's seeing 7:30, but it's applying the time the zap generates the calendar event.
Please provide a screenshot of where you have the +1H set, thanks.
Why is “time” hardcoded for the End Date & Time?
It is the start time for a calendar event and then 1 hour from the start time. From a form question in Google forms. How else would one schedule a calendar event if not from a form input?
The word “time” should not be hardcoded in the End Date & Time.
So I have to name the time field something other than time because it breaks the zap? Lol...
Try replacing the hardcoded word “time” with a single space.
Oh! I see what you're saying now. I just have screen grabbed at the wrong moment, that's not how that field reads. It reads as:
And just for the record, it still generates the event start time consistent when the zap generates.
Try adding a single space between the dynamic variables for DATE and TIME in each of the Start/End fields.
That was it! Didn’t read any tips on that being a potential problem or a requirement so it didn’t occur to me; Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.