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!
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.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |