LinkedIn
Twitter
Hello all,
I have a bit of a technical question about Appsheets way of editing the Google Spreadsheet that it uses for it’s Database.
I’m writing some Google Script on the Spreadsheet I’m using as Database for the App I’m making in Appsheet. It’s meant to send an email when a New Row is Added.
The Script works great, but when Adding a New Row by filling in a Form through the Appshet App it doesn’t fire the script onEdit or onChange as it would if that New Row was added via a Google Form.
Am I wrong on this, or is this true in your experience as well?
My workaround, in case anyone is looking for solutions here, is that I made a Mark column (“sent” or empty). Then I run the script as TimeDriven every half hour and check for the last 10 rows with data from the bottom to the top of the spreadsheet, then check for the mark and if it’s not sent then fire the “SendEmail” function and mark the column “Sent” so that on the next search, it wont send the email again.
And it works 
However, the thing is that if adding rows to the spreadsheet through filling or editing Forms in Appsheet is NOT recognized as an Edit or Change in the Spreadsheets Google Script, than you have to make these TimeDriven Functions and that’s really bad for two main reasons:
- you can’t get instantaneous actions to fire on filling up the form
- you consume a looot of resources.
(this one function takes a total of 30 minutes to run a day. and it only runs every half hour. If it where to run every minute … and it’s just one function … and it has to take all those resources, even if there was no filling of the form done that day and thus no emails sent)
Any idea on this subject?
It would be a huuuge gain to know that you could run OnEdit functions through Google Script when filling in or editing Appsheet Forms…either directly or through some workarounds if you know any.
Thank you,
Sorin
