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.


  • Profile Image

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

    Asked by ryanbetzler 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?

     

    Thanks!

    - Ryan

    JotForm excel registration form thanks register
  • Profile Image
    JotForm Support

    Answered by jonathan 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 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

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

     

  • Profile Image

    Answered by ryanbetzler 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
    JotForm Support

    Answered by Mike_T 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.