Hi, I'm fairly new to Appsheet and have been building an app for one of my teams at work.
One aspect is a "jobs" section where jobs can be booked, then progressed from "requested" to "confirmed" to "completed" and this is linked with a calendar.
I've successfully added a Google Calendar as a data source, and used the following method to get my app to add jobs to the calendar and also to delete then re-add job events to the calendar if the job date is altered in the app.:
https://dev.to/kevlatus/syncing-calendar-events-with-appsheet-5pm
What I'd like to happen is also the reverse: when a user edits a job date in the google calendar outside the app (i.e. on a PC or other device where they don't have acces to the app) then the date of the related job in the app is also changed.
I've tried playing with the input expression as per the following method:
https://www.googlecloudcommunity.com/gc/Tips-Tricks/Using-INPUT-to-update-another-table-using-a-valu...
But I can't figure out how to get the app to see edits to the calendar and trigger an edit to the date of that specific job in the app.
Is what I'm trying to do possible? Any help would be much appreciated.
LinkedIn
Twitter
