Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

1st Google Calendar Integration - how to update / delete

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 e...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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's avatar
    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's avatar
    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's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew 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
      ------------------------------
      • JohnKulakowski's avatar
        JohnKulakowski
        Qrew Member
        2 years ago

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