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

    User generated fields?

    Asked by kevinwatson on November 15, 2012 at 09:41 PM

    Is it possible with JotForm to have a user add fields to the form? For instance, I am trying to create a group registration where the user lists the attendees, but when the user types the names on separate lines in the text field... JotForm combines them all together in a cell within the Excel file (See screenshot). I want to have them add names to individual fields without having to add 50 preset fields when the attendee count could be from 2 to 40.

    If anyone has a better idea to gather this, let me know. It is a pain to separate these names for us to create an attendee spreadsheet to check off.

    Screenshot
  • Profile Image
    JotForm Support

    Answered by jonathan on November 15, 2012 at 10:17 PM

    Hi,

    If I get the idea correctly, you only need to fix problematic part wherein all of the supposedly separate lined names are all bunch up into one cell in the Excel file(spreadsheet or worksheet).

    There is actually a built in function in Excel called "Text to Column" . But the caveat for this is, the column/field will expand according to the number of data(names) in that single cell.

    The expand behaviour is the normal behaviour since you are now treating each name data as another field.

    Hope this help. Please inform us if you have further inquiry.

    Thanks.

     

  • Profile Image

    Answered by kevinwatson on November 15, 2012 at 10:37 PM

    Thanks for the response... and quickly too!

    That featured actually makes it more problematic because it doesn't cut the names correctly.

    It would be nice if the user could "Add Another Attendee" and the corresponding fields would show up for anothe attendee. #wishing

  • Profile Image
    JotForm Support

    Answered by jonathan on November 15, 2012 at 10:48 PM

    I understand your point. =)

    Yes, in general can be more complex indeed if the proper delimiter will not be establish between the names data (first and lastname).

    But I was hoping that the delimiter is already established.. like comma(,) -- should be the separator for each names if there are spaces in between, it will be assume as first name  and last name.

    How about if we use the concept on this guide  How-to-Hide-or-Show-Multiple-Fields-at-Once-Based-On-a-Single-Conditional-Entry ?

    My idea is to put as much as textbox field in the group collapse field and just use the conditions to Show/Hide a number of textbox field required by the form user.

    If we put 10 textbox field each for each 10 collapse field, we have 100 avaliable field textbox field to put the names they want.. (well, 100 is too much I think.. 10 in 2 x2 can do)

    Please inform us if you want to consider the idea.

    Thanks.

     

  • Profile Image

    Answered by kevinwatson on November 21, 2012 at 11:16 AM

    OK. Good thoughts.

    I have a different scenario, but same idea mentioned here and maybe you have a suggestion on how I can capture this appropriately.

    We hold a youth rally and need some info:
    • First and Last Name of attendee.
    • T-shirt size (xs,s,m,l,xl)
    • Youth or Adult?

    What would be your suggestion on implementing this, knowing that I could have between 2-30+ sign up on our group registration form. Obviously, the second and third bullet needs to be associated with the first bullet.

    Thanks for your thoughts.

  • Profile Image

    Answered by kevinwatson on November 21, 2012 at 01:13 PM

    OK. So I tried setting something up. But I am worried about the length of the form. I know I can do conditional formatting and hide some of the fields, but how can I do this as least painful as possible?

    I have entered five Attendees fields and with them - three related fields to each Attendee. I would like to show increments of five attendees depending on the number entered in the "How many..." entry area. How would that be possible?

    Here is my form link. After answering my question, I will delete this link.

    http://form.jotformpro.com/form/23198147240957

  • Profile Image
    JotForm Support

    Answered by jonathan on November 21, 2012 at 03:00 PM

    Hi,

    Please test this form http://www.jotformpro.com/form/23254958141960

    I was already working on it before your latest response, so, I thought I should present this instead in place of the latest form you just mentioned.

    To test this form, just try to increment the "How many in Group" info. It should reveal the option to add new set of attendees.

    Thanks.

  • Profile Image

    Answered by kevinwatson on November 22, 2012 at 05:25 PM

    I like that. I saw it yesterday and it looked clunky, but it looks like you removed the big separators. Did you create a show rule or a bunch of them?

  • Profile Image
    JotForm Support

    Answered by jonathan on November 22, 2012 at 05:37 PM

    Initially, I set the collapse field visibility property to visible ---  I changed it to hidden to have this effect.

    If you like, you can also clone the form http://www.jotformpro.com/form/23254958141960 to have the actual form and better observe how I created it.

    Thanks.

  • Profile Image

    Answered by kevinwatson on November 22, 2012 at 08:34 PM

    Hey Jonathan,
    I set this up, but I am getting mixed results. I am sectioning these by 1-5, 6-10, 11-15, 16-20, 21-25, 26-30, 31-40.

    So when someone chooses a number less than 6, only 1-5 show. Then less than 11, 1-10 show.

    But I am not getting the results I need. Can you look at it?

    http://form.jotformpro.com/form/23267344849968

  • Profile Image
    JotForm Support

    Answered by idarktech on November 22, 2012 at 09:26 PM

    Hello Kevin,

    Please check this cloned form of yours: http://www.jotformpro.com/form/23268429103956?

    What I did to fix the mixed up fields is, I changed all the form collapse statuses to Open. After that, I've added the conditions. Example:

    If How many from Group greater than 1 show Attendees 1-5 (This shows the 5 attendee field sections on the forms initial load since the default group value is 1, but you can change this to something else to clear all the attendee fields when the form is opened)

    If How many from Group greater than 5 show Attendees 5-10

    If How many from Group greater than 10 show Attendees 11-15

    and so on...

    Feel free to clone the form above to view the condition settings. Here's How to clone an existing form from a URL.

    Do let us know if you have further questions. Thanks!

  • Profile Image

    Answered by kevinwatson on November 22, 2012 at 09:37 PM

    idarktech: THANK YOU!