XLSForm Reference

• XLSForm introduction
  • The survey sheet
  • The choices sheet
  • The settings sheet
    • Naming filled forms
  • The entities sheet
• Question Types
  • Text widgets
    • Default text widget
    • Number text widget
    • External app string widget
  • Number widgets
    • Integer widget
    • Decimal widget
    • Number widget appearance options
  • Date and time widgets
    • Default date widget
    • Date widgets with non-Gregorian calendars
    • Time widget
    • Datetime widget
  • Select widgets
    • Single select widget
    • Multi select widget
    • Select from external dataset
    • Select appearances
    • Including media files in choices
    • Randomizing choice order
    • Including "other" as a choice
  • Rank widget
  • Location widgets
    • Geopoint widget
    • Geotrace widget
    • Geoshape
    • Bearing widget
  • Image widgets
    • Default image widget
    • Self portrait (selfie) image widget
    • External app image widget
    • Draw widget
    • Scaling down images
  • Audio widgets
    • Default audio widget
    • Using the built-in audio recorder
    • Recording with an external app
    • Getting audio from a custom external app
  • Video widgets
    • Default video widget
    • External app video widget
  • File upload widget
    • Default file upload widget
    • External app file widget
  • Barcode widget
    • Default barcode widget
    • Self portrait (selfie) barcode widget
  • Range widgets
    • Default range widget with integers
    • Default range widget with decimals
    • Vertical range widget
    • Range widget with picker
    • Range widget with rating
  • Note widget
  • URL widget
  • Printer widget
  • Trigger/acknowledge widget
  • Signature widget
  • Grouping multiple widgets on the same screen
  • Grid of selects on the same screen
  • Hidden questions
    • Metadata
    • Geolocation at survey start
    • Calculate
    • Background audio recording
• Form Logic
  • Form logic building blocks
    • Variables
    • Expressions
    • Calculations
    • Values from the last saved record
    • Form logic gotchas
  • Requiring responses
  • Setting default responses
    • Static defaults
    • Dynamic defaults
    • Dynamic defaults in repeats
    • Dynamic defaults from form data
  • Triggering calculations on value change
    • Lightweight timestamping
  • Validating and restricting responses
    • Read-only questions
  • Conditionally showing questions
    • Simple example
    • Complex example
  • Groups of questions
  • Repeating questions
    • Controlling the number of repetitions
    • Naming repeats to help with navigation
  • Filtering options in select questions
  • Generating select ones from repeats
• Form Operators and Functions
  • Operators
    • Math operators
    • Comparison operators
    • Boolean operators
    • Path operators
  • Functions
    • Control flow
    • Accessing response values
    • Strings
    • Math
    • Date and time
    • Geography
    • Utility
• Form Datasets
  • Building selects from CSV files
  • Building selects from GeoJSON files
  • Building selects from XML files
  • Looking up values in datasets
  • Attaching CSVs for lookups without a select
• Form Styling
  • Media
    • Images
    • Audio
    • Video
    • Autoplaying Media
  • Markdown
    • Headers
    • Emphasis
    • Hyperlinks
    • Escaping Markdown
    • Inline HTML
  • Fonts and colors
  • Text alignment
  • Emoji
• Form Language
  • Switching languages
• Form Audit Log
  • Enabling audit logging
    • Location tracking
    • Change tracking
    • Reason for changes
    • Enumerator identification
  • Viewing audit logs
  • Log structure
  • Event types
  • Timestamps
  • Known limitations
• External Apps
  • Launching external apps to populate single fields
    • XLSForm
  • Specifying a URI as intent data
  • Designing an app to return a single value to Collect
  • External apps to populate multiple fields
    • XLSForm
• Encrypted Forms
  • Overview
  • Security Concerns
  • Defining an Encrypted Form
  • Creating RSA Key pair
    • Install OpenSSL (Windows only)
    • Constructing the RSA Key Pair
    • Create a private key
    • Extract a public key
    • Storing and using the keys
    • Updating the public_key field in the XLSForm settings worksheet.
  • Operations