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

    Integration of Google Spreadsheet to populate a form

    Asked by dorsetholidaylets on April 14, 2015 at 01:53 PM

    You have a great integration with Google Spreadsheet where you send data from a form to Google Spreadsheet which works well.

    Do you have the capability to use the integration going the other way to populate a form with data from the google spreadsheet.

    So if you had a database held in a Google Spreadsheet with names, emails and addresses of people, to use this information to populate a form with that data using the email address as the matching key?

     

    Best regards

     

    David King 

    spreadsheet to form populate form
  • Profile Image
    JotForm Support

    Answered by Welvin on April 14, 2015 at 04:00 PM

    Hi David,

    I'm afraid that we do not have a feature that can accomplish your needs. We have a way to import your entire data from Excel to a form, using our Import App:

    http://apps.jotform.com/app/import_data

    http://www.jotform.com/help/308-Import-App-Easily-import-your-data-in-Excel-or-CSV-to-JotForm

     

    We have our API: http://api.jotform.com/. Using our API, you could possibly do this thing in Jotform.  

    Thanks

  • Profile Image

    Answered by dorsetholidaylets on April 14, 2015 at 04:46 PM

    I did not want to input all the data, I want to use it as a look up, so if someone was on the database, if they entered their email address, Jotform would match them on the database and populate the form with their other details to save them entering again. Similar to what happens if you use Continue form later option, it remembers who you are and populate the form with data you have already entered.

    Regards

  • Profile Image
    JotForm Support

    Answered by Mike on April 14, 2015 at 05:42 PM

    Thank you for your idea. We have sent a feature request ticket to our Development Team for consideration.

    There is no ETA for when it will be implemented, but we will let you know if we have any updates on this.