How to populate form fields from an external Excel Sheet?

  • Profile Image
    mohammednadeem
    Asked on April 12, 2018 at 04:18 AM

    Hello Support,

    i am trying to create a registration form for a user visit, which will have the below fields

    Employee Email Employee ID Employee Name Employee Department Number of visitng family members Day of Visit Time Slot

    when a user enter his email id, automatically relevent fields should be filled (emp id, name,dept) i have all the information stored in a excel file, how can i achieve this.



    thanks

    nadeem

  • Profile Image
    Victoria_K
    Answered on April 12, 2018 at 07:59 AM

    Hello, 

    As far as I understand, you would like to update the values of emp id, name, dept based on user's input for email id field. This can be achieved with the Spreadsheet to form widget.

    Related guide: How-to-Use-the-Spreadsheet-to-Form-Widget

    We will gladly assist if you need more help.

  • Profile Image
    mohammednadeem
    Answered on April 12, 2018 at 08:07 AM

    Hi Victoria_k

    thanks for the reply, i have the attached sheet (example) and below link i created form, can u apply it or show me what to do.

    https://form.jotform.me/81012689329460


    thanks

    Nadeem

  • Profile Image
    Scott
    Answered on April 12, 2018 at 09:49 AM

    Hey Nadeem,

    The widget properties, field labels and the setup of the excel should correlate to each other.

    1523540166Screen Shot 2018-04-12 at 16.3

    1523540773Screen Shot 2018-04-12 at 16.4

    Access Code Column refers to the Column name of the unique keys. ('Unique Code' as shown in the example excel screenshot )

    Labels Row refers to the row number where the labels are located (It is the first row in the example sheet)

    Lastly, the names of the labels from the excel file should be the exact matches of the field labels.