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

  • Profile Image
    Asked on May 26, 2014 at 06:33 PM

    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?



    - Ryan

  • Profile Image
    Answered on May 26, 2014 at 07:42 PM

    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

    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

    Hope this help. Inform us if you need further assistance.


  • Profile Image
    Answered on May 27, 2014 at 03:25 PM

    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

  • Profile Image
    Answered on May 27, 2014 at 04:59 PM

    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.