What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by Uttarakhand_DRA 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
    JotForm Support

    Answered by Kiran 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.