Email notification when user/respondent edits their Google form response NOT when the spreadsheet is edited

[Jason Krykewycz]

We use a google form to collect information from our volunteers. The admin works in the linked google spreadsheet. If volunteers have to update their details, they are asked to do so via the "Edit Response" link that we send to them after submiting the form initially (executed by a trigger in App Script).

I need to be notified when the USER edits their response through the "Edit Response" link. I am NOT looking to be notified when the spreadsheet has been edited. Any chance this can be done? I know the Sheet will palce a flag on the cell and note "Responder updated this value."

I am not a programmer! Ive just started tinkering with App Script to automate some processes.

Any help would be appreciated.

I searched online for help!

[💼]

Your Edit Response page needs to pass a param(s) when making a request to your script. The script will check the needed param(s) and react by executing a function to send you an email. 

On Jun 16, 2023, at 5:42 PM, Jason Krykewycz <jason.k...@solidrockbaptist.org> wrote:



--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/e71a7c3d-a822-4203-b361-5d16716b55a8n%40googlegroups.com.