When doing a form or case export from CommCareHQ, what would be the most straight forward way to have the data export display with the Question IDs in the order in which they display in the form builder (as opposed to alphabetical order)?
Would Excel Dashboards be the best solution?
CommCareHQ Exports to display in the Order they Appear in Form Builder
commcare
Related Solutions
The default settings of your project do not let you split mulitselect questions in case exports. This is because your case does not know which questions correspond with which case properties (because it could be multiple questions).
However, we do have a feature preview that you can enable on your project that will allow you to define how you would like to split your case property in a case export.
You can enable this setting by going to https://www.commcarehq.org/a/your_domain/settings/project/previews/ and checking the "Split multi-selects in case export" option. Then hit Update Previews.
When that is enabled you should see an extra column in your export that will allow you to select the Type. Here you select "multiselect." Then you can add your options. Example below:
If question_1 is irrelevant, but the question exists in the form, references to the question will evaluate to an empty value (ie: '') and should not cause errors.
References to the element's node in XML will return an empty set. IE: count(#form/question_1) will return 0.
Related Topic
- Saving location name from multiple choice lookup table as a case property
- Display the owner of a case in the case list
- CommCare – How to Get Timestamp for Exact Time a Question is Answered
- In CommCare can the question labels in the data export to be set to a non default-language
- Can a supervisor see the last time a worker synced their device
- How to Automate Adding Rows of Analysis for Excel Dashboard Feed Integration
- Display condition error in repeat group controlled by user-input question
Best Answer
Question IDs in form exports should appear in the order of the questions in the form at the time that you create the export. If your form structure has changed and you want your export to match, you would have to manually go in and change the order by dragging the questions.
For case exports you would need to manually go in and reorder them while setting up the export.
Unfortunately I am not aware of a non-manual way to configure the order.