CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-appsgoogle-sheets-apigoogle-forms
marianomdq
marianomdq

Reputation: 399

Set a Google Form's elements when a user is entering for submit

Suppose I have the following:

Spreadsheet A

Spreedsheet A

and I want to show the users a different question every time they enter a form for submitting (they see only one question in the form):

Form A

Form A

But there's another more difficult catch:

The form must check with the spreadsheet data which bands are still "unrated" by this user, and only show a question for one of those bands. If the user has rated every band in the spreadsheet, then the form should only show a "There are no more bands to rate" message.

And, the submit of the responses should be in this way:

Form A Responses

Form A Responses

Is this possible with Google Forms, App Script, etc.?

Upvotes: 0

Views: 63

Answers (1)

Zig Mandel
Zig Mandel

Reputation: 19835

not possible with apps script. you cannot modify the form at show time.

at most you can adjust the form (during onFormSubmit) for the next user to see. thus its impossible to customize for a specific user and you can also run into timing issues even if user is not important.

Upvotes: 3

Related Questions