Pre-fill Jotform with google spreadsheet data.

  • Profile Image
    James 
    Asked on June 20, 2019 at 05:07 AM

    Hi I have a Jotform where I need to prefill the answer for a restaurant’s name. I have a database which includes the restaurants name and I want to pair this. I also have a second piece of information from a g sheet which is unique to each restaurant that I would like to pre-full in all my JotForms. 


    Thank you

  • Profile Image
    ashwin_d
    Answered on June 20, 2019 at 05:27 AM

    Unfortunately it is currently not possible to populate form fields with external data source. I would suggest you to please take a look at our "Spreadsheet to Form" widget and see if that fits into your requirement.

    This will allow you to upload an excel file in the widget and based on unique field, the data will be populated in form fields. You may also like to check the following guide as well which should help you: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Hope this helps.

    Do get back to us if you have any questions.