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.
Is there a way to customize the excel report sheet generated by jotform?Asked by ryanbetzler on May 26, 2014 at 06:33 PM
I built a registration form for a charity golf outing which would allow users to register either solo, or additional golfers through one form.
Currently, the excel response sheet generates all 'participants' on the same line. Is it possible for the document to have each participant on its own line on the excel sheet with some sort of notation of whom registered together?
The line or row in the Excel response sheet correspond to the form submissions.
Meaning, new line/row is added every time the form is submitted.
Your "All Participants" is currently on same line/row in the excel response because it was just a single submission.
What you can do instead is to re-submit the form every time there is an "additional participant".
You can add a Unique ID field in your form so that you can also determine the unquieness of the submission even if the user made a duplicate submission
You can also add condition logic to allow the user to submit additional participant using the option "Add additional participant"
Please check this demo form http://www.jotform.me/form/41457814119456
There is an option to Add Participants Yes/No -- if you choose Yes it will give you option to re-use the form again to add new participant.
You can check the submission data using this report alsoHope this help. Inform us if you need further assistance.Thanks!
Thanks for the quick reply!
The additional issue I have is that I don't have the paypal segment in place as of yet.
So what would need to happen is that if a user wanted to register multiple people but only have 1 paypal transaction.
Is that possible??
Thanks for your help!
Your form Total field can be configured to send the value into PayPal Total. However, the entries will not be connected between each other, so that you will need to manually compare the records.