On edit Trigger is not working from Appsheet

AppSheet AppSheet Q&A
1

Hi

I have an appsheet app which on adding a new entry, trigger is need to fire which call my app-script function call API and gives values back in google sheet.

This works fine if a new row is added directly from google sheet trigger is fire. But same google sheet when connected to appsheet a new row is seen in google sheet but trigger is not fired.

Can anybody help me to resolve this?

Any help is appreciated.

2

Please share your bot’s config

3

You need to use onChange instead. Or just call the script directly from an Appsheet Bot.

1 Like
4

Thanks Marc for the reply. But I have tried on change trigger it doesn’t work for me.

As soon as I add anew row from google sheet, it works only and not from appsheet.

5

Could you please elaborate. How to call the script directly from an Appsheet Bot.

Because On Change trigger is failing.

Thanks

6

Search of help docs for onEdit

7

Thanks for your help!

This search for onEdit clears most of this issue.

1 Like