Skip to main content
Question

1st Google Calendar Integration - how to update / delete

  • March 6, 2021
  • 0 replies
  • 343 views

MarkShnierYou
Forum|alt.badge.img+22
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • Author
  • Quickbase Alumni
  • March 6, 2021
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
------------------------------

Forum|alt.badge.img+9
  • Quickbase Alumni
  • December 13, 2023

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
------------------------------

GeorgeBramhall2
Forum|alt.badge.img+11

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.