Skip to content

Reports

A report exports a collection’s records as a file: chosen columns (also from related records), filters, grouping and totals. Download it right away or schedule it to arrive by email.

  1. Open Reports in the menu or Settings → Collections → the collection → Reports → New report.
  2. Choose columns, filters (with ranges such as today, this month, last quarter or the last N days), grouping and totals.
  3. Choose the format: PDF, CSV, Excel or JSON.
  4. Schedule the frequency (daily, weekly, monthly or once) and the recipients.
  5. Run and download, or share the result with a public link.
  • Visibility: private (only you), public (the whole team) or assigned to specific people.
  • Permissions: reports:view, reports:run, reports:edit, reports:schedule and reports:share.
  • A report can be run manually up to 5 times per hour.
  • Each person sees rows with their own scope.
  • get_report_guide: format of columns, filters, grouping, totals and schedule; with collectionId, the available fields.
  • Configuration server: list_collection_reports, preview_collection_report (test without saving), run_report, get_report_runs. Team reports are saved in the schema (upsert_report).
  • Data server: list_reports, get_report, preview_report, create_report, update_report, run_report, get_report_runs.
  • run_report sends no email: the file stays in the runs.