How to trigger an action when a record is added externally in an MySQL server table

[jasemire]

Hello community,

I hope you are very well. I have managed to load my app with a data table from a Cloud Database (MySQL) . Even though I have selected updates/adds/updates, it is in a read-only state because I can't write to that server because I only have read permission.

I would like to trigger an action every time a record is added to the MySQL server table. But that record is added externally, not using the AppSheet. It is added using another app

I tried to do it with a bot that identify when a record is added to this table on the server and sends an email. That same bot works for other tables from AppSheet Database, but not for the one that is taken from the MySQL server, it's like it's not detecting when a row is added. Why is this possible?

Thank you very much in advance for your help.

Regards

[dbaum]

---

@jasemire wrote:

like it's not detecting when a row is added

---

Right--an AppSheet app does not detect a row added to a database via means other than the app.

Maybe you could have the row add performed via the AppSheet API, which does trigger automation events.

Another technique is to schedule an automation to periodically scan for new rows and trigger the action when they're present.

[jasemire · Accepted solution]

Thank you so much, I will try that way. Up to now, to handle that, I tried scheduling a bot that compares tables and adds rows when there are some differences. Thanks again!