I have collected some data and some columns are missing in the final data set on downloading… The columns missing are visible on the mobile phone when running the actual questionnaire.
What could be the problem?
Hi @datamasters11,
Please ensure if you have (updated and) redeployed your survey form. This could have an affect similar to that you are facing.
In the image below you will see a survey form where i have redeployed multiple times (6 times here).
If you download the data-set with the Include fields from all … deployed versions, checked you will see some data columns that are blank as shown in the image below:
If you download the data-set with the Include fields from all … deployed versions, unchecked you will see no data columns that are blank as shown in the image below:
Also please feel free to have a look at the support article (Recovering data from previous form versions) to solve your issue.
Have a great day!
2 Likes
Hi @Kal_Lam
Just jumping in here with a follow on question.
We just added two new questions to a form and went back and added the data to the old records. When i download the datasheets with the include fields from all versions checked, the columns are there but with no data in the rows. When i uncheck that box, the data is now there correctly. Is this how it is supposed to work?
It just seems to me that including fields from all versions - should also show the results in the latest version.
Thanks as always!
Oh, and then worried that if i needed to later delete or edit a question - but still wanted the old data available, how would that be managed ? if the new and old datasets don’t download in the same download?
