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

  • Profile Image
    Uttarakhand_DRA
    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
    Kiran
    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.

    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.