You can retrieve data from an aggregate table through fields, such as Data Linkage, Select Data, and Query Data. In a dashboard, an aggregate table can also be used as a data source.
Aggregate tables are widely used in many scenarios, such as the PSI (Purchase/Sale/Inventory), the annual leave management for employees, the calculation of membership card balance, and the material application.
What Does It Look Like?
Take the PSI scenario as an example. When you sell products, you need to retrieve the inventory data from an aggregate table. If the outbound quantity is greater than the actual quantity in stock, a corresponding prompt will be given.
How to Retrieve?
Option 1 Retrieving Data through Data Linkage
Click the field you need to link, go to Field Properties > Initial Value, select Data Linkage, and select an aggregate table. Then you can retrieve data from the aggregate table in real time and the data will be submitted to the system with the form.
Option 2 Retrieving Data through Select Data
Drag the Select Data field to a form or a subform (multiple records) and select an aggregate table from the drop-down list of Related Form. Then you can retrieve data from the aggregate table.
Note:
The data from the displayed fields will not be submitted to the system with the form. If you expect it to happen, you have to set Data Filling. For details, see Select Data.
Option 3 Retrieving Data through Query Data
Drag the Query Datafield to a form, and select an aggregate table from the drop-down list of Related Form. Then you can retrieve data from the aggregate table. The retrieved data will be displayed but will not be submitted to the system with the form.
Option 4 Retrieving Data in Dashboard(s)
An aggregate table can be set as the data source for the Stats and Detail Table. In Dashboard, select Stats or Detail Table and select an aggregate table in Data Source. Then you can display the data in the aggregate table.
What are the Differences between the Three Retrieving Methods?
In retrieving an aggregate table, the difference among the three retrieving methods (including Data Linkage, Select Data, and Query Data) is whether to store data.
1. Store data in the system.
Data storage refers to submitting the data to the system with the form. Submitted data will be displayed on the Manage Data page. If there is no manual modification, the stored data will not change. Even if the previously retrieved data has changed, the stored data will not change.
2. Not store data in the system.
It means that the system will retrieve the real-time data for querying purposes without storing it in the system. For example, you need to check the inventory of apples to make decisions on the quantity to be purchased. However, you do not expect the value of the Inventory field to be stored in the system, thus avoiding unnecessary storage of temporary or transient data.
Note:
The stored data can be used in the calculations such as formulas, and the unstored updated in real-time.
I have finished reading. 🏆
👉I can't wait to Try for myself.
👉I need more HELP in Discord Forum.