How to Integrate Google Apps Script & Trigger with an AppSheet App

ANJ_dev:

Hi!> thank a lot for your article, it helped me add power juice to my Appsheet app.> > I have a problem with the installable OnChange Trigger. the Event object always have the value “EDIT” on e.ChangeType. This do not help me atteind my goal :> > I want to run some code when a row is added from my Appsheet app and run another code when a row is removed/deleted from my Appsheet. but for the two actions (add row or delete row) the trigger event object have the same ChangeType == “EDIT”> Appscript seems not able to distinguish between row add or row delete> > How can I distinguish the two event?> > Thanks

That’s nothing to do with AppSheet. All the interactions with the sheet (either it’s an add, edit or delete ) it’s an EDIT procedure/event. What’s your goal? What are you trying to do?