Is there is a way to pull specific data from the spreadsheet?

  • Profile Image
    AZDBAdesze
    Asked on February 21, 2019 at 02:12 AM

    Is there is a way to pull specific data from the spreadsheet based on a dropdown property?



    This is a re-post of a comment on How to embed Spreadsheet in your form?

  • Profile Image
    ashwin_d
    Answered on February 21, 2019 at 03:02 AM

    Unfortunately no it is currently not possible to populate form fields from any external source or previous submission data.

    I would suggest you to please take a look at our "Spreadsheet to form" widget and see if that fits into your requirement. It will allow you to upload excel file in the widget where users can search for a record based on unique code. You may also like to take a look at the following guide 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.