CODEWITHSUNDEEP
google-apps-scriptgoogle-forms
mor
mor

Reputation: 123

How to pass parameter to Form Submit handler in google apps script

I need to identify the user who submits the FormResponse so that next time he asks for the form I can redirect him to edit link with his prev answers. In https://developers.google.com/apps-script/guides/triggers/events#google_forms_events the handler is described. But I see no way how to pass parameter from prefilled form (with id of a user as prefilled parameter) to submit handler. Can it be done?

Upvotes: 0

Views: 1051

Answers (3)

Bjorn Behrendt
Bjorn Behrendt

Reputation: 1264

I wonder if you could publish a script as a webpage and get an alternative live link. That link would check the current user against a user field in the form. If they exist then it would redirect to the edit entry, if they don't exist it will redirect to the form submission form.

Upvotes: 0

Serge insas
Serge insas

Reputation: 46794

As mentioned in the other answer, this is intentional but there is an alternative that does not use Google Forms: you can use UiApp service or HTMLServiceto build a webapp working as a form that will ask the users to authorize access to their email identity.

Not so simple for sure but actually the only possible alternative.

Upvotes: 1

WillemS
WillemS

Reputation: 131

The thing is: you can't identitfy the user and on purpose so. Many commercial users would like that: answer a very simple question and your identity is known... Identified submission is possible in Google Apps for Business, but only within the company's domain.

Upvotes: 1

Related Questions