New answers tagged google-forms
0
votes
Accepted
Trigger script to share calender with new user whenever form updates sheet with a new email address
The form submission doesn't trigger the onEdit(e). You need to use an installable trigger and can key off the form submission using onFormSubmit().
See:
onFormSubmit()
Simple Triggers
Installable ...
Top 50 recent answers are included
Related Tags
google-forms × 576google-sheets × 260
google-apps-script × 122
formulas × 30
google-drive × 20
google-workspace × 17
google-sheets-query × 15
google-sheets-arrayformula × 15
google-apps-script-triggers × 10
google-docs × 7
gmail × 6
google-account × 5
regex × 5
data-validation × 5
google-sheets-form-submissions × 5
email × 4
google × 4
links × 4
vlookup × 4
automation × 4
google-sheets-timestamp × 4
conditional-formatting × 3
import × 3
javascript × 3
google-sheets-dates × 2