Creating event in google calendar

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.

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.

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.  

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.

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.    

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.

Many thanks.  I will work on your suggested solution. 

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. 
  

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.