I’ve written a google script that inserts values into specific columns on my transactions sheet when changes are made to that sheet. It works for any changes I make manually, but doesn’t work when I use the tiller functionality to add a manual transaction. Does anyone know how to make the trigger work in this case?
I haven’t been blocked by this before, @gadreyfus, but that is likely to avoid an infinite loop of triggers. You can imagine if your script performed a spreadsheet action onEdit
then your automated process will invoke the trigger… infinitely.
Actually onEdit triggers don’t action via a script. Only manual changes in the sheet trigger the onEdit