Jotform to pull data from spreadsheet

  • Profile Image
    mcaaclstl
    Asked on November 29, 2021 at 04:11 PM

    I know using the Spreadsheet to form widget you can UPLOAD a spreadsheet & then use the data in your form. Are there any plans to allow changes in your spreadsheet to be reflected in the Jotform environment, either from a table or widget so that it would dynamically update without the need to UPLOAD an updated spreadsheet? This feature is available between google forms & google sheets, but the jotform interface is so much more user friendly to me.

  • Profile Image
    Amin_N
    Answered on November 30, 2021 at 01:38 AM

    Hi there,

    Thanks for reaching out to us!

    Unfortunately, that's not possible with the spreadsheet to form widget. However, kindly note that it's possible to import the sheet into Tables, then use imported data to prefill the form. So, in two steps:

    1. Importing the sheet into Tables.
      Related guide: How-to-import-data-in-jotform-tables
    2. Prefilling your form using imported data from Tables.
      Related guide: How-to-prefill-form-fields-with-data-from-other-tables-with-table-prefill

    Should you have any further inquiries, we will be more than happy to help.

  • Profile Image
    mcaaclstl
    Answered on November 30, 2021 at 10:04 AM

    Will the import feature update automatically if a change is made in spreadsheet? Is there a way like with spreadsheet to form to use a unique ID to figure out which record to use to populate the form? With pre-fill I only see the option to create multiple links to the form for each data row, not to fill based on unique ID.

  • Profile Image
    Jovanne_A
    Answered on November 30, 2021 at 10:43 AM

    Hi,

    Unfortunately, it is not possible to dynamically update nor get values from the Table and update the spreadsheet file you have uploaded in the Spreadsheet to form a widget.

     Is there a way like with spreadsheet to form to use a unique ID to figure out which record to use to populate the form? 

    Yes, you can use a Unique code in the Spreadsheet to Form widget. By using a unique code present on each row of your spreadsheet, you can access that specific row when it matches the unique code entered on the form.

    GUIDE: How-to-use-the-spreadsheet-to-form-widget

    Please check and let us know if you have further questions.