I have existing apps that are not integrated with Google Calendar. They are basically mini CRM (customer relationship managment) apps that book appts for customers. So I have a relationship between customers and appointments. My calendar shows the data from within my appointments sheet.
My customers are wanting to integrate the existing AppSheet Calendar with Google Calendar.
I've gone through the process of adding the data source and I have a Google Calendar view that syncs.
My question is, what is the best way to take all of my existing appointments and have them sync to google calendar.
I feel like the client should be able to use CRUD on appointments of a certain status (i.e. personal entries) but with formal appointments, they are removed from the calendar view by changing a status to "Cancelled" for example so those I wouldn't want them to be able to update from Google Cal.
What's the best way to do something like this? For example, in Appsheet I have a bot to update the google cal on changes but how do I grab the right appt to delete in google cal if I'm setting an appt to cancel in AppSheet vs just an update.
Is the best way to basically manage two calendar tables?
LinkedIn
Twitter
