- District1010Asked on January 18, 2015 at 01:05 PM
If you look at the form we used last year you will see that where one person has booked more than one delegate (e.g. Delegate 1; Delegate 2; Delegate 3 etc) this results in a spreadsheet with those delegates in a number of columns within the one row. This makes it really difficult to process the information. Is the any way that I can still encourage multiple bookings but have the information displayed in the same manner as a single person booking? Put another way let's say I need the following information from each delegate:
Fore Name (1)
That will produce a spreadsheet with the following columns
Fore Name (1) Surname (1) Club (1)
If two delegates book we get this
Fore Name (1) Surname (1) Club (1)
Fore Name (2) Surname (2) Club (2)
But, if one person books two delegates we get this
Fore Name (1) Surname (1) Club (1) Fore Name (3) Surname (3) Club (3)
As I say that makes it very difficult to process, is there a better way of creating a form to accept multiple bookings?
- ShadaeAnswered on January 18, 2015 at 01:57 PM
Yes we do have a widget that would allow the process to be easier for you.
Our Matrix Dynamique widget will allow you to have multiple rows in one field. Your user will be able to select how many delegates they would be booking for using this field.
I hope this helps, please inform us if you need further assistance.
- District1010Answered on January 18, 2015 at 02:37 PM
I did use Matrix Dynamique on my form and whilst, as you say, it presents the form 'correctly' to the user of the form, as in multiple rows. The problem arises when viewing the results in a spreadsheet. Instead of creating multiple rows I get an extended row with multiple columns. If it helps I can create a spreadsheet to show you what I mean?
- JotForm SupportjonathanAnswered on January 18, 2015 at 03:32 PM
The problem arises when viewing the results in a spreadsheet. Instead of creating multiple rows I get an extended row with multiple columns
Unfortunately, this is the default output behavior of the Matrix Dynamique widget submission on spreadsheets.
The Matrix field result data is being considered as single field only.. so it is NOT being break down automatically into multiple submission/rows.
To be able to separate submission on a table, you will need to use individual field for each data. Example, using multiple fields instead of a matrix table field.
Hope this help. Please let us know if there is more we can help you with.
- District1010Answered on January 18, 2015 at 03:38 PM
Thanks, good that we both now understand the issue. So, question how can I allow party bookings, it's a fairly common requirement I'm sure: husband and wife plus family for example. I appreciate that Matrix Domique can't do it but perhaps there's another way?
- ShadaeAnswered on January 18, 2015 at 04:09 PM
An alternative, would be to use our form collapse tool and conditions. You would ask your users if they would like to add another person and the fields for the second or third person would be available.
This would allow you to keep your submission data organized.
Here is a sample form: http://form.jotformpro.com/form/50176618708965
Please inform us if this is a suitable solution.
- District1010Answered on January 18, 2015 at 04:15 PM
That has possibilities and I will give it try - thanks
- ShadaeAnswered on January 18, 2015 at 04:21 PM
You are most welcome, we are happy that this maybe a suitable option for you.
Please feel free to contact us if you need further assistance.
- District1010Answered on January 31, 2015 at 09:47 AM
Now making a start see URL
Not sure why but I don't seem able to add the Conditions to Delegate 4 onwards. What am I missing please?
- District1010Answered on January 31, 2015 at 01:20 PM
Sorted - have this bit working now no doubt will be back with others.
- District1010Answered on January 31, 2015 at 01:47 PM
You kindly answered my question on the 18th with the suggestion to use the form collapse tool and conditions. You would ask your users if they would like to add another person and the fields for the second or third person would be available.
I created such a form just now but unfortunately it produces much the same result as the Matrix Dynamique.
Basically the multiple entry is all in one row which really is unworkable for a whole host of reasons.
I'm hoping that you can help? All I need is the ability to have an entry of say ten people form the same organisation to appear in multiple rows - this would be the same as entering ten individual people which I'm sure you will understand is not at all satisfactory as it means repeating too much information.
- ShadaeAnswered on January 31, 2015 at 03:10 PM
I do apologize, I am not sure I understand the issue that you are now experiencing.
When you create a different field for each delegate, it will be display in its own row when the information is imported into a spreadsheet.
Are you stating that the information for the different rows are coming in the same row?
Could you provide us with a screenshot so that we can better? You can view this thread on how to add a screenshot to your post: http://www.jotform.com/answers/277033
- District1010Answered on January 31, 2015 at 03:53 PM
You certainly describe what I want to see but this is what I get having added a few delegates to my form
From this you will note that the delegates in the same row whereas the following is what I need.
This is the test JotForm I'm using
- JotForm SupportjonathanAnswered on January 31, 2015 at 05:34 PM
For the additional data (new delegates) to appear as new rows in the submission result, they need to a new submission of the form.
We apologize if there was confusion on how it works. But this is how it was since.
As you can see in your jotform http://www.jotformpro.com/form/50303023191943 submissions page, the same submission are only in the same row
If you want the additional data to appear as another row, then re-submit the form.
A workaround you can do is to repeatedly submit the form with some data as static (i.e Name, Club...), while new delegates are being added.
You can do this by setting up the form URL in the submission custom URL redirect Thank You page.
You can try my demo jotform http://www.jotformpro.com/form/50307119358958 . You can submit the form repeated to add new delegates if select the option 'Add new delegate'. The submission will loop back to the same form allowing you to add more data
Hope this help Inform us if you need further assistance.
- District1010Answered on February 06, 2015 at 02:06 AM
Sorry I should have some back to you. Disappointed I guess having spent so much time to go round in a circle. I suppose I am looking for a database solution to the problem and Jotform is essentially 'flat'?
Perhaps in that statement I have the answer and the only way is to import the spreadsheet to Access.
- ShadaeAnswered on February 06, 2015 at 09:49 AM
I do apologize for that we currently do not have the database option. However the work-around that my colleague provided will allow you to get the same results.
Please inform us if we can assist you with anything further.