Create Dynamic Forms by Combining Remotely Defined Levels and Questions with Google Sheets

Is your team interested in creating more dynamic forms that can have different or unique donation/registration levels and form question answers without creating separate forms for each target group?

You can now do that through our Google Sheets integration!

Combining Donation/Registration Levels and Form Questions

In order to use Google Sheets to pass in specific donation/registration levels and form questions, you need to configure remotely defined options for each.

Please review the article here to implement Google Sheets for donation/registration levels, and the article here to implement Google Sheets for form questions.

After the set up for your remotely defined levels and question answers is complete, you can now use your answers from your Google Sheet.

URL Parameters

To use the Google Sheet levels and question answers, you will need to use the URL parameter of urlData=code. The code here is the code defined in your Google Sheet (column B). You can target multiple levels or code groups by adding each code to the parameter separated by a comma: urlData=code1,code2.

By default, when you access the form without urlData= or the code defined, the default answers from the question configuration should populate:

Now for the example above, I want to target the specific "ev1" registration group and the "mp1" question answer group from my example Google Sheet. I will append the URL of where my form is embedded with urlData=ev1,mp1. So the full URL for this example would be:

https://ashleighenterprisetest.weebly.com/gsheets-registration-test.html?urlData=ev1,mp1

With the URL parameter present with the code defined, we can see the registration levels and question answers update on the form:

That is how you use Google Sheets for remotely defined donation/registration levels combined with MCSR and MCMR question answers.

If you have any questions about this integration, please reach out to our team via the blue chat bubble or email us at [e-mail].