Get Google Form ID for edit

2019-08-26 21:52发布

问题:

I am using Google Form. I submit the form. How can I get a/the link for editing the answer of this form, by using Google Apps script?

I want to send an email containing a link for editing answers to multiple emails, instead of just 1 email (as google form provides).

回答1:

If you want the link to edit the "answers" already submitted,

function onFormSubmit(e){ //Trigger for this function installed from form(not spreadsheet)
    MailApp.sendEmail("recipient@example.com,recipient2@example.com",
        "Your form has a new response. Form response edit link below:",
         e.response.getEditResponseUrl());
}

References:

  • Form Submit Event Object
  • ResponseUrl
  • MailApp
  • Trigger Installation