Way to reference a list of mobile workers as possible choices for a multichoice questions in CommCare

One way to accomplish this is by loading the label text in a hidden variable's Calculate Condition and then reference that variable later.

Create a hidden variable with your label text

Add the label text to the Calculate Condition of a hidden variable question type. For example, my_label_text

Reference that variable in a question's label text box

You can drag and drop that hidden variable, my_label_text, into the label portion of the question:

Save the hidden variable to a case property

You can then add logic to save my_label_text as a case property in the Case Management tab. In your scenario you may also want to add logic to save whether or not the question was answered properly.

The export tool can't export users, groups or organisations (locations) but you could use a mapping table to lookup the location or supervisor info based on the user_id.

You could do this by adding a Mappings sheet to your export query that contains the lookup table.

Here is an example of what your query sheet might look like:

We've defined two fields, Location and Supervisor which both reference user_id. We've also added a Mappings sheet as follows:

For each user_id value we have mapped them to the Location and the Supervisor.

When the export is run it will do the lookups the final export will contain the mapped values.

To get the data for the Mappings sheet you can use the user export and organisations (locations) export from CommCare HQ.