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!

We created an easy to use template that can be accessed here. There is some test data within the sheet, so you can see examples of the data that belongs in each column but for an in-depth review of the columns please read this article.

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.

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:

​

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 enterprise-support@givegab.com.