CartONG's XLSForm Cheat Sheet

Publication language
Date published
13 Sep 2021
How-to / Tutorial / Tips
Data collection tools, Mobile Data Collection, Data quality

This cheat sheet aims at helping people starting in their XLSForm journey by giving examples of different formulas and features made available in the XLSForm world. Don't hesitate to first check out the incredible website that will give you a great overview of XLSForm is and all its different features.

We built it first as an internal tool when we were learning XLSForm ourselves to centralise all the fun coding we were doing or seeing. However we've had requests from various actors of the humanitarian and development world to have just such a resource, and have therefore decided to make ours available directly!

This Google Sheet is organized by type of XLSForm feature, with one tab for each, explaining different examples of formulas/features you will encounter:

  • question types
  • relevant feature
  • constraint feature
  • calculation feature
  • appearance feature
  • repeat feature
  • form metadata
  • settings sheet

Also, two other tabs are there to help you understand the ins and outs of cascading lists, and also to know about interesting tools linked to the XLSForm ecosystem to help you validate your forms or use your XLSForm content to build a more user friendly version of your form.

Check the Cheat sheet by clicking on this link!

We'd love to hear from you on whether you find this cheat sheet useful! Don't hesitate to renforcement-osc [at] cartong [dot] org (send us feedback by email).


This publication is supported by the French Development Agency (AFD). Nevertheless, the ideas and opinions presented in this document do not necessarily represent those of AFD.