I have a Pipeline "Pipeline Create" which adds an "Event" to a Google Calendar, when an entry is made in a QuickBase "Events" table. Yay.But I can't figure out how to update that Google Calendar entry when the Quickbase record is edited.The update step seems to want me to lookup an entry in the Google calendar and to specify an Event ID. But how to I set that Event ID in the "Pipeline Create" Pipeline which created the calendar entry?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

OK, I figured it out. (It sure would be nice to have some documentation on this stuff....)When you create the Calendar entry it will have a Google calendar Event ID. You need to create a field for that in Quickbase and have the last step of the Pipeline write that back into the Quickbase field for the trigger record.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Thanks for posting this Mark! This is super helpful, and maybe I can now fix my calendar issues.------------------------------Joe Hargrave------------------------------

Hi Mark:I have a pieline to create a google calendar event, based upon your post I created an Event ID field in the table and setup what I think would write the Event ID back to the field. The problem I have is it gives me the folloing error:Validation error: Invalid literal for Decimal: u'91cngbqaijr43d01nbbdt7i0jo'What should the value for Event ID be? I assumed numeric. Also, do I have the write back to update record correct?Sceen shot of my pipeline attached.Thanks, John------------------------------John Kulakowski------------------------------

The Event ID is a very long text string. Yes you would write that back to the native Quickbase record.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Hi Mark:Thanks for the help yesterday. Do you know if there is a way to create a field in a table and have it access the list of Google calendars, so the user is selectable?------------------------------John Kulakowski------------------------------

1st Google Calendar Integration - how to update / delete

MarkShnier__You
Qrew Legend
4 years ago
OK, I figured it out. (It sure would be nice to have some documentation on this stuff....)

When you create the Calendar entry it will have a Google calendar Event ID. You need to create a field for that in Quickbase and have the last step of the Pipeline write that back into the Quickbase field for the trigger record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JoeHargrave
  Qrew Trainee
  4 years ago
  Thanks for posting this Mark! This is super helpful, and maybe I can now fix my calendar issues.
  
  ------------------------------
  Joe Hargrave
  ------------------------------
- JohnKulakowski
  Qrew Member
  2 years ago
  Hi Mark:
  
  I have a pieline to create a google calendar event, based upon your post I created an Event ID field in the table and setup what I think would write the Event ID back to the field. The problem I have is it gives me the folloing error:
  Validation error: Invalid literal for Decimal: u'91cngbqaijr43d01nbbdt7i0jo'
  
  What should the value for Event ID be? I assumed numeric. Also, do I have the write back to update record correct?
  Sceen shot of my pipeline attached.
  
  Thanks, John
  
  ------------------------------
  John Kulakowski
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    2 years ago
    The Event ID is a very long text string. Yes you would write that back to the native Quickbase record.
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
ChristineWhite
Qrew Assistant Captain
2 years ago
Hi Mark,

I am attempting to create a google calendar event and was wondering about setting the time properly: Entering 12/15/23 02:00 PM in a quickbase Date/Time field in EST timezone, created an event at 7pm in Google Calendar. Thank you!

------------------------------
Christine White
------------------------------
- MarkShnier__You
  Qrew Legend
  2 years ago
  It looks like the Google Calendar is in UTC time, the same time zone as London England. I think that you need to subtract 5 hours from the date/time to get to eastern. (That may change when daylight savings time changes)
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - ChristineWhite
    Qrew Assistant Captain
    2 years ago
    That worked! Thank you
    
    ------------------------------
    Christine White
    ------------------------------
GeorgeBramhall2
Qrew Cadet
2 months ago
Hi Mark,
Have you since tried updating a Google Calendar event by Fetching a Linked On New Event (Linked Advanced) which is set in the Add event pipeline? This has worked for me without having to "write back" the Event ID.
Maybe you can help with the reverse, i.e. updating the "linked" QuickBase record when the Google Calendar event is updated. I have tried Fetching a QuickBase record by choosing the resource Event Updated from the Google Calendar event step, but I am not getting any activity for the pipeline when the Google Calendar event is updated. Interestingly, even though I show no pipeline activity, I am showing that the pipeline was triggered by the Google Calendar event update.
- MarkShnier__You
  Qrew Legend
  2 months ago
  I have not worked with that Google Calendar Channel lately so I can't answer a detailed question without a bunch of testing.
  - GeorgeBramhall2
    Qrew Cadet
    2 months ago
    Do you know anyone who has experience with the channel? Is there a QB technical resource that I could contact?

Forum Discussion

1st Google Calendar Integration - how to update / delete

Related Content

Adding a Google Calendar Event

Google Calendar Add Event Pipeline

Calendar Reports not Loading

Google API QR Codes not working?

Integrating Quickbase and FastField