I have an app that is really just a background workflow–there is no UI. It’s set up to kick off a bot when a row is added to my primary table. I’ve added multiple rows to the table, and yet nothing happens. There doesn’t seem to be an obvious way to troubleshoot why.
Any ideas how to determine why the event is not being recognized?
/trigrman
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Bot-not-working/m-p/227742
A similar question was asked before.
Check it out to see if it helps
Well, it definitely mentioned some things I did not know, like you needed to enable a setting within Google sheets so that AppSheet would know that a record was added.
The thing is, though–that didn’t do anything. The event is still not triggered.
https://help.appsheet.com/en/articles/4865326-bots-the-essentials
ReReading your initial post got me thinking
You are not updating your tables directly in your underlying data store by any chance since you don’t have any UI?
That does not trigger bots.
External eventing only works for changes made manually to the spreadsheet–by a person using a keyboard and mouse. Automated changes that modify the spreadsheet will not trigger AppSheet Automation.