Form Display Logic in the App
Wijnand Van Den Boom
Rani E Dalgin
Complex Schema in the Mobile App
I have a team of researchers collecting data with tablets in remote villages in Africa.
They are using the mobile app due to unreliable internet connectivity.
There are over 40 community workers involved and hundreds of households with a complex schema that goes from district, to sector,
cell, to village, to village sub-category (isibo) to households.
Interventionists who are tracked are assigned at the village level and there are at least two to a village.
I am trying to assist the data entry personnel (sector level associates) to easily find and enter household forms
without making mistakes when choosing from a list of assigned households.
These households will be assigned to them and we have already given them data access groups for each sector level associate (SLA). Because of the size of the project there will still be a very long list of households they are assigned. Therefore, a drop-down list will not be appropriate because of potential for mistakes when choosing the household.
Our team has tried to brainstorm a number of options to solve the problem.
The first three options solve the problem, but rely on using the desktop version of REDCap.
I wanted to get confirmation that these three options are indeed not available in the Mobile App.
1) A custom dashboard would allow them to separate records into villages, and then filter to a specific village before
choosing the record. Unfortunately, custom dashboards do not work with the Mobile App. (please confirm).
2) The Orca Search external module will allow you to search for records, so that you could search for a village
and view only the records associated with that village, for example. However, external modules are only available
with desktop REDCap. (please confirm)
3) They could set up SQL query from a project that contains a reference table of record district/sector/cell/village assignments,
and then use drop down lists in your project to filter through the hierarchical levels. Unfortunately,
SQL queries only work on desktop REDCap. (please confirm)
The next three options do work with the REDCap Mobile App (please confirm):
We believe that they will permit your DAGs to find records much easier than the current setup. I shall include an xml file and test
data.
4) Perhaps we could use the Arms feature to assign records creatively. For example, we could assign an arm for each village,
so that users in the DAG will select the village before entering any data.
5) We could use a combination of naming conventions and records search within the Mobile App to allow users to filter down to relevant records quickly.
Our understanding is that when users set up a project with the Mobile App, they are asked how to download records for the project.
For this option, they would choose "Get a Partial Set of Data".
They could then search for which records to download. If a naming convention clearly indicates records'district/sector/cell/village designations, then users at the DAG will be able to input search strings that narrow the number of records significantly.
The caveat is that the users will need a stable internet connection at the beginning of each data entry session todownload the records (as well as to upload the data entries when finished).
Our team also recommends that the project administrative team control the record naming for the entire project.
If they choose to go this route, the record naming is a very sensitive task, and we would not want them to risk a user changing this name while it is in production. Furthermore, we recommend that the best approach methodologically is to perform all record naming at the beginning of the study.
6) They could also get creative with the assignment of each DAG. If they had enough users within each DAG, they could eachoversee a subset of the records within that sector. For instance, each user can oversee a specific cell,and perform all data entry for that cell. This option would allow the users to interact with fewer records,and ease the data entry process.
I am open to other suggestions and if anyone is interested or has suggestions, i can upload the xml for this project. Thanks in advance.
I just had an extremely helpful conversation with [the lead programmer for the REDCCap mobile app]. He suggested an elegant option: having multiple identical REDCap projects one per district or district-section. We would include the district section in our household and participant ID's. We could then use the data import tool to merge our data back into one large project.
--
You received this message because you are subscribed to the Google Groups "redcap open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redcap_open...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/ec7b2d23-e493-492d-9d49-ff779ac5c8fcn%40googlegroups.com.