- SVLLAsked on December 13, 2011 at 01:36 AM
I built a registration form for our baseball league. We offer a "quantity discount" when a family signs up two or more players from the same household. We would like to simplify the process so that the parent only has to submit the form once. In our returning recordsets, we need to have one row per player.
Is there a process we can configure which will split out the specific information for each player, and then duplicate the records which are common; such as address and Parent / Guardian info?Page URL:
- JotForm SupportMike_TAnswered on December 13, 2011 at 05:02 PM
Thank you for contacting us.
Let me please inform you that you can duplicate the fields within your form, just right click on some field and then use the Duplicate option.
At this time it is not possible to populate data from some field to another, but you can achive something similar. You can create a Check Box that says "Address and Parent information is the same". If the user unchecks it, you can show needed fields by using Show / Hide a form field Conditions.
Please feel free to contact us if you need any further assistance.
- SVLLAnswered on December 14, 2011 at 11:56 PM
Thank you very much for the detailed answer. I think that is closer to our intended behavior, but still is not what I am seeking. It is less about them duplicating the data in the form, and more about us returning three rows in the spreadsheet for three different players. Since the spreadsheet on Jotform is authoritative, if we manually add those rows then we end up in a potentially non-deterministc state. Are there any other recommendations so that we can save parents from walking through the form 3x for three players in a household?
- fxrAnswered on December 15, 2011 at 05:43 PM
Its not possible to generate 3 seperate submissions from the one form submittal.
You have a choice of one form submittal and include all the players on it, meaning that all the players names will appear on the one row (submittal)
As regards the 2nd option, I agree its unweildy to ask your users to fill in the same form 3 times as a part of the registration process. The answer should lie in manipulating your spreadsheet data rather than forcing your users to do that.
It is possible to create Excel formulae/macro to copy a row to a new row (on a new sheet if desired) if a specifc field has been filled in.
Now, how good are you at writing Excel formulae/macros?