Forum Discussion
- MCFNeilQrew CaptainIf 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.
- ArshadKhwajaQrew CommanderOurs 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.
- MCFNeilQrew Captain90% 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).
- ElenaLarrabee1Qrew CaptainHi! 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?
- HarrisonHerschQrew MemberAnother 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/
- ArshadKhwajaQrew CommanderThanks a lot. A good solution.
- ArshadKhwajaQrew CommanderI 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?
- HarrisonHerschQrew MemberIm 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.
- ArshadKhwajaQrew CommanderThanks. never mind I will seek some help from Zapier guys on how to get updated event.
- ArshadKhwajaQrew CommanderAs 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.
- HarrisonHerschQrew MemberCan 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.