- M732burkeAsked 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?
- JotForm SupportdavidAnswered on April 22, 2015 at 12:07 PM
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.