Aggregate Table
Introduction
Functions
You can use aggregate tables for aggregation calculations and pre-calculation (pre-processing) of existing form data for further invocation. Currently, when designing forms, you can use data in aggregate tables through Data Linkage, RelatedQuery, and RelatedData.
Application Scenarios
The best scenario for aggregate tables is: purchase, sales, inventory.
This can be in the standard process of purchase, sales, inventory, or it can be a business scenario, such as annual leave days (purchase), days off (sales), days left (inventory).
Terminology Explanations
Terminology | Explanation |
Rename | Click the upper left of an aggregate table to rename it. |
Data Source | If there is a single form, directly click it. If there are multiple related forms, you need to set related fields after selecting forms. |
Set Filter | Set filters to filter out useless data and then calculate data to ensure the accuracy and validity of pre-processing data. |
Row Header | It is the beginning part of each row in the aggregate table. Generally, the fields in the header of the row are arranged vertically on the far left, and the values corresponding to the form are arranged horizontally. |
Measure | Currently only supports measure aggregation. Available arithmetic operators are additions (+) and divisions (-). |
Plan Description
The function is a premium advanced function. Different plans have different limits for use.
Free Plan | Advanced Plan |
1 | 10 |
For details, see Jodoo Pricing.
Setting Procedure
Where to Create
1. Click Workspace > App > App Management:
2. Then select Aggregate Tables under Advanced Features:
- If you do not add aggregate tables before, you can add one by clicking New Aggregate Table on the middle panel or in the upper right corner.
- You can view and edit existing aggregate tables directly on the page.
Sorting Aggregate Tables
You can sort aggregate tables by drag and drop.
Using Aggregate Tables
Using aggregation tables is similar to using pivot tables. Compared with dashboards, the biggest difference is that data in the aggregate table can be used in the form. For example, in the inventory scenario, the calculated current inventory is applied to the outbound table to get the latest inventory in real-time and avoid negative inventory.
There are cases using aggregate tables: inventory case, data filtering case, examination booking case, etc.