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

  • ADMwebsite
    Asked on April 4, 2019 at 3: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 ? 

    Jotform Thread 1782055 Screenshot
  • Nik_C
    Replied on April 4, 2019 at 4: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 Screenshot 10

    So all will appear in separate columns:

    15543675532019 04 04 10 39 27 Screenshot 21

    How you would like to have them exactly?


  • ADMwebsite
    Replied on April 4, 2019 at 7: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.

  • Victoria_K
    Replied on April 4, 2019 at 9: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.