Greetings, I did add all fields in list format to a built assessment tool on CommCare but the downloaded data on excel are received in form of dotted lines as data for empty fields (---). This has caused my team a lot. Please kindly help me out. Many thanks in anticipation for solution.
Yeah I understand how that can be annoying. but think of it this way, other ways of representing a "null" value are:
1- null
2- blank
3- 0
4- " "
5- "."
6- etc...
using --- is because you need a specific way of determining if a question was displayed to the enumerator and left without an answer, vs, answering with a blank, vs answering with a space or a zero, or a default value of some kind.
I am not aware of a way where you can change that from the exporting side, but you can always perform a replace in powerbi or power query
HTH
Mazz