Skip to content

Updating visuals

If you see any images containing outdated UI, please bear with us.

We are updating all content as quickly as possible to mirror our new UI.

Views ​

Views let you create reusable “saved lists” of records from a table, with filters, sorting, grouping, and optional parameters (dynamic inputs).

They’re useful when you want to show different parts of the same table (for example “My orders”, “Pending approvals”, “Last 30 days”) without rebuilding the logic each time.

Example use cases ​

  • Admin review queue: restrict by role and filter for a specific status (e.g., pending)
  • My items (per user): securely retrieve data belonging to the user signed in
  • Recent activity: get all records that were created in the last 30 days, sorted by the most recent first

Creating a view ​

Views are created on top of a table.

To create a view:

  1. Go to the Data & API tab, then open the Tables subtab.
  2. Select the table you want to create a view for.
  3. At the top of the table, click New view.
  4. (Optional) Rename the view by double-clicking its name.

WeWeb will create your new view and open it so you can start setting up Filters, Sort, and Parameters.

To rename a view, change its description, or adjust how its data behaves when users move between pages, open the view settings menu from the ⋮ button on the view tab.

CREATING TABLES

Having a table is a prerequisite to creating views. If you are unsure what a table is or how to create one, you can learn more in the tables documentation→

Preserve on navigation ​

When you fetch a view in your interface, its data is cleared each time the user moves to another page. If the same view is used on several pages, you can keep its data loaded while users navigate:

  1. Click the ⋮ button on the view tab.
  2. Turn on Preserve on navigation.
  3. Click Save.
The settings menu of the My tasks view, opened from the ⋮ button on its tab, with the Preserve on navigation switch and the Save button

Keep it turned off for views that show a single record, like on a detail page. Otherwise, when someone opens a different record, the previous record's data is kept while the new one loads.

Configuring a view ​

Once you have created a view, you are able to customise exactly how that view is filtered and sorted.

Filters ​

To configure filters, click Filter above the table to open the filter modal.

From here, you can add one or more rules:

  1. Choose the column you want to filter on.
  2. Choose the condition (for example “Is”, “Contains”, “Is after”, “Is empty”).
  3. Choose the value for the rule.
    • You can type a fixed value, or bind it to a view Parameter to make it dynamic.
The filter modal opened from the Filter button, with the rule name Contains pricing

DYNAMIC FILTERS

The ability to make filters dynamic is what makes them truly powerful.

To make a filter dynamic, you need to utilize Parameters

Learn more about Parameters →

You also are able to apply more advanced filters, such as

  • Combining multiple conditions with And/Or logic

    Example: status is active And createdAt is after 1 Nov 2025

  • Grouping related rules with Add condition group

    Example: Group “Text search” with name Contains search Or description Contains search, then at the root add And status is active

  • Nesting groups (e.g., an And group inside an Or group) for complex logic

    Example: (status is active And (type is Pro Or type is Enterprise))

  • Toggling a filter to only be applied if there is a valid value

    Example: Bind the value to the search parameter and turn on the switch next to the value (Ignored if the filter value is empty); when search is empty the rule is skipped

    A rule name Contains search with the switch next to the value turned on and its tooltip, Ignored if the filter value is empty

Date and time filters ​

If your table has date or date/time columns, the filter modal includes conditions designed for dates (for example “Is before”, “Is after”, “Is between”, and relative options like “Last 7 days” when available).

Use these for “Recent activity” style views.

Filtering using relationships (linked tables) ​

If your table has relationship columns (linked rows), you can filter based on fields inside the linked table.

For example, in an Orders view you might filter on the linked Customer record’s email.

Typical flow:

  1. In the filter modal, choose the relationship column (for example Customer).
  2. Choose a field from the linked table (for example email).
  3. Pick a condition and value (for example “Contains” → @weweb.io).

If your filter UI shows a scope selector, you can also “enter” a relationship scope first, then add filters inside that linked table scope.

Sorting ​

To configure sorting, click the Sort button above the table to open the sort modal.

From here, you can define how rows should be ordered by:

  1. Selecting the column you want to sort by
  2. Choose the order with the direction control (Asc or Desc)

You can then apply however many additional sorts you like by pressing Add sort.

The sort modal opened from the Sort button, sorted by createdAt in Desc order then by name in Asc order, with the Add sort button

Grouping records ​

Grouping sorts the records of a view into sections that you can open and close, like folders. For example, you can group deals by stage, invoices by month, or tasks by the person they are assigned to.

Grouping only changes how the view shows its records. It does not create, copy, or delete anything in your table.

A view grouped by stage and then by owner, with a count, a sum and an average for each group and an Overall line at the top

Add a group ​

  1. Click Group above the table.
  2. Pick the column you want to group by.
  3. Choose the order of the groups: Ascending (A to Z, oldest to newest) or Descending (Z to A, newest to oldest).

You can also open the ⋮ menu of a column header and select Group by this field.

The menu of the amount column, with Group by this field and Summarize options

The order you choose in the grouping panel only sorts the groups themselves. To sort the records inside each group, use Sort as usual.

Add subgroups ​

Click Add subgroup to split each group by another column. A view can have up to three levels.

For example, grouping by stage and then by owner creates one section per stage, with one section per sales rep inside it. The records sit inside the last level.

The Group by panel with two rules, stage then owner, both in ascending order

In the grouping panel, you can:

  • Drag a rule by its handle to change the order of the levels.
  • Remove a level with ×.
  • Use Collapse all or Expand all to close or open every group in the table.
  • Click Clear grouping to go back to a plain list.

Group dates and numbers ​

Date and number columns have extra options. To open them, click the settings icon (two small sliders) between the order and ×. The icon only appears on date and number columns. Hover it to see Choose date grouping intervals or Choose number ranges.

For dates, choose how big each group should be in Create one group per: Exact date and time, Day, Week, Month, Quarter, or Year. When you pick a date column, WeWeb groups it by Month to start with.

As soon as a date is grouped by period, Date grouping settings appear in the same box:

  • Time zone in Timezone, set to UTC by default. Pick another one from the list, such as Europe/Paris or America/New_York.
  • First day of the week in Week starts on, set to Monday by default. It only appears when you group by Week.

The time zone decides which day, month or year a record falls into. A deal closed at 12:30 AM on April 1 in Paris is still March 31 in UTC, so it lands in March with UTC and in April with Europe/Paris. These settings are saved with the view and apply to everyone who sees it, in the editor and in your published app.

A close_date rule grouped by Week, with the date grouping settings set to UTC and Monday

For numbers, choose Exact values to create one group per value, or Ranges to create groups of the same size. With a range of 25000, deals are grouped as 0 to < 25,000, 25,000 to < 50,000, and so on.

A view grouped by amount in ranges of 25000, showing three groups with their count, sum and average

Text and empty values ​

Text groups use the exact value, including uppercase letters and spaces. Paris, paris and Paris (with a space at the end) make three different groups.

Records with no value in the grouping column end up in a group called Empty. Text columns can also contain an empty text, which is not the same as no value: those records get their own group, Empty text.

Move records between groups ​

You can drag a record onto another group to change its value. For example, dragging a deal from Lead to Qualified updates its stage column to Qualified.

This only works when WeWeb can write the new value directly in the column. It is not available when the group is a period of dates (such as a month), a number range, or the result of a formula column.

When moving records is available, Add record at the bottom of each group of the last level creates a new record with the group's values already filled in.

Which columns can be grouped ​

  • Grouping is available for views of WeWeb tables.
  • You can group by text, number, yes/no (boolean), date, ID, and user columns, and by formula columns that return one of these types.
  • Lists, JSON columns, and fields of a linked table cannot be used for grouping.
  • A column that links to one record of another table appears as <column name> (linked ID). It groups records by the ID of the linked record, not by its name.
  • A view cannot be grouped while it is sorted by a field of a linked table. Remove that sort first.
  • To group records in an API Endpoint or a backend workflow, use the Get rows action, which has its own Grouping option. Learn more about Get rows →
The list of columns you can group by, including project_id (linked ID) and a formula column

Summaries ​

Summaries calculate a value for a column, such as a total or an average. They use every record that matches the view's filters, not just the ones visible on screen.

To add a summary, click the cell under a column header (it shows — when the column has no summary yet), then pick a calculation. You can also use Summarize this field in the ⋮ menu of the column.

The calculations you can pick depend on the column type:

  • Numbers: Sum, Average, Minimum, Maximum, Range, Median, Standard deviation.
  • Dates: Earliest, Latest, Date range.
  • Most columns: Count non-empty, Count empty, Count unique, Percent empty, Percent filled, Percent unique.

You can pick several calculations for the same column, for example the sum and the average of amount. Each one shows a check mark in the menu. Click it again to remove it, or use Remove all summaries at the bottom of the menu.

The summary menu of the amount column, with Sum and Average checked

In a grouped view, each group shows its own results, and the Overall line at the top shows the results for the whole view. Summaries also work on views that are not grouped.

Count empty and Percent empty only count records with no value. A text that is empty still counts as a value.

Loading grouped results ​

A grouped view does not load everything at once. In the editor:

  • Use Load more at the bottom of a group to see more of its records.
  • More groups load automatically as you scroll down the table.
  • Closing a group only hides it. Its records are not changed.

In your app, the first time the view is retrieved, it returns the first 10 groups of the last level with up to 30 records each. To show more, use the Table View: Load more action. Learn how to load more in your app →

Parameters ​

Parameters allow you to pass dynamic values into your views, allowing you to then pass these values onto your filters and sorting to make them truly dynamic.

To create parameters, click the Parameters button above the table.

To add a parameter:

  1. Click Add Parameters
  2. Enter the Parameter name
  3. Choose a Parameter type: Text, Number, Boolean, or Object
  4. (Optional) Set a Default value formula
  5. Click Save
The Parameters modal with a search parameter of type Text, an empty default value, and the Add Parameters and Save buttons

Using Parameters ​

To use a parameter in filters and sorting:

  1. Bind the value used for a filter or sort
  2. Set it to use the newly created parameter
A filter rule name Contains with the bind icon next to its valueThe binding window of the rule, with the search parameter listed under Parameters and used in the formula

Now, whenever you use the Table View: Fetch action in a workflow from the interface, you will be able to define what you wish to pass in for the values of the view's parameters.

A Table View: Fetch action set to the Search tasks view, with a field for its search parameter

Practical examples:

  • Text search: create parameter search (Text), then filter: name Contains search or description Contains search
  • Price filter: set parameter minPrice (Number), then filter: price greater than minPrice

Securing your views ​

When you are creating a view, it is crucial that you ensure your users are only able to retrieve data that they are allowed to retrieve.

For example, an admin should be able to see all records, and a user should only be able to see records that belong to them.

There are multiple ways to secure your views depending on your requirements:

Securing based on authentication ​

If you wish to restrict access to a view simply depending on whether or not somone is signed in, then you can use the Access select.

Here you can easily restrict access to a view to only authenticated users (AKA users who are signed in):

  1. Click the access button above the table. It shows the current access, Public or Authenticated.
  2. Open the select at the top of the popover.
  3. Choose Authenticated.
The access popover of the My tasks view, with the select open and Authenticated chosen instead of Public

Securing based on a specific role ​

Restricting a view to signed in users is often not enough. An admin dashboard, for example, should only return its records to the people who actually hold the admin role, not to every user who happens to be signed in.

To do this, open the Access select, keep it on Authenticated, then add the roles that are allowed to retrieve the data. The Match any control decides how those roles are combined, so a user needs to hold at least one of the roles you listed.

The Access popover set to Authenticated, with a Match any condition restricting the view to the admin role

Once roles are in place, the label at the top of the popover changes to Authenticated with role restrictions, so you can confirm at a glance that the view is not left open to every signed in user.

Learn more about managing roles →

Warning on views of the users table ​

Some tables are managed by WeWeb, like the users table listed under Auth System in your tables. It holds every user of your app, so a view on it that is left open shares all of them.

When such a view has no filter and no middleware, a warning icon appears next to the access button. Hover it to read what is exposed:

  • A red icon means the view is Public: anyone, even signed out, can read every row.
  • An orange icon means the view is Authenticated without any role: every signed-in user of your app can read every row.
An orange warning icon next to the Authenticated access button of a view on the users table, with its message: every signed-in user of your app can read every row

Click the icon to open the Access popover, then restrict the view with a role, a filter or a middleware. The icon goes away once the view is protected.

Securing with middleware ​

Some rules cannot be expressed with roles alone. Whether a user owns the record they are asking for, belongs to the right team, or is on a plan that gives them access to this data are all questions a role cannot answer on its own.

For those cases, click Add middleware for more control in the same Access popover and pick the middleware you want to run. The middleware runs before the view returns anything, so the records only reach the user once your own logic has approved the request.

Middleware is reusable, so a rule you write once (for example checking that the current user belongs to the workspace they are asking about) can protect several views, API Endpoints, and event triggers at the same time.

Learn more about middleware →

Securing data to a specific user ​

To make it so that a user is only able to retrieve data that belongs to them, you need to:

  1. Create a column of type Link to Users
  2. Link the appropriate records to their given user
  3. Set up a filter to only get the records linked to the current user
The Add column panel with Link to Users chosen as the Column TypeThe Update Row window of a task, with the owner field holding the ID of a userThe filter of the My tasks view, with the rule owner Is Auth user id

This ensures the view only returns records that are linked to the user retrieving the data.

Relationships (linked rows) ​

Relationship columns let a view “reach into” linked tables. This is useful for:

  • Filtering by fields on a linked record.
  • Showing extra fields from the linked record (not just its ID).

Next to an enabled relationship, you’ll also see a gear icon. This opens the relationship Settings, where you can:

  • Set a Display name (alias) to rename the relationship in this view.
  • Choose a Join type:
    • Left: keeps rows even when the linked record is empty.
    • Inner: removes rows where the linked record is empty.

Showing fields from a linked record (Columns panel) ​

In the view columns panel, relationship sections are typically grouped as:

  • References (links from your table to another table)
  • Referenced by (tables that link back to your table)

To include data from a linked record, open the Columns panel and turn on the relationship using the toggle next to its name. Once it's enabled, the relationship expands and shows a Columns section where you can pick which fields from the linked table should be included in the view results (or select all).

Nested relationships ​

You can configure relationships multiple levels deep (for example Order → Customer → Company) and apply filters to fields at each level.

Formula columns ​

Formula columns calculate values from other columns in the same row. In a view, you can show, hide, filter, and sort them just like regular columns.

You can create a formula column from the view itself or from the table's root Data tab. Either way it belongs to the table, so every view of that table can then show it from its Columns panel.

Legacy Formula V1 columns must be upgraded before filtering or sorting by their values. For missing fields or failed calculations, see Formula errors. Publish the project after changing a formula to update views used by the published app.

Learn how to create and use formula columns →

Using a view in the interface ​

The flow of using a view in the interface is as follows:

  1. In a workflow, use a Table View: Fetch action to get the data of your desired view. If you have any parameters set up, you will be able to define what should be passed to those parameters.
  2. When the Table View: Fetch action has run, you will then be able to access the data of the view from the binding menu.
  3. With the data of the view now available, you can use it in the interface. Meaning, you could bind it to a repeating list of items to display the data.
An Add task workflow whose Table View: Fetch action retrieves the My tasks viewThe binding window with the tasks - My tasks view under Table views, showing its data, metadata, isLoading, isLoaded and errorA container with Repeat Items turned on and Items bound to the data of the My tasks view

Paginate a view ​

When a view returns many records, you can show them a few at a time. First, set how many records the view returns per page: open the view in the Tables subtab of Data & API, click Pagination, and set Rows per page. See the Rows per page setting →

The view then tells you where you are in its metadata:

  • limit — the number of records per page
  • offset — the number of records skipped before the current page (0 on the first page)
  • nextOffset — the offset of the next page, or empty on the last page
  • total — the total number of records
json
{ "limit": 2, "offset": 2, "nextOffset": 4, "total": 5 }

To move through the pages, use one of these two actions in a workflow:

  • Table View: Change page replaces the records shown with another page. Use it for Previous and Next buttons, or to jump to a page. In Offset, bind the number of records to skip: nextOffset for the next page, or offset minus limit for the previous one. The action keeps the parameters of the last time the view was retrieved.
  • Table View: Load more adds the next page below the records already shown. Use it for a Load more button or an infinite scroll. It only needs the view: it reads nextOffset itself.
A Table View: Change page action set to the All tasks view, with Offset bound to the view's nextOffsetA Table View: Load more action set to the All tasks view, with the Limit field of the Advanced section left empty

Both actions have a Limit field in their Advanced section. Leave it empty to use the Rows per page of the view.

When nextOffset is empty, there is nothing more to load: Table View: Load more then fails with No more data to load. To avoid it, hide your Load more or Next button when nextOffset is empty.

PAGE NUMBERS

To show page numbers instead, use the Paginator element: it changes the page of the view for you. Learn more about the Paginator →

For a grouped view, Table View: Load more works group by group. See how to load more records in a grouped view →

Display a grouped view ​

A grouped view gives your interface a list of groups instead of a plain list of records:

  • A view without grouping returns its records in data.
  • A grouped view returns its groups in groups.

Each group contains its label (the value shown as the group name), its count (how many records it holds), and its summaries. A group that has subgroups lists them in children. Only the groups of the last level contain the records themselves, in rows.

To show the deals pipeline below, grouped by stage and then by owner:

  1. Retrieve the view with a Table View: Fetch action, for example in a workflow that runs when the page loads.
  2. Add a container for the stages, and bind its repeated items to the view's groups.
  3. Inside it, add a text bound to the group's label, and another one bound to its count.
  4. Add a second container inside the first one for the owners, and bind its repeated items to the current group's children.
  5. Inside the owner container, add a third container for the deals, and bind its repeated items to the current group's rows. Each item is now a record, so you can show its name and amount.
A Sales pipeline page with a Lead card showing 4 deals and $46,300, split into one block per sales rep with their deals and a Load more button

When you bind an element inside these containers, open the binding window and look under item.data: it shows every value of the current group.

The binding window showing the current group with its id, label, count, summaries, children, childrenPageInfo and rows

FINDING THE RIGHT SUMMARY

In the binding window, each summary is listed under a generated code (for example d15d2424-…) rather than its name. Use the value shown next to it to recognize the one you need. The results for the whole view are in the view's metadata, under summaries.

Load more records in a grouped view ​

To let users see more than the first records of a group, add a Load more button inside the group and give it a workflow with the Table View: Load more action:

  1. Select your view in Table View.
  2. Bind Group to the group the button belongs to (item.data when the button sits inside the repeated group).

What the action loads depends on the group you pass:

  • A group of the last level: its next records.
  • A group with subgroups: its next subgroups.
  • No group: the next groups of the first level.
A Table View: Load more action set to the Pipeline by stage view, with Group bound to Item.data

To hide the button once everything is loaded, bind its display to the group's childrenPageInfo.hasMore: it is true while there is more to load.

Continue learning

Once you have your tables created and are using views to appropriately display the data, the next core step will likely be setting up secure logic using backend workflows.

Learn more about backend workflows (API Endpoints) →