What is an Aggregate Table?
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.
The best scenario for aggregate tables is purchase, sales, and inventory.
This can be in the standard process of purchase, sales, or inventory, or it can be a business scenario, such as annual leave days (purchase), days off (sales), or days left (inventory).
The feature is a premium advanced function. Different plans have different limits for use.
Free Plan | Advanced Plan |
1 | 10 |
For details, see Jodoo Pricing.
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 (-). |
How to Set up?
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.
How to Sort Aggregate Tables?
You can sort aggregate tables by drag and drop.
How to Use 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.
Cases are using aggregate tables: inventory case, data filtering case, examination booking case, etc.
I have finished reading. 🏆
👉I can't wait to Try for myself.
👉I need more HELP in Discord Forum.