Can certain answers in a survey be reported on a separate row?

  • Profile Image
    corpevents
    Asked on August 17, 2018 at 10:43 AM

    I have an order form for people to order gifts and send it to a recipient.  They can enter multiple recipients on the form.

    Is there a way to have the 2nd, 3rd, etc recipients reported on a separate row so I can do a mail merge?

    Example ( "|" indicates a separate cell):

    This is how it's currently reported:
    Buyer name  |  Recipient name #1  |  Recipient email #1  |  Recipient name #2  |  Recipient email #2  |  

    This is how I need the data:
    Buyer name  |  Recipient name #1  |  Recipient email #1
    Buyer name  |  Recipient name #2  |  Recipient email #2

  • Profile Image
    roneet
    Answered on August 17, 2018 at 12:39 PM

    Allow me some time. I am working on the resolution.

    Thanks.

  • Profile Image
    roneet
    Answered on August 17, 2018 at 01:24 PM

    If I understood your question correctly that if "How many Making Difference grams did you purchase?" has "1" as an entry then you want to show one Recipient Name and Email and if "2" is entered the two Recipient name and email should be shown.

    Here's a Gif:

    1534526581form.gif

     

    Feel free to clone my form and test.

    https://form.jotform.com/82285556803968

  • Profile Image
    roneet
    Answered on August 17, 2018 at 01:47 PM

    Feel free to clone my form and test.

    https://form.jotform.com/82285556803968

    Refer this guide to clone form from URL:

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL


  • Profile Image
    corpevents
    Answered on August 20, 2018 at 11:37 AM

    I have the form set up so the correct # of email fields appear. 

    What I need is to have each recipient on a different line when I export the data in Excel.  Is this possible?

    Thanks!

  • Profile Image
    roneet
    Answered on August 20, 2018 at 11:54 AM

    Unfortunately, It is not possible to customize the submission excel via JotForm. However, you can edit the excel with Microsoft Excel functions. Let us know which format you require to export your data so that we can assist you better.

    Thanks.