Views
Learn more about views within Budibase
Views are virtual tables. I understand this may seem confusing, but it is the best description, and hopefully you'll understand why after reading the following docs.
When you create a View within Budibase, it presents you with all the data from its linked Table. This provides you with a canvas to manipulate your data without changing the data within the original table. This is crucial, as it protects your original data. It also allows you to create:
- Filters
- Groups
- Calculations
When designing your UI, you can reference data from your Views. So, if you have a table of sales people and their total sales, you can create a View and a Calculation which gives you the total sales of all sales people. You can then reference the data from this View in the design section of Budibase, and display the answer to the calculation.
How to create a new view
You must have a Table before you can create a View
To create a new table, click the create new view
button, and give it a name.
By default, a view will display all the data in your table. You should add a filter and/or a calculation to change data is displayed.
Filters
One of the core features of views is the ability to filter rows according to particular criteria. When a Row is filtered, it is not deleted—it's just hidden from the particular View you're using and remains within the table (Views are virtual tables!).
Try adding filters when:
- You need to focus on rows that meet certain conditions (e.g. Classes between May and June, and taught by Albert Einstein).
- You need to display certain information, to certain people (e.g Each salesperson can only view their own commission).
How to create a new Filter
To create a new Filter:
- Click the
Filter
button - Click
Add Filter
- Select the Column you would like to filter
- Select a filter function
- Type your query
- Click
Save
Filter functions
- Equals
- Less than
- Less than or equal to
- More than
- More than or equal to
- Contains
Calculations
Within Budibase, calculations are predefined formulas. Instead of writing the formulas, you can simply select from the list of predefined options.
How to create a new Calculation
You must have an active Calculation to use the Group feature
To create a new Group:
- Click the
Group
button - Select the Column you would like to Group by.
- Click save
Groups
Budibase's Group feature allows you to group your rows together based on the column of your choosing. You can only apply a group to a calculation.
Updated 11 months ago