Views

Views allow the user to search and manipulate data

Along with tables, views are one of the two foundational concepts used when building applications with Agilebase.

What is a view?

In fact, the concept of a view is not unique to Agilebase, it is a core part of any database system, including the PostgreSQL database that Agilebase uses to store, manipulate and report on data.

Here are some of the advantages a view can offer, as explained by the Wikipedia Article on database views, slightly shortened.

  • Views can represent a subset of the data contained in a table.
  • Views can join and simplify multiple tables into a single virtual table.
  • Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data.
  • Views can hide the complexity of data

In a nutshell, creating a view in Agilebase allows you to display information to the user in an easily searchable format. A single view of data can contain fields from many different places placed alongside each other. It can be filtered down to a subset, and/or contain summarising data like counts, totals or averages.

Views can utilise the full power of the SQL language (mostly behind the scenes with complexity hidden from administrators) to create useful and advanced reports where necessary.

On the screen, a view is most usually output as a series of rows of data, with field names as column headings - like a spreadsheet.

view

There are also other ways of displaying the output, such as in a calendar or document library interface.

Views are organised into tiles. Each tile contains a collection of views, organised into a menu system within it. Administrators can hence organise the display of data in a logical fashion.

Behind the scenes uses

As well as showing data to users, the power and flexibility of views allows them to be used in a multitude of different ways useful for administrators. For example, in workflow automations, to create APIs to allow third party systems to query the data, or to control hiding and showing fields.

There are many other uses we’ll come across throughout this documentation, in fact almost every major feature depends on views in some way.

So it’s a useful topic to understand.


Creating a view

How to create a new view and place it in a navigation structure

Joins

Using joins to merge data from multiple sources into one view

Calculations

Adding calculations to a view

Filters

Adding filters to a view

Special Uses

Creating application functionality using views

Options

Many options affect how views look and behave


Last modified November 27, 2023: Pivot table example (80c844c)