Interactive Aggregations
Demonstrated Features
- Computed Fields
- Aggregations (docs)
- Column Filters
- Show | Hide Columns
- Detail Panel
Required Skills
- Beginner Level
Required License
- Premium
Opening this app in fullscreen mode will display all columns. The salary and commission columns are table columns that are saved in the database. The bonus and age columns are calculated fields. The age is calculated using the date of birth. The bonus is calculated using the salary and commission columns and is updated in real time when the user changes the salary or commission fields. Please note that updating the salary or commission fields also updates the aggregations in real time.
Transactions are prohibited for anonymous users. Any attempt to insert, update, or delete data results in an "Unauthorized" error message.
Technical Insights
Using the App Builder requires no coding. Computed code fields are an optional feature meant for users who want to go beyond the basic App Builder functionality to add their own custom logic, fine-tune app behavior, extend features, and integrate with custom workflows. If you are not interested in computed code fields, you can skip these technical tutorials.
Bonus Field Calculation
The Bonus field is a computed code field. It performs a basic calculation. Salary and commission columns are represented by the placeholders {:sal} and {:comm}, respectively. When using values from other columns, make sure to check for null values.
(
parseFloat("{:sal}") | 0) *
(({:comm} === null ? 1 : {:comm})
/ 100
)Age Field Calculation
The Age field is a computed code field. The age is calculated using the date of birth. The placeholder {:birthdate} represents the employee's birthdate.
(() => {
const today = new Date();
const birthDate = new Date("{:birthdate}");
let age = today.getFullYear() - birthDate.getFullYear();
const m = today.getMonth() - birthDate.getMonth();
if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) {
age--;
}
return age;
})()Adding Aggregations
Aggregations can be added in the Table Builder and do not require any technical expertise. The feature is available for numerical table columns and computed code fields. When inline editing is enabled for table columns, aggregations are automatically updated as the table column changes. This does not require any action on your end.
Aggregations - Docs