Return

Using table views

Use views to save filters and reuse the same dataset across your project.

Steps at a glance

1. Create a view from the Tables subtab in Data & API.
2. Add filters and sorting to match your use case.
3. Set access rules so the view is safe to use.
4. Use the view in your interface (lists, grids, or a Data Grid).

1) Create a view

1. Open the Data & API tab, then open the Tables subtab and select a table.
2. Open the Views section for that table.
3. Click New view and give it a name.

2) Configure the view

• Click Filter and add one or more filter rules (for example status is Active).
• Click Sort and choose how results should be ordered (for example createdAt Desc).
• If you need dynamic filters (like a search box), add a Parameter and bind it in your filter value.
• If the same view is used on multiple pages and you want its data to stay loaded while users navigate, open the view settings menu (⋮ on the view tab) and turn on Preserve on navigation.

3) Secure the view (recommended)

Before you use the view in your app, check its Access setting:

• Use Authenticated if users must be signed in.
• Use role-based rules (when available) if only some users should access it.
• Always filter “My items” views by the current user (for example a User column linked to the signed-in user).

4) Use the view in your app

Use the view whenever you need a repeatable dataset:

• A list of active items.
• A dashboard table with sorting.
• A filtered “My items” page (when combined with the current user).

Typical ways to use a view:

• In a workflow, run Table View: Fetch and bind the result to your elements.
• In a Data Grid, pick the view as the data source.

Common pitfalls

The view is missing records

• Double-check your filters and make sure they match your actual data.

The view works but users still see data they should not

• Use the view Access settings, and protect your APIs with access checks (who can call the endpoint) when data must be protected.

Related guides

Adding, editing, and deleting records in tables

Create records, update them, and delete them safely using your tables.

Beginner8 min

Securing APIs

Protect your APIs so only the right users can access sensitive data.

Beginner7 min