Tips & Tricks

Learn how to import a PDF, DOCX, or questionnaire XLSX into LooprAI, review the editable XLSForm, validate it, and publish or download it.

6 min read

Export ODK Central submissions to CSV or Excel, handle repeats and media, and choose between one-off downloads and a live OData feed — step by step.

5 min read

Fix ODK Collect submissions stuck on the device: auth errors, revoked app users, form version mismatches, auto-send settings, SSL problems, and full storage.

6 min read

Set up ODK Collect in five minutes: create an app user in ODK Central, scan the QR code, download forms, and send a test submission — step by step.

6 min read

Use the ODK Central OData feed to build live, auto-refreshing dashboards in Power BI and Excel — no manual CSV exports. Step-by-step setup with the OData URL.

5 min read

The XLSForm appearance column controls how a question looks — dropdowns, Likert scales, columns, signature pads, and maps. See every common appearance with examples.

5 min read

Copy-paste XLSForm calculation examples: age from date of birth, scores and totals, if() logic, text concatenation, and showing calculated values in labels.

5 min read

Build cascading selects in XLSForm with the choice_filter column — filter districts by region and villages by district, with a complete copy-paste example.

5 min read