What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
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.
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.
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.
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.
This is possible in such a way that you will need to use conditional logic for it. Here's a sample form: https://form.jotform.com/61081434930955. 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: https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic
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.
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: http://api.jotform.com/
Other than the mentioned solutions, there are no other possible way to do what you would like to accomplish. Thank you.