Creating event in google calendar

  • 0
  • 2
  • Question
  • Updated 8 months ago
  • Answered
Is there a native solution to send an event to Google calendar from my app? 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
If you set up your google / gmail setting the right way you can send a notification (email) that has the details, and it will automatically get added to your calendar.  Its more of a combo of your app notifications and google settings.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Ours is a corporate gmail.  So really not in my hand how to set it up.  But if it is easy enough to send an event, will appreciate hand holding. 
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
90% of it happens on the google side, so you'd need access to that.  But your QB notifications just needs to have some key data points in it, and gmail will recognize it and add an appointment (if your google settings are designed that way).
Photo of Elena Larrabee

Elena Larrabee

  • 856 Points 500 badge 2x thumb
Hi! I'm trying to do the same thing, but I'm having trouble formatting the notification email with the correct data points... How would you recommend formatting the email?
Photo of Harrison

Harrison

  • 462 Points 250 badge 2x thumb
Another suggestion would be to use Zapier. Send a webhook from Quick Base and then add the event to Google. https://zapier.com/zapbook/google-calendar/
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks a lot.  A good solution. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
I managed to create one event using a table I created where I simply record the history of changes made to certain dates.  However, this is not ideal arrangement.  Zapier works off legacy updates and they say that event can change if a new event date is updated. But issue is how do set up my QB table so that it creates a new record but gets updated each time I change the date projects table.  As otherwise I will end up creating several events for the same project.  Is there a setting in webhooks that updates the previously created record? 
(Edited)
Photo of Harrison

Harrison

  • 462 Points 250 badge 2x thumb
Im not sure I fully understand the issue. Can you perhaps rephrase? If needed, you can only send webhooks on add and/or update. You could also store any necessary unique IDs in Quick Base to pass back to Zapier for future use.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks. never mind  I will seek some help from Zapier guys on how to get updated event. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
As it turns out Zapier is really a limited solution as it only works for a small table and that should not be parent table.  Wonder if there is any other option. 
Photo of Harrison

Harrison

  • 462 Points 250 badge 2x thumb
Can you clarify what you mean? Zapier doesn't really have hard limits on the size of a table in Quick Base. You can also string together multiple actions as needed.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Following is the response I received from Zapier: 

"Thank you for letting me know. Unfortunately, after doing a bit of research on this, it looks like we aren't able to access those parent tables with the way the Quickbase integration is currently set up. 

I can create a feature request for us to look into this further and potentially add it in the future, and add your vote to the subscribe list for this feature. While I can't say for certain when this will get added, that will make sure we'll let you know as soon as it is."
Photo of Harrison

Harrison

  • 462 Points 250 badge 2x thumb
I'm still not quite sure what you are trying to achieve but am happy to help with some detail. You can access any data you want inside of Quick Base if you use the Webhooks by Zapier application and perform API_DoQuery, API_EditRecord, API_AddRecord, etc.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks. As the subject of this thread implies, I was merely trying to create an even in the Google calendar and as most dates are in the projects table, I am unable to achieve that through Zapier.  Sp hoping for some alternative or may be a code based solution.  
Photo of Harrison

Harrison

  • 462 Points 250 badge 2x thumb
Can you just bring the dates in as lookups in Quick Base to the child table? I'm not clear where the parent table issue is coming into play.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Zapier have concluded that if there is parent table, Zapier won't show that as an option and I did find that too.

The look up solution can possibly work at child level but whether the trigger works when record changes, that is a question.    
Photo of Harrison

Harrison

  • 462 Points 250 badge 2x thumb
Where is it that they are telling you lookup fields won't show? I'm sorry, I'm trying to help, just not sure where the issue is there. If you didn't want the lookups, you could just add an API_DoQuery (no code needed, just configuring the webhook). But lookup fields definitely are available in the production Quick Base app on Zapier in the new row trigger. If you give me some more information about the data structure and workflow, I'm sure I can help.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Many thanks.  I will work on your suggested solution. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Hi Matthew & Harrison, sorry to take you back on this.  I re examined the whole thing. All I wantd to do was to lift start and end dates of project completion in my app and create an event in Google calendar.  Previously I tried Zapier but it would not work as the primary table had far too many records for Zapier to deal with and the table itself was not visible as it was a parent table to a few children.

In the latest attempt, I created another table and set up two QB actions to add and update records in the child table limiting irecords n terms date range, that is, only report on projects opening next 6 months.  I then established a Zap but after a lot of toing and froing with Zapier support, they were supportive though). Turns out that I cannot really do what I need to.   I received the following response from Zapier support:

"Unfortunately, Zapier does exactly work like that. A Zap is made up of Triggers and Actions (as you're familiar). In your case the Trigger is a new row in Quick Base, meaning that each new row you add after you've turned on your Zap will be turned into an event.

"Anything created before the Zap was turned on will not be pushed through the Zap. In some situations, we can work around this by using an Update Row Trigger, but Quick Base doesn't have one of those. There is currently a feature request open for it."

I suppose I can deal with the addition of new records but updating records after Zap is turned on what is of great importance to us send updates after date change. 

So I am now resorting to  Matthew's earlier comment: 

"If you set up your google / gmail setting the right way you can send a notification (email) that has the details, and it will automatically get added to your calendar.  Its more of a combo of your app notifications and google settings."

Would you be able to help me on this? 

Harrison, do you have further guidance on using Zaps. 
  
Photo of Harrison

Harrison

  • 462 Points 250 badge 2x thumb
Yes, this should be easily solvable by using Webhooks by Zapier as a trigger with a Catch Hook, rather than Quick Base as the trigger. You can then set Quick Base to fire a trigger and even use repeaton and repeatoff to create a JSON array which Zapier can natively parse.

This conversation is no longer open for comments or replies.