If your form has a date question (where the user scrolls through a calendar type widget to select a date), this shows up as MM/DD/YYYY. Is there any way to make that use the DD/MM/YYYY format?
CommCare – How to Configure Date Widget to Use DD/MM/YYYY
commcare
Related Solutions
For this, you can leave the Case Management tab as "does not use cases." This controls the cases of the case type you've selected in your module.
The User Case will automatically be loaded into your form when you choose a form that has User Case setup.
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.
Related Topic
- How to format a date property in case list or case detail
- How to compute the time spent in a form
- Format time to show hours and minutes only
- How to change the date format in App Preview and WebApps
- CommCare – How to Join Multi-Select Lookup Table Values with Commas in a Label
- Is it possible to populate a Multiple Choice Lookup Table question from a case property holding a space-separated list in CommCare
- Does a date-dependent SMS reminder with repeats reset if the date trigger is updated
- How to trigger CommCare to create user cases
Best Answer
The ordering of the date fields (day, month, year) is actually determined by the default language settings on your phone. To get the dates to appear as MM/DD/YYYY, go to the Android Settings -> Language & Input and set the Language to "English (United States)". To get the dates to appear as DD/MM/YYYY, go to the Android Settings -> Language & Input and set the Language to "English (United Kingdom)". For languages other than English, you may need to try out different regional language settings to find the right choice.