LinkedIn
Twitter
Hello,
We are currently building an “inspection type app”. Basically we have one table that represent an invoice associated to this invoice we can have one or multiple event.
We need the event to be displayed in google calendar.
I am seeing multiple options and I can’t find a good one.
Only send an event in google calendar via action: this is working but it won’t work well if I edit or delete related invoice.
Add the google calendar in the data table, I can’t find a way to link the invoices to the event using a ref. Can it be done using a virtual column?
Create the event in AppSheet and then based on this event create the google calendar event. This is pretty simple for creation using workflow rules but harder if I want to edit or remove the calendar event. My other concern is that the data from google calendar is plus and minus 90 days. What’s happening if I go further.
I hope it all make sense, maybe my best bet is to tell people not to use google calendar for this worklfow?
Any thoughts and ideas are welcome 
