-
alphaemcAsked 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?
Page URL: https://form.jotform.com/73325797590165 -
Victoria_KReplied 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:
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.