HD Data Collection Definition Creation Process

The service healthdata.be uses the XLSForm standard to help simplify the authoring of forms in Excel. Authoring is done in a human readable format using a familiar tool that almost everyone knows - Excel. XLSForms provide a practical standard for sharing and collaborating on authoring forms. They are simple to get started with but allow for the authoring of complex forms by someone familiar with the syntax described below.

• Basic format
  • The survey worksheet
  • The choices worksheet
  • Setting up your worksheets
• Question types
  • GPS
  • GPS with accuracyThreshold
  • Multiple choice
  • Multiple choice from file
  • Rank
  • Range
  • Image
  • Audio recording quality
  • Metadata
  • External XML data
• Hints
  • Regular hints
  • Guidance hints
• Formulas
• Constraints
  • Constraint message
• Relevant
• Calculation
• Trigger
• Required
  • Required message
• Randomize Choices
• Grouping questions
  • Nesting groups within groups
  • Skipping
• Repeats
  • Fixed repeat counts
  • Dynamic repeat counts
  • Only add repeats in certain conditions
  • Representing zero repeats
• Multiple language support
• Media
• Pre-loading CSV data
  • How to pull data from CSV
• Dynamic selects from pre-loaded data
• Cascading selects
• External selects
• Default
• Read only
• Appearance
• Settings worksheet
  • Encrypted forms
  • Specify alternative server
  • Specify form submission name
  • Specify XForms root node name
  • Multiple webpage forms
  • Grid theme forms
• Styling prompts
• Advanced use and extensibility
• Tools that support XLSForms
• More resources
• History