Questions tagged [google-forms]

Questions related to interacting programmatically with the Google Forms service through the internal api or the external api. A language tag should also be included, e.g. [google-apps-script], [python]. Questions about general use of Google Apps should be posted on Web Applications Stack Exchange.

Google Forms is a cloud-based application and service for creating and hosting surveys and forms. The service supports an internal API for Google Apps Script and a external API. Since the service can replicate form responses into Google Sheets, the responses may be manipulated there after collection, with a broader selection of technologies.

The tag should be applied to questions related to interacting programmatically with the Google Forms service. An additional language tag should also be included, representing the primary application implementation language in the question, e.g. . If the question involves handling of responses in Google Sheets, then the tag is also appropriate.

Usage questions about the web application should be posted at Web Applications Stack Exchange instead of here.

Resources:

More information about creating a Google Form here.

3122 questions
75
votes
1 answer

Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question will be 'prefilled' with unique data from an…
Mr. B
  • 2,677
  • 6
  • 32
  • 42
57
votes
7 answers

Hidden field in a Google Form

I am adding a unique ID to each submission of the form. Right now, I made that ID the first field, and pre-filled it with the ID, along with a help text asking the user not to modify this field. Is there any option by which I can not show this…
Kira
  • 955
  • 1
  • 11
  • 25
45
votes
4 answers

Google Surveys -- a way to pass URL parameters into survey?

I have created a Google Survey and I want to be able to pass URL parameters into the survey so that I can track where responses are coming from. Ideally these URL parameters will be populated into the spreadsheet. I have tried something like…
Nathan Lippi
  • 4,967
  • 5
  • 25
  • 29
44
votes
5 answers

Google Form API?

I would like to (programmatically) convert a text file with questions to a Google form. I want to specify the questions and the questiontypes and their options. Example: the questiontype scale should go from 1 to 7 and should have the label 'not…
Cie6ohpa
  • 815
  • 1
  • 10
  • 13
37
votes
2 answers

Google Forms file upload complete example

How do I allow my viewers to use Google Forms to upload some files to my form and save it to my Google Drive? I am looking for a complete example: It must tell what code to add to the example Google Form HTML source. How to use Google Apps Script to…
Tem Pora
  • 2,043
  • 2
  • 24
  • 30
32
votes
2 answers

How can I change accounts when I am trying to open up a restricted Google Form?

My web browser is logged into multiple Google accounts and I have a restricted Google Form URL like this that I need to open with a specific…
spkane
  • 6,177
  • 2
  • 18
  • 18
32
votes
2 answers

Make Google Spreadsheet Formula Repeat Infinitely

Okay so I have a Google Form that dumps info into a spreadsheet. On each line I need to have a simple calculation done. The problem is I can't figure out how to get it to repeat a formula on every new line as new lines are added. Yes I know how to…
slister
  • 769
  • 1
  • 13
  • 29
28
votes
3 answers

Old Google Form redirect after submission

I am looking for a solution (code) how to redirect user to a custom thank you page (not default Google's) after submitting the form with Old Google Form.