## Overview The number of records in the "Child Table" to which a "[Link](/en/manual/table-record-import-and-link)" has been set, as well as the sum, average, maximum, and minimum of the "「Numerical Item」", are stored in the "「Numerical Item」" of the records to which the link has been set in the "Parent Table". The "「Summary」" function works when a linked child record is added, updated, or deleted. ## Limitations 1. If the link item is set to multiple selections, it cannot be aggregated correctly. 1. If child records exist before the summary settings are made, the sync function must be used to reflect the aggregation results. 1. The summary function only works one level from the "Child Table" to the "Parent Table". Even if a summary is set for the "Parent Table" to its "Parent Table", multi-level summarization will not be performed. ## Prerequisites 1. "Site Administration Permission" is required to configure settings. 1. To use the summary function, set a "[Link](/en/manual/table-record-import-and-link)" to the child table as a preliminary step. ## Operation Procedure 1. Open the "Child Table" where a "[Link](/en/manual/table-record-import-and-link)" is set. 1. Click "「Table Management」" from the "Manage" menu. 1. Open the "「Summary」" tab. 1. Click the "Create New" button. 1. In "[Site](/en/manual/site)" on the left side of the dialog, set the "Parent Table" where the summary results will be saved. 1. In "「Item」" on the left side of the dialog, set the "「Item」" of the "Parent Table" where the summary results will be saved. 1. If "[View](/en/manual/table-record-view)" is set for "Parent Table", you can specify "[View](/en/manual/table-record-view)" for "「Condition」" on the left side of the dialog, "「Summary」" will not be performed for "Parent Record" that do not match the "[Filter](/en/manual/table-record-search)" specified for "[View](/en/manual/table-record-view)". 1. If "「Condition」" is selected on the left side of the dialog, you can specify "Set to zero if the condition is not met". Check this box to store zero when the "[View](/en/manual/table-record-view)" condition is not met. If this box is unchecked, the numerical value will not change. 1. In "Link Item" on the right side of the dialog, set the "「Item」" that is associated with the "Parent Table". 1. In "Summary Type" on the right side of the dialog, set either count, total, average, maximum, or minimum. 1. Set the "「Numerical Item」" that contains the numerical value to be aggregated in the "Summary Item" on the right side of the dialog. If "Summary Type" is set to "Count", this item will not be displayed. 1. If [View](/en/manual/table-record-view) is set in the "Child Table", you can specify "[View](/en/manual/table-record-view)" in "「Condition」" on the right side of the dialog. "Child Record" that do not match the "[Filter](/en/manual/table-record-search)" specified in "[View](/en/manual/table-record-view)" will not be aggregated in the summary. 1. Click the "Add" button. 1. Click the "Update" button at the bottom of the screen. 1. If there are already records to be aggregated, check the target "「Summary」" and click the "Sync" button to execute the summary of the existing records. ## Operation Image  You can select the summary type from "Count", "Total", "Average", "Minimum", and "Maximum". In this case, insert the "Total (Set by Summary Type)" of the "Amount" item of the child table for which the summary is set into the "Purchase Total" item of the parent table "Business Negotiation" table. Data registered before the summary setting registration will not be aggregated, so click the "Sync" button after setting. To synchronize, check the box to the left of the row of the summary you want to synchronize from the list and click the "Sync" button.  ## Usage Example As an example, create an application to manage inventory.  Create two record tables: Inventory Management and Inbound/Outbound Management. Inventory Management Table  Inbound/Outbound Management Table  Link the Inventory Management table as the parent and the Inbound/Outbound Management table as the child.  Since the Inventory Management table will be the master for products, register the product names. Leave the inbound quantity, outbound quantity, and inventory quantity as zero since they will be calculated automatically.  Set up the calculation formula to automatically calculate the inventory quantity.  Set up the summary in the Inbound/Outbound Management table as follows to automatically calculate the inbound and outbound quantities.    Create a new record in the Inbound/Outbound Management table. The product name linked to the Inventory Management table will be displayed in the product name linked to the Inventory Management table.  Enter the outbound quantity and register.  The content registered in the Inbound/Outbound Management table is automatically reflected in the Inventory Management table.  ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/site">Site Function</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-record-search">Table Function: Search for Record (Filter)</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-view">Table Function: Switch Record Views</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-import-and-link">Table Function: Import Records and Link Master Data</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-view">Tables Management: View</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/api-view">開発者向け機能：JSONデータレイアウト：View</a><span>11.06.2023 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />