Need a bot to be triggered by a data change (row add) from another app or outside process

I have two apps that need to "communicate" with each other.  Both edit the same spreadsheet, but only one adds new rows, the other only updates a particular column of existing rows.  I need a bot/automation to be triggered in the "update"-only app when the other app adds a new row.  Currently, the automation won't fire because the other app is adding the rows, it is not happening "natively" within the app.  How can I trigger this bot from rows added by the other app?  Surely this is possible.  Thanks!

0 2 69
2 REPLIES 2

One way to do it is 

1) create a "hidden" field in the table

2) add a bot in the "sending" app that fires when a row is added and in a step update the field via Appsheet API using the "receiving" App's appid

3) add a bot that fires when it detects the update performed by 2) in the "receiving" app

I tested this and 3) is fired but the change is not seen in the receiving app unless you sync it.

Hope this meets your requirement.

Thanks for the detailed help!  I will try this, but unfortunately the need for the receiving app to sync will likely not be acceptable to users.

Top Labels in this Space
OSZAR »