Can I split a single form entry into two different lines in the excel report provided by sjotform ?

  • Profile Image
    ADMwebsite
    Asked on April 04, 2019 at 03:21 AM

    Hi, 

     I am currently building a form to support enrollments to a tennis event.

    Each enrollment is for a pair of players.

    I do find every enrollment in the excel rsult form.

    However, I would like to create one line per player in y excel result. 

     

    Can this be done ? 

  • Profile Image
    Nik_C
    Answered on April 04, 2019 at 04:46 AM

    I'm not sure what exactly you would like to do since those are all separate fields:

    15543672852019-04-04_10-40-24.png

    So all will appear in separate columns:

    15543675532019-04-04_10-39-27.png

    How you would like to have them exactly?


  • Profile Image
    ADMwebsite
    Answered on April 04, 2019 at 07:15 AM

    I would love to have player1 data on first line of excel file  and player 2 date on the second line of the Excel file.

  • Profile Image
    Victoria_K
    Answered on April 04, 2019 at 09:55 AM

    Unfortunately, this is not possible. The data from single submission will be displayed on single line in the sheet. What I can suggest is to check if Configurable List will meet your needs. It should display players in lines, but within single cell.

    How-to-Set-Up-the-Configurable-List-Widget

    Let us know if you need more help.