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

  • Uttarakhand_DRA
    Asked on June 13, 2017 at 8: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?
  • Kiran Support Team Lead
    Replied on June 13, 2017 at 8: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']; ?>

    How to add the language parameter to the integrated Google spreadsheet?  Image 1 Screenshot 20

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

    https://form.jotformpro.com/71621529375964?language=en

    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.