How to add the language parameter to the integrated Google spreadsheet?

  • Profile Image
    Asked on June 13, 2017 at 08:02 AM
    We have a “Google Sheets” integration for our ‘Registration’ survey form, to track sign-ups. Is there a way to include in that spreadsheet which language they selected when they filled in the registration?
  • Profile Image
    Answered on June 13, 2017 at 08:17 AM

    Since you are having the parameter in the URL, it can be captured to a textbox field on the form so that this textbox field can be sent to Google spreadsheet automatically. You may consider adding a Short text box entry field to the form and read the language parameter value by adding a simple PHP code to the default value of the field.

    <?php $_GET['language']; ?>

    Please take a look at the following form that can help you with this.

    You may hide the textbox field on the form to avoid confusion for the users. You may clone the form to your account to see it works.