Reflecting an Aggregate Result on a Different App
You can export an aggregate result to a file, and then reflect it on another app by importing the exported file. The steps to perform this action are as follows.
(1) Perform data aggregation
(2) Export the aggregate result to a file
(3) Enable the "Prohibit duplicate values" setting if needed
(4) Import the exported file to a different app
The following example shows how to calculate the sales amount by customer in the "Sales Management" app and reflect the calculation result to the "Customer Database" app.
Performing Data Aggregation
First, create a chart to calculate monthly sales by customer in the "Sales Management" app.
-
Open the "Sales Management" app.
-
Click the App Settings icon (the gear-shaped icon) at the upper right of the "View" screen.
-
On the App Settings screen, click the Graphs tab.
-
Click the Create Graph icon (the plus sign-shaped icon) at the right of the screen.
-
Specify the Chart Type, Function and more that you want to use for the chart.
The following shows an example of the settings.- Chart Type: Table
- Level 1: Customer Name
- Function: Sum, Sales Amount
-
Click Save on the upper left side of the screen.
-
Click Update App at the upper right of the screen.
-
On the confirmation dialog, click Update App.
Exporting the Aggregate Result to a File
Next, export the aggregate result data to a file.
-
In the "View" screen of the "Sales Management" app, display the aggregate result you want to export.
-
Click the Options icon at the upper right of the screen, then click Export to CSV File.
-
Specify necessary options to export, and click Export on the upper left of the screen.
-
Click the name of the exported CSV file and download the file.
Enabling The "Prohibit Duplicate Values" Setting if Needed
In order to update the existing records, you need to specify the field that you want to use as "Key to Bulk Update" when importing a file.
If you want to specify the field other than the Record number as "Key to Bulk Update" (such as Text, Number, Date, Date and time, or Link), the "Prohibit duplicate values" setting needs to be enabled before configuring this setting.
In this example, "Customer Name" field (a Text field) is used as "Key to Bulk Update". Therefore, you first need to enable the "Prohibit duplicate values" setting for the field in the "Customer Database" app.
-
Open the "Customer Database" app.
-
Click the App Settings icon (the gear-shaped icon) at the upper right of the "View" screen.
-
On the "App Settings" screen, click Form tab.
-
Hover your cursor over the Field Settings icon (the gear-shaped icon) for the "Customer Name" field, then click Settings.
-
Select the Prohibit duplicate values checkbox, then click Save.
-
Click Update App at the upper right of the screen.
-
On the confirmation dialog, click Update App.
Importing the Exported File to a Different App
Lastly, import the file exported from the "Sales Management" app into the "Customer Database" app.
- Click the Options icon at the upper right of the "Customer Database" app screen, then click Import from File.
- Click Browse and select an Excel or CSV file to import.
- Select one of the radio buttons under Select Data Scope. If your file has column names in the first row, select First row is header.
- Specify a column in the file for each field in the app.
In this example, select the "Customer Name" and the "Sales Amount" fields in the "Column in File", and select the check box for "Customer Name" in "Key to Bulk Update". - Click Import on the upper left side of the screen.