Add URL to Spreadsheet to Form Widget

  • Profile Image
    Hristova_Ivelina
    Asked on November 08, 2021 at 05:53 PM

    Hi guys,

    Any updates on this request? See screenshots

    1636411735_6189a957e7827_Screenshot_2021

    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?

  • Profile Image
    Mike_G
    Answered on November 08, 2021 at 06: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.

  • Profile Image
    Hristova_Ivelina
    Answered on November 08, 2021 at 08: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.

  • Profile Image
    Sonnyfer
    Answered on November 08, 2021 at 09: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