Spreadsheet to form widget: Auto-populating based off of employee #

  • Profile Image
    DFWRES
    Asked on January 22, 2018 at 01:12 PM

    Hi, I'm trying to create a form where based off of the employee # someone uses it auto-populates the rest of their information such as name, work area, and shift. Almost like a v-lookup in excel but for Jotform. Is this at all possible because I have over 5,000 employees?

  • Profile Image
    aubreybourke
    Answered on January 22, 2018 at 02:06 PM

    If you have this information in a spreadsheet you are in luck.

    We have a spreadsheet to form widget:

    https://widgets.jotform.com/widget/spreadsheet_to_form

    You can read the guide here:

    How-to-Use-the-Spreadsheet-to-Form-Widget


  • Profile Image
    DFWRES
    Answered on January 23, 2018 at 11:24 AM

    Aubreybourke - Thank you for the speedy response this has been a tremendous help! My only question now is that I have this can I actually have 2 of these widgets on 1 form doing the same thing from different excel docs without auto-populating both name fields?

    Please see link below and use 086898500 as unique id:

    https://form.jotform.com/80175085442960



  • Profile Image
    aubreybourke
    Answered on January 23, 2018 at 11:43 AM

    The problem is that the labels of the fields need to be the same as the corresponding column in the spreadsheet.

    That's why in your demo the "Name" field is populated twice.

    If your second spreadsheet column was "Name2" and the field label was "Name2" then this wouldn't happen.