How can I quickly and efficiently enter conditions for a long list of entries.

  • Profile Image
    Asked 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?

  • Profile Image
    Answered 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.