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.
How can I quickly and efficiently enter conditions for a long list of entries.Asked by M732burke on April 22, 2015 at 10:05 AM
One one employee evaluation form, I have a list of 22 names. Each name has two conditions to be updated/filled in when the name is selected -- Employee ID and Employee hire date. I am currently entering each of these two conditions for every name in the list. Very time consuming and room for typing errors. Is there a way to have a spreadsheet containing the information (Employee name, hire date, and id#) and make one programming statement for the whole list? Must be.
Currently I am clicking on condition, Update Form Field, Next, if employee name is equal to John jones, then employee id (i type in ) 12345 to output field Employee ID, then save. Then repeat process, add new condition, update form field, next, if employee name is equal to John Jones, then employee hire date (I type in) Aug 3, 1997 output to field Hire Date, save, then on to next employee. Since I will ultimately be entering over one thousand employees, I would love to place a spreadsheet somewhere and have the Update Form Field process access that
Example Employee Name Employee ID Employee hire date
John Jones 12345 Aug 3, 1997
Mary Smith 22123 July 2, 2003
Fred Green 3568 Oct 2, 2007
IS this possible or is there a better way to do what I am doing?
Unfortunately we do not have the ability to update form data from outside sources. It is not possible to have your fields update based off information entered into a spreadsheet. Short of linking your form to your own database using your forms source code and a fair bit of setup, the way you are currently adding your conditions is the only other way to do it.
If you have any further questions, let us know and we will be happy to help.