Auto-Populate Form Data in Google form

axessJosh used Ask the Experts™
I'd like to use a Google form and spreadsheet to setup a marketing survey for capturing responses.  (yes, I'm cheap)

Is there a way that I could setup the form to auto-populate the user's name and email by appending that info to the link from the email I will send them?  I think I can figure out how to setup the email, just not sure how to edit the forms to accept the URL parameters.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I was able to solve this issue.

Basically, you preview the code, then find the ID of the form field you want to pre-populate.

In your link you send out, concatenate on the URL "&field_id=your_value"

This will take that field and prepopulate it automatically from the URL data provided.

This works from Infusionsoft merge fields as well to cut and paste the value of the merge field into the URL link.

Woo Hoo!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial