X-Sheets

Views & Filters

← Back to User Manual

7. Views & Filters

Views control how your data is displayed. Each view defines which sheet it reads from, which columns are shown, and an optional filter condition. You can create multiple views for the same data to serve different needs.

7.1 Accessing the Views Editor

  1. Open the spreadsheet context menu.
  2. Tap Manage Views.

The Views Editor page is divided into two sections:

  • Main Views — Top-level views that appear in the app’s view selector.
  • Sheet Views — Views associated with a sheet, grouped by sheet name. These appear as sub-views when viewing a specific record.

7.2 Creating a View

  1. In the Views Editor, tap Add in either the Main Views or Sheet Views section.
  2. Fill in the view configuration:
    • View Label (required) — A descriptive name.
    • Sheet (required) — Which sheet this view reads data from.
    • Reference Column (Sheet Views only) — The column that links this view’s sheet to the parent sheet.
    • Filter Condition (optional) — An expression to filter which rows appear (see below).
    • Columns to Display (required) — Select and reorder the columns you want visible.
  3. Tap Add to create the view.

7.3 Editing a View

Tap an existing view in the list to open the same configuration dialog. Modify any setting and tap Modify to save.

7.4 Column Selection

The column selector shows all available columns (both regular and virtual) except the primary key. You can:

  • Check/uncheck columns to show or hide them.
  • Reorder columns to control display order.

7.5 Filter Conditions

Filter conditions use the X-Sheets expression language to determine which rows appear in a view. The condition builder provides:

  • A text editor where you write filter expressions.
  • An Insert Function button — opens a picker with all available functions.
  • An Insert Operator button — opens a picker for comparison and logical operators.
  • Autocomplete for column names.
  • Real-time validation — errors are shown immediately as you type.

Filter Expression Examples


STATUS = "Active"
AMOUNT > 1000
CREATED_DATE >= DATE(2024, 1, 1)

STATUS = "Active" AND AMOUNT > 500
CATEGORY = "Electronics" OR CATEGORY = "Books"

YEAR(ORDER_DATE) = 2024
NOT(STATUS = "Archived")

For the full expression reference, see Expressions & Formulas.

7.6 Sheet Views

Sheet Views appear within the Form View when viewing a record. They display related records from another sheet linked via a reference column.

Example: An “Orders” sheet references a “Customers” sheet. An Sheet View on the Customers form could show all orders for the currently viewed customer.

To set up an Sheet View:

  1. Create a view in the Sheet Views section for the relevant sheet.
  2. Set the Sheet to the related data sheet (e.g., “Orders”).
  3. Set the Reference Column to the column that links to the parent (e.g., “Customer” reference column in Orders).
  4. Configure columns and optional filter.

7.7 Available Operators for Filters

Category Operators
Comparison =   <>   >   <   >=   <=
Logical AND   OR   NOT
Arithmetic +   -   *   /

Next: Expressions & Formulas →