5.6.7 The XLSForm Cheat Sheet
16-Sept-2022
1 min
The Cheat Sheet aims at helping people starting in their XLSForm journey by giving examples of different formulas and features made available.
Don’t hesitate to also check out theses ressources :
- The incredible XLSForm.org website that will give you a great overview of XLSForm is and all its different features.
- KoBoToolbox website that also provides a range of XLSForm tutorial such as this tutorial and examples on advanced calculations;
- ODK website that also gives examples and tutorials of how to set up specific questions in an XLSForm. For example how to display a Grid of selects on the same screen;
- If you have a good connection and prefer to follow a video tutorial, you can visit Humanitarian Data Solutions Youtube channel.
The 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
- skip logic (relevant feature)
- constraint feature
- calculation feature
- appearance feature
- repeat feature (and grouping)
- 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.
We’d love to hear from you on whether you find this cheat sheet useful! Don’t hesitate to send us feedback by email.