Integration of Google Spreadsheet to populate a form

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

  • Profile Image
    Welvin
    Answered 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
    dorsetholidaylets
    Answered 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
    Mike
    Answered 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.