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.


  • Profile Image

    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?

    Page URL:
    https://secure.jotformpro.com/form/50895950926974

    and Long name next form field Updated
  • Profile Image
    JotForm Support

    Answered by david on April 22, 2015 at 12:07 PM

    Hi,

    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.