Pre-populate forms via URL parameters

Forms: Advanced form features

Print

Pre-populate forms via URL parameters

For developers who would like to integrate forms with their own applications, we now provide an easy way to pre-populate a form with data. Simply append an entry string for each response field you'd like to pre-populate. Since each question has an unique id like "entry_0", in order to repopulate the entry, append "&entry_0=prepopulated answer" to the URL of the published form.

Here's an example:

The URL http://spreadsheets.google.com/viewform?formkey=12345&entry_0=Barack&entry_1=Obama&entry_2=1600+Pennsylvania+Ave&entry_3=pistachios|spinach|broccoli&entry_4=8/4/1967 pre-populates this form:

Make sure that your answer text is URL-encoded. For multiple answer fields, use the pipe ("|") character to separate your answers.

Note: For multiple choice and checkbox questions, if the parameter doesn't match one of the answer choices and the "other" option is enabled, then the parameter is automatically put into the "other" answer choice. In order to populate multiple checkboxes, parameters should be delimited by pipes.