Setup form that has prepopulate content, with validation, and new input

  • Profile Image
    rhzhang
    Asked on June 29, 2020 at 04:03 AM

    I have existing data of employee email addresses and item that they owned (some employee would have multiple itmes. 

    I am hoping to create a survey that once employee input their email address, then item list will auto populate only owned by this employee, then employee input item ID. So I can collect the item with according IDs. 


  • Profile Image
    jonathan
    Answered on June 29, 2020 at 07:40 AM

    You did not tell what is your existing data source. But if it you can export the data to an Excel or CSV data format, you can use it as the data source for the form using the Spreadsheet to Form widget.

    Check our user guide : How to Use the Spreadsheet to Form Widget

    Using the concept from the user guide, you can have the prepopulate content, validation and new input option on the form.

    I hope this help. Let us know if you need further assistance.



  • Profile Image
    Jed_C
    Answered on June 29, 2020 at 11:19 PM

    How do I auto populate previous answer as case below — Are you referring to the previous submissions on Jotform? You have to manually import those into your spreadsheet and import it manually back to this widget https://www.jotform.com/widgets/spreadsheet-to-form.

    Any changes you want to add to Spreadsheet, you need to reupload it so that it will appear when you load the unique id.

    If I misunderstood your question, please clarify.