How to populate data in a jotform field with data from google sheet?

  • zanesooyk
    Asked on May 12, 2017 at 5:50 AM

    I need to pre-populate a dropdown box in jot form with data from an integrated google sheet. How do I do it?

  • Support_Management Jotform Support
    Replied on May 12, 2017 at 6:51 AM

    I'm afraid our integration with Google Spreadsheet works the other way around. It's not something you use to populate data to your form, it's something that you use to export Submission Data to a sheet.

    The only prepopulation feature we have is through URL parameters and to make things easier, you can use our Prepopulate App to generate the link:

    https://prepopulate.jotform.io/

    Another approach to prepopulate fields is to forward them to another form.

    Related guide: How-to-Automatically-Pass-Form-Data-to-Another-Form