How to customize excel report output for Input Table?

  • alphaemc
    Asked on December 4, 2018 at 4:20 PM

    How can I get this report to record entries by Team # so that only one Team is listed per row in the Excel report vs. all Team #'s list in one row?

    If this can be done, can the Excel report be updated retroactively to show one team per row?

  • Victoria_K
    Replied on December 4, 2018 at 6:26 PM

    Unfortunately, it is not possible to customize excel report output. There is no option to split 1 submission into several rows. Usually, 1 field will fill a cell, but in case of Input Table, which is used for teams on your form), every cell of table will fill 1 cell of excel report. 

    To receive more user friendly excel output, I can suggest Configurable List widget for teams field. It will show data in rows within a single cell:

    1543965936exk2u Screenshot 10

    But, please note that deleting a field from a form will also delete submitted data, so in case you decide to replace a field on a live form, we can advise to hide a field add new one foe further submissions. 

    We will gladly assist if you need any further help.