Every day I run a submission extract on one of my forms as part of an internal business process.
This morning the submission extract was omitting a column from the xls extract. (Column 8 missing fyi)
The reason the column was missing was that no data was entered into that field for any submissions, a valid use case.
Is there a way to persist empty columns without me pre-filling blank "dummy" data into the empty field post submission?
I want to keep the submission extract data constant and static every day.
Any assistance would be appreciated.