Is there a way to customize the excel report sheet generated by jotform?

Hello Forum,

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?

Thanks!

- Ryan

Hi Ryan,

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 also

http://www.jotform.co/table/41457101297048

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!

- Ryan

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.

Thank you.