I have a script that makes updates to google calendar events. I have a bot that calls this script based on updates to a table that contains the start, end, description etc. Everything works as it should when making changes directly to this table.
The description for the calendar event is compiled from an app formula that references data from tables all over the place and brings them all together into a neatly compiled event description.
What I'm trying to do is when one part of that description is updated from another table to automatically force the recalculation of the app formula (I've made the description a physical column hoping to be able to trigger the bot that calls the script).
What I've ended up doing is creating a bot within one of the other tables to update a helper column that records a timestamp in the table containing the description forcing the recalculation of the app formula which in turn I thought would trigger the bot that calls the script based on updates, but this isn't working.
When I invoke the action to update the timestamp directly from within the same table everything works as it should. When its triggered from the bot in a different table, everything on the backend google sheets works as it should but it wont trigger the bot to call the script...
Help?
LinkedIn
Twitter
