Automatic Multi-Form Design Quality Checks

Hi data people!

Below is a link to a beta version of a tool I have used to do quick design quality checks on multiple ODK forms. Of course most design quality checks cannot be automated but forms which fail the tests included in this file tend to be worth looking into manually in more detail as these indicators tend to point to forms which haven't been fully tested or reviewed.

The intended user is therefore probably an NGO manager or advisor who sees a lot of forms but doesn't necessarily create all of them. Of course it can also be useful to apply to your own forms as it often catches a missing translation or some other detail that was overlooked after many revisions and edits. Currently the limit is 10 forms at a time but this could be raised if needed. The result of the checks can also be exported and shared in order to function as an approval tool for organisations which regularly update their forms.

Previously there was a QlikSense version of this file but as it is not a commonly used tool, I decided an excel version would be more accessible. Ideally in the future it would be an online feature where users could view an automated data quality summary of their forms as they upload them. If I find time to work on an online version I will send another post but for now this downloadable excel version is available for use and sharing.

Please feel free to share feedback, questions and ideas so that we can spread the benefits of well designed forms. If sharing with colleagues, please share the link to this page rather than just the xlsx file so that it stays connected to this post :slight_smile:


Really like this, @noel! Thanks so much for sharing! I got stuck on the manual checks - they look really interesting and I want to push into it more. Somehow I broke it when I pressed 'export results' - so I think I missed a step. I can keep trying...or any other help would be helpful on what to do on that sheet??

The fast checks tab helped me find a single word/label that wasn't translated out of 600 labels...#win :grin:

1 Like

Thanks @janna!

Glad the translation check was useful. That is also the part I use most often.

The 'export results' function is a little tricky because it creates a new file and therefore might be affected by excel settings on different computers. I cannot reproduce the error on my laptop but I will try on one or two others to see more details of how it occurs.

The "export results" function is probably not a necessary part of how the system works so I would also consider dropping that functionality if it is problematic. If you have ideas about the manual checks, I would definitely be happy to expand that section in order to cover more use cases :slight_smile: