This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I spent the last hour seeking a such functionality in Appsheet, until I
landed in this topic. I could not imagine it doesn’t exist in Appsheet.
So I up-vote too. it would be extremely helpful
Good day all, I solved the problem that I myself posted here and would
like to share, if you ever meet the same issues as me. In fact, I was
faced more with a design problem than a technical problem. Let me
explain myself : I wanted to deal in real t...
LeventK: Provided you access the sheet via Sheet API then you can
control that. With onChange(e), every interaction with the gSheet itself
( on a workbook basis, not single sheet level ) is considered as an EDIT
EVENT Object. I will find another way ...
The worse is, sometimes I remove a row ChangeType is set correctly to
ROW_REMOVE and sometime to EDIT, same when I insert a row. So the
ChangeType seems not to be reliable. To handle that, I added a modified
a lil bit yor code like this if (e.changeT...
You right with your assertion. So you suggest me to check for the first
column to see if it has or not a value, to infer if it as a creation vs
a deletion? I did not though about it… I will try and let you know…
Thank you i still wonder why GAS’s eve...