How to Pre-fill Form through URL Parameters

You can pre-fill a form through URL parameters so when users arrive at the form, some of the form fields will be automatically pre-populated for them.

For instance, if you are sending a form link to your users via Email Merge, you can pre-fill the email address field in the form since that piece of information is already known to you.

Build Your Pre-fill URL

Let’s assume that your Form has two fields - Name and Email Address - that you would like to pre-fill through URL parameters.

The standard form URL looks something like this:

https://script.google.com/xyz/exec

To add a form field to the URL, we add a question mark ? after the form URL, then add the form field name, followed by an equal size = and the pre-filled value.

Our new URL would thus read:

https://script.google.com/xyz/exec?Name=John%20Public

Pre-fill More than One Field

To add another form field to the pre-populated form URL, add an ampersand & to the URL, followed by the field name, an equal to sign and the field value.

Note

If there are any spaces in your field name or the field value, remember to replace the space with %20

If you we were to pre-populate the Email Address field, the new URL would be:

https://script.google.com/xyz/exec?Name=John%20Public&Email%20Address=abc@gmail.com

Pre-filled Form Demo

You can click here to test a pre-filled form URL.

Note

Short answers fields, paragraph type questions and drop-down fields can be pre-populated using URL parameters