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

  • 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

  • roneet
    Replied on August 17, 2018 at 12:39 PM

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

    Thanks.

  • roneet
    Replied on August 17, 2018 at 1: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 Screenshot 10

     

    Feel free to clone my form and test.

    https://form.jotform.com/82285556803968

  • roneet
    Replied on August 17, 2018 at 1: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


  • corpevents
    Replied 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!

  • roneet
    Replied 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.