Views for Data Extraction

Overview

A View is a feature that extracts and displays data from a table based on specific conditions. You can see only the data you need without modifying the original table.

---

View Features

1. Saved Filter Conditions

Save frequently used filter conditions as views.

Example:

2. Non-destructive

Filtering data in a view does not modify the original table data.

3. Multiple Views per Table

Create multiple views from a single table to see your data from different perspectives.

4. Paginated Results

View results are shown up to 100 rows per page. When there's more data, use the page controls to see the rest.

---

Creating a View

Steps

1. Tap the create button (+) at the bottom-right of the screen
2. Select "View"
3. Enter the basic information:
   • Title: Name of the view (e.g., "Incomplete Tasks")
   • Base table: Select the source table (you can select up to 5 tables)
   • Visibility: PRIVATE / TEAM / PUBLIC
4. Set filter conditions
5. Set sorting (optional)
6. Select display columns
7. Click "Preview" to verify
8. Click "Create"

If you select two or more tables, you'll then see a screen asking how the tables should be combined (the join type, and which columns to match between them). Join types include "inner join," which shows only rows that match in both tables, and "left outer join," which keeps all rows from the first table.

---

Setting Filter Conditions

Single Condition

Example:

Multiple Conditions (AND)

Example:

Multiple Conditions (OR)

Example:

Complex Conditions

Example:

---

Sort Settings

You can set the sort order for data in a view.

Example:

---

Selecting Display Columns

Choose which columns to display in the view.

Example:

---

Aggregation and Grouping

A view can also work as a summary table, not just a filtered list. Choose a column to group by, then pick a calculation such as count, sum, average, minimum, or maximum, and the results are shown grouped and calculated. For example, you can build a summary like "task count per assignee" or "monthly sales total," combined with filters and sorting.

---

Practical Examples

Example 1: Views from a Task Management Table

Example 2: Views from a Customer Management Table

---

Editing and Deleting Views

Editing a View

1. Open the view
2. Click the "Edit" button in the top-right
3. Edit filter conditions, sorting, and display columns
4. Click "Save"

Deleting a View

1. Open the view
2. Select "Delete" from the menu (...) in the top-right
3. Click "Delete" in the confirmation dialog

Note: Deleting a view does not delete any data from the original table.

---

Tips and Tricks

1. Create Purpose-specific Views

Build multiple views from a single table for different purposes.

2. Use Clear View Names

Make it obvious at a glance what each view displays.

3. Combine with Graphs

Visualize view data with graphs for better insights.

---

Graph Types

Graph content supports the following 6 chart types.

---

FAQ

Q1: Can I edit data within a view?

A: No, the view's detail screen is read-only, so you can't edit data there. To change data, open the original table and edit it there.

Q2: What is the maximum number of views?

A: Views count as a content type. The number you can create depends on your plan's overall content limit (pages, tables, and views combined). See Plan Overview for details.

Q3: Can I create a view that spans multiple tables?

A: Yes. You can select up to 5 base tables and combine them. See "Creating a View" above for how to set the join type when you select two or more tables.