Automatically updating field options from a spreadsheet or excel file

  • Profile Image
    Asked on April 14, 2016 at 11:01 AM
    Hi, I would ask you if you update the jotform tools to lookup from spreadsheet or excel? its very important option for us. thanks
  • Profile Image
    Answered on April 14, 2016 at 12:20 PM

    I'm sorry, but we still don't have a feature that would allow you to look up a spreadsheet file and I guess you meant to update a field from a spreadsheet. Am I correct? If yes, can you let us know what field? I can submit a request about this to our developers, but we need more information as to how it works. 

  • Profile Image
    Answered on April 17, 2016 at 03:00 AM

    Yes That is I meant.

    See the below link to form :

    when I fill the "Employee ID", I want the fields like : " full name , email , manager , department " fill automatically from spreadsheet ( lookup )


    This feature is very useful and important in our company.


    Please try to solve it with all my respect.

  • Profile Image
    Answered on April 17, 2016 at 06:21 AM

    On a different level it is possible to import submissions from an Excel/CSV file: 

    Would this be a solution for you? 
    If not please let us know and we can create a feature request so our developers might consider its implementation.

    Let us know if we can assist you further.   

  • Profile Image
    Answered on April 18, 2016 at 02:07 AM

    Thanks for your support.

    But Unfortunately this tool not i meant.

    I meant when any user want to fill the form, if he enter his ID in Employee id field, the system will shown automatically fill the other fields with the details about this user from lookup from any database or sheet.


    I hope its clear for you now.


    Thanks ... and with all my respect. 

  • Profile Image
    Answered on April 18, 2016 at 03:31 AM

    This is possible in such a way that you will need to use conditional logic for it. Here's a sample form: When you type "ID1234" in the "Employee ID" field, the "Full Name" field will have a value of "Charlie JotForm".

    This is possible because of this conditional logic:

     To learn more about conditional logic, you can check this guide: 

    The problem is that if you have hundreds or thousands of employee ID and employee names, then you'll need to create hundreds or thousands of conditions, which is not really effective.


    If you would like to do the same function but ONLY by fetching the your spreadsheet or database. Then that is possible. however, not using our features but by creating your own custom script and embed it on your form's full source code. You might need a developer for this. This is how I will do it in my end:

    1. First, create a page where you can embed the form's full source code.

    2. Now import your spreadsheet on your own database, like MySQL.

    3. I will then create a custom script that will fetch data from my database and prepopulate the form's fields through the full source code. You can use a combination of PHP, Javascript, Ajax and JSON here.


    If you want to fetch data from your existing submissions and preopulate it on another form, then that is possible using our API. You can check our documentation on this link: 


    Other than the mentioned solutions, there are no other possible way to do what you would like to accomplish. Thank you.