indirect trigger of bot that calls script

[alexstory]

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?

[WillowMobileSys]

If I understand correctly, the Description combines data from other tables.  When OTHER table data is changed you wish for the Bot to execute but it doesn't.  Do I have that right?

When a table column uses an expression the collects data or computes results base on values in other tables,  that expression is not automatically executed.  You would have to force an edit/change to that table row containing the expression.  

For your use case, I would move the Description column and expression to a Virtual Column.  The Virtual Column will update automatically, change the Description and that will trigger the Bot as if you had edited that row directly.