Activate script when I check the CheckBox

AppSheet AppSheet Q&A
1

Hello everyone, I used a translator to explain the following. I created my first Appscheet, and I have to admit that the results were excellent. The only thing that doesn’t work well is the following. The Google Sheet that I linked is made up of the tab called Registration that contains 7 columns. In the seventh column the G contains a CheckBox for each row. Inside the sheet I inserted a script that allows me, when I check the CheckBox, to copy the row into the Tab called Archive. If I intervene on the Google sheet everything works perfectly, but if I do it through Appscheet, it checks the sheet, but does not activate the script that copies the row into the Archive tab. Where am I going wrong? Thanks for your help.

2

I believe you have your script set to run on onChange event. Changes made via AppSheet unfortunately do not fire this event.

You have two choices as far as I can see.

  1. Call the script via Appsheet bot, which requires a Core license or above. Also the script needs to be an unbound type.

  2. Run the script on schedule.

1 Like
3

Thank you for your reply, I confirm that the script is of the onEdit type. I did further research and the final result said that to activate the script, you necessarily have to act on the gSheet sheet