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

    Can JotForm "Get Data" from a google sheet ?

    Asked by Ian  on May 26, 2014 at 07:18 PM

    Hi, im looking to lookup data from within an existing spreadsheet ? Specifically to act as data validation which woudl then populate a second feild for example lookup or GET a Job Number and Post the Job Address ?

    This sounds simple enough, but there is always a but ?

    i have not created this forma as yet ?


    Appreciated in advance !



  • Profile Image
    JotForm Support

    Answered by jonathan on May 26, 2014 at 09:00 PM

    Hi Ian,

    Unfortunately this feature is not yet doable in our forms when only using the form builder.

    To have  such functionality, you will need to create a separate program to use the data from google sheet to populate the the form using GET method.

    You can use the form's full source code and add your own custom program to complete the functionality.

    User Guide: -How-to-get-the-Full-Source-Code-of-your-Form

    As an alternative, you may also want to check the Form Field Prepopulator App http://apps.jotform.com/app/field_prepopulator 

    This app will allow you to manually populate the form with values even before the form can be used.

    While the Import Data App http://apps.jotform.com/app/import_data  will allow you to import submission data into the form coming from other data sources like Excel or CSV file.

    Hope this help. Inform us if you need further assistance.