Add URL to Spreadsheet to Form Widget

  • Hristova_Ivelina
    Asked on November 8, 2021 at 5:53 PM

    Hi guys,

    Any updates on this request? See screenshots

    1636411735 6189a957e7827 Screenshot 2021 Screenshot 10

    I would like to be able to take an uploaded Excel file from Form 1 and populate fields automatically in Form 2 based on the values of the Excel spreadsheet initially uploaded into Form 1. If URL is still not an option is there a workaround?

  • Mike_G JotForm Support
    Replied on November 8, 2021 at 6:57 PM

    We would like to apologize for any inconvenience. I'm afraid that we have not received an update yet regarding the feature request shown in your screenshot that can be accessed here.

    If you would like to prefill the fields of Form 2 with values from an Excel File uploaded in Form 1, I would suggest that you check the Tables Prefill feature to see if it meets your requirements.

    Reference Guide: How-to-prefill-form-fields-with-data-from-other-tables-with-Table-Prefill

    Note: You can import the submission from an Excel File into the Table of Form 1 by following the instructions in this guide — How-to-import-data-in-Jotform-Tables

    Feel free to let us know if you need any further assistance.

  • Hristova_Ivelina
    Replied on November 8, 2021 at 8:48 PM

    Thank Mike, thats some good stuff and it just might work for me.

    Can i upload CSV or Exl file in a upload file field in a form and have it create a table automatically which will then prefill another form?

    I am useing an estimating software that produces CSV or Exl files. I use the information from this files to produce quotes for clients. I need to upload this file to a form via File Upload Field daily. When fields on another form get automatically populated i can produce and send a beautiful looking pdf quote to client.

  • Sonnyfer JotForm Support
    Replied on November 8, 2021 at 9:24 PM

    Hello @Hristova_Ivelina - Let me address your new query on the following ticket link to avoid confusion. https://www.jotform.com/answers/3494603