Filter templates

Saved filters

Filter templates capture a combination of filters, sort, and column choices and let your team flip between them in one click. Bookmark "Hot pipeline", "Closing this week", "At risk" - without saving 15 different URLs.

crm.deals - saved views
4 templates
  • Hot pipeline pinnedactive
    stage in (Proposal, Negotiation)amount > 50000
  • Closing this week pinned
    close_date <= today + 7dstage != Won
  • At risk
    days_since_activity > 14amount > 10000
  • My deals
    owner_id = $current_user
What it does

The capabilities you get out of the box.

Capability01

Per-resource

Templates live on the table and apply across grid, kanban, calendar - every view.

Capability02

Composable filters

Combine text, numeric, date, enum, and uuid operators. AND or OR.

Capability03

Pinned for everyone

Admins can pin templates so they show up first for the team.

How it works

Three steps from SQL to UI.

  1. 01
    Filter the viewUse the toolbar to set filters, sort, and column visibility.
  2. 02
    Save as templateName it, add an icon, decide if it should be pinned.
  3. 03
    Use anywhereTemplates appear in the toolbar dropdown for every view of the resource.
example/filter-templates.sql
sql
comment on table crm.deals is '{
  "filterTemplates": [
    {
      "id": "hot",
      "name": "Hot pipeline",
      "icon": "Flame",
      "filters": [
        { "id": "stage",  "value": ["Proposal","Negotiation"], "operator": "in" },
        { "id": "amount", "value": "50000", "operator": "gt" }
      ]
    }
  ]
}';
Get started

Try it on your own Supabase project.

Connect a project, install the Supasheet schema, and your tables are live in minutes.

No credit cardSelf-host or managedMIT licensed