Did you know that you can pre-fill Google Forms based on a URL? Did you also know that if you have a basic example you can automate it with a database and send personalized forms?
- On your form, click the vertical ellipses in the upper right corner to reveal the menu.
- Click “Get pre-filled link”
- This shoots you over to a page where you can fill in the fields you want pre-filled and it will generate a URL for you. Copy this. If you want the link you send out to everyone to have the same pre-filled info, your work is done. Send the link out!
How you might automate it
Here is my example form.Once I went through the above steps to get a pre-filled link, here is what I got:
The stuff we are looking for is between the “=” and “&” signs:
As you can see, those are the items I filled in on my own. How might one automate this, then? Here are a few suggestions:
- Using handlebars or Liquid, fill them in with the appropriate expressions and use the appropriate objects to fill them in: https://docs.google.com/forms/d/1nuxTbnUGkTaZw1uGIXXgqfx3hYRi3ZaPahdwDNEgy3Q/viewform?entry.2005620554=
- Using PHP, you might assign variables for these items and fill them in from your database with a select statement: https://docs.google.com/forms/d/1nuxTbnUGkTaZw1uGIXXgqfx3hYRi3ZaPahdwDNEgy3Q/viewform?entry.2005620554=
- On Mailchimp, you’d have to use Merge Tags: https://docs.google.com/forms/d/1nuxTbnUGkTaZw1uGIXXgqfx3hYRi3ZaPahdwDNEgy3Q/viewform?entry.2005620554=
Note: Make sure you are URL encoding things with weird characters and spaces like an address. Example:
308 Negra Arroyo Lane, Albuquerque, NM 87114
Completion of the code in 1, 2, and 3 is an instruction left to the reader. I’m assuming that if you want to do something like generate thousands of personalized URLs to a form, you probably already have a database and know how to use it. I hope this guides you in the right direction! Email me if you want some help.View more TIL posts