- kevinwatsonAsked 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.
- JotForm SupportjonathanAnswered on November 15, 2012 at 10:17 PM
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.
- kevinwatsonAnswered 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
- JotForm SupportjonathanAnswered 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.
- kevinwatsonAnswered 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.
- kevinwatsonAnswered 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.
- JotForm SupportjonathanAnswered on November 21, 2012 at 03:00 PM
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.
- kevinwatsonAnswered 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?
- JotForm SupportjonathanAnswered on November 22, 2012 at 05:37 PM
- kevinwatsonAnswered on November 22, 2012 at 08:34 PM
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?
- JotForm SupportidarktechAnswered on November 22, 2012 at 09:26 PM
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!
- kevinwatsonAnswered on November 22, 2012 at 09:37 PM
idarktech: THANK YOU!