Templates Plugins Courses

Google calendar offline plugin invalid format


#1

Hi,

I purchased the google calendar +offline plugin recently but can’t seem to get part of it to work. My app has a calendar, and I believe I have successfully linked the in-app calendar to the current users google calendar when they sign in with it.

I would like when a user makes an event in their in-app calendar, for it to appear in their google calendar also. In the workflow I have a ‘create a calendar event’ step as follows:

(path) calendar_id: current users’ email
(header) content_type: application/json
(body) start_time: date/time picker A’s value
(body) end_time: date/time picker A’s value +(hours):1
(body) summary: Appointment with input e.g. John Smith’s value

However when I try it out, I get this error:

I’m not sure if it’s an error with the formatting of my date/time input, that maybe the google api can’t understand? Does anyone have any ideas?

Thanks
Charlie


#2

Hey Charlie, yes, indeed, the issue with the formatting of your dates.
here is the format used by Google and tested by us to work
2017-09-04T14:30:00+03:00
this date is passed as a text value, so you basically need to push a text string which would be compiled of pieces returned by Bubble date field.
If you struggle with that send a screenshot of how you try to do that and I’ll try to help you out
Thanks!


#3

Hi levon, thanks for your reply. I’m pretty sure I’ve got this wrong, is it just the ‘formatted as:’ i need to change?

Here’s what I’ve got now:

Cheers


#4

Looks good but instead hh:mm+hh:mm it should be hh:mm:ss+00:00
(you forgot to include seconds and the last +00:00 is the adjustment of the time zone which is not required I guess) - other than that it should be good to go, but give it a try and let me know if it worked.
Thanks!


#5

Hi Levon,

I’m still getting an error message but I think I’m nearly there, this is what I have now:

The error I am getting says:

invalid value for: invalid format:
“\2018-05-04P12:05:00” is malformed at “P12:05:00”

Thanks again


#6

I wonder why Bubble sends P when it should send T
I would suggest you open a bug report with bubble at https://bubble.is/bug_report


#7

ok I’ll do that now

Cheers


#8

Hi levon,

I’ve spoken to bubble support and they have said I need to include the T outside of the formatted as:, reason being that T has a preset value being the first part of PM if you write ‘tt’. I still cannot get it to work however, you don’t know how I should write this with that in mind now do you?

Thanks


#9

There is a way, I will try to describe it tomorrow morning.
Thanks!


#10

So, here is how to do that,
First, choose simplified ISO for “formatted as” expression (see screenshot)

next, add :find&replace expression as shown on this screenshot

and voila
image

Hope this helps


#11

Thanks levon! That works great now

Cheers