Can JotForm "Get Data" from a google sheet ?

  • Profile Image
    Ian 
    Asked 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 !

     

    Ian

  • Profile Image
    jonathan
    Answered 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.

    Thanks!