Medair has developed a dashboard (using Qlik Sense) which is designed to quickly load and analyse XLS forms in order to check for quality markers such as correct usage of hints, constraints and multi-language fields. Its most useful for those working either with large numbers of forms or forms which are long and take significant time to check before publishing and is aimed at driving improved ODK form design.
Any feedback or thoughts on the idea are welcome. We are also in the process of creating some documentation to accompany the dashboard, some usage instructions available in the links below. If there are questions on setting the system up or using it, I am happy to answer as there's not that much to the setup.
Below are links to some of the resources for anyone curious to use them or to share with others.
- https://www.qlik.com/us/try-or-buy/download-qlik-sense (qlik sense free download)
- https://im.medair.org/#Public/Filemanager/item/1497 (dashboard with example form loaded)
- https://im.medair.org/#Public/Filemanager/item/1491 (dashboard setup instructions)
- https://im.medair.org/#Public/Filemanager/item/1498 (excel manual checklist and useful constraint examples)
We hope to continue developing and improving the system. Please feel free to download the resources and let us know if you have found them useful or would like to suggest additional features!