I have a google script that is triggered to run when a cell is edited or changed. When AppSheet adds or changes records, it is undetected. Does anyone know how to have AppSheet changes / additions recognized? +Alex Lenhoff
Phil_Renda (Phil Renda) #1
Aleksi_Alkio (Aleksi Alkio) #2
Instead of using onEdit, you need to use onChange.
Phil_Renda (Phil Renda) #3
onChange does not recognize row edits made by Appsheet, only adding a new sheet or removing a column
Aleksi_Alkio (Aleksi Alkio) #4
Yes it will. We have made many apps with onChange.