Best way to make a dynamic table of fields for entry?

  • SunbridgeInstitute
    Asked on December 14, 2015 at 10:47 AM

    Hi there,

    I'm not quite sure how to approach this form I have in front of me.

    I want to make a form that gives 3 questions for each staff person that an administrator wants to register on my form. Each administrator will register anywhere from 1-30 staff people at a time.

    I thought I would start by asking how many staff people will be registered, but then I'm not quite sure where to go from there.

    If they choose 4, then I want to ask:

         -Name of staff person

         -email address of staff person

         -dropdown or checkbox question: which course(s) for this staff person?

    Then repeat these three questions 4 times.

    I am kindof picturing a dynamic table of fields, but it does not have to be. I would rather not have 30 entries automatically showing up front--this would be too overwhelming for our submittors.

     

    Based on the widgets and tools that are available in JotForm, can you please recommend an optimal approach for a situation like this?

     

    Thank you!

  • victor
    Replied on December 14, 2015 at 1:15 PM

    If this are the only fields you require, you may use the Configurable List Widget

    Best way to make a dynamic table of fields for entry? Image 1 Screenshot 30

    You may configure it so it will ask for Fullname, email and have drop down with all the courses:

    Best way to make a dynamic table of fields for entry? Image 2 Screenshot 41

    Please let us know if this helps.

  • SunbridgeInstitute
    Replied on December 14, 2015 at 2:46 PM

    This is terrific. The only question I have is how I will calculate the total for all the courses selected. I was counting on having "Calculation Values" in the drop-down, for use in a "total payment" calculation. What would you recommend for accomplishing this?

    Thank you!

  • victor
    Replied on December 14, 2015 at 4:23 PM

    If I understand you correct you would like to have a count how many new staff will teach Math, how many in English, etc. Unfortunately using this widget you will not be able to use CALCULATION VALUE. Could you also please explain "TOTAL PAYMENT"? If you can explain what type of form you are trying to create, we may give you better support.

  • SunbridgeInstitute
    Replied on December 15, 2015 at 9:23 AM

    I guess it would work if I could do a count for each of the different courses. I was originally planning on putting a price value in the "Calculation Value" and then adding up all of the chosen items to get a TOTAL PRICE that the user was to pay for all of the courses selected.

    If I can't use "Calculation Value" then what will be the best way for me to calculate the TOTAL PRICE for all of the courses selected. Keep in mind that each person may take more than one course, and all the courses have different costs.

    Thank you!

  • Ben
    Replied on December 15, 2015 at 12:54 PM

    Looking at everything, the best bet for creating any number of fields, would be to use Configurable List widget as mentioned by my colleague Victor.

    Unfortunately no calculations can be made on it, so instead you would need to fall back to the plain fields.

    Now, my suggestion would be to set a specific number of fields that you will allow per submission. For example, to allow 10 entries and if more are needed, there are ways to pass some info to the same form after submission so that they continue adding another 10 or more entries (just let us know if you want us to help you with that).

    This would allow you to create one set of fields and then duplicate them. Once you do, you can simply set the conditions for all the fields as you need them and make the fields show up as needed.

    The best way to do this is to use Form Collapse to group fields and show them only when needed.

    You can see more about this here: Show or Hide multiple fields at once using form collapse tool

    Next to this, you would be able to do all sorts of manipulations on the plain checkbox field to allow you to make the calculations that you want.

    Points to note:

    1. add all the fields that you will need for single entry

    2. do not add any conditions on these fields at this time

    3. clone the fields: How to Manage Multiple Fields

    4. set the conditions on these fields

    Do let us know of course if you have any questions or issues and we would be happy to assist with the same.

  • SunbridgeInstitute
    Replied on December 16, 2015 at 11:21 AM

    thank you for the ideas; I appreciate it. Can you please tell me how to pass some info to the same form after submission so they can continue adding another set of entries?

    Thank you again.

  • Kevin Support Team Lead
    Replied on December 16, 2015 at 12:32 PM

    Hi,

    I think my colleague's suggestion is use this method : http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters 

    Redirecting to your form, with with the same data, the user just will need to add another 10 entries, because all other data will be filled automatically.

    Let us know if you need more help, we will be more than glad to assist you.

    Regards.