Create a Related Sheet
Last updated
Last updated
With Mashmatrix Sheet, it is possible to create a related sheet whose display is updated in conjunction with the record selected on a certain sheet. This makes it possible to work while simultaneously displaying multiple information such as related lists.
To create a related sheet, follow the steps below.
Click the "+ (Create New Sheet)" button on the right side of the sheet tab.
Choose "Add Sheet" from the menu.
The "Create Related Sheet" dialog will be displayed.
A related sheet can be created from a related list of the object displayed on an existing sheet.
Select a sheet to be linked from "Source Sheet" [A]. The Related List tab displays a list of related lists for the objects in this source sheet.
Leave the "Sheet Type" [B] at the default "Grid".
In the "Related List" tab of the "Data Source of Related Sheet" [C], it displays the related list entries of the object on the source sheet, so select the entry you want to display as the related sheet.
If the screen of the book is not split, specify the area where you want to add a related sheet from "Add to" [C]. You can specify "Bottom" or "Right".
Press the "Create" button to create a related sheet.
If the book screen is not split, it will automatically split into "With Bottom Footer" layout when a related sheet is added, and the related sheet you created is placed in the footer area. If the book screen has already been split, the created related sheet will be added to the area where the clicked "+ (Create New Sheet)" button is located. Please refer to "Split Book Screen" for information on splitting a book's screen.
With related sheets, it is possible to link any object, not just the objects in the original sheet's related list. Click the "Custom Relation" tab to create a related sheet other than the related list.
In "Source Sheet" [A], select the sheet to be linked from.
Leave the "Sheet Type" [B] at the default "Grid".
In "Object in Related Sheet" [C], select an object that you want to display as a related sheet.
In "Matching Field in Related Sheet" [D], select a field from the fields of the object selected in "Object in Related Sheet", which accepts the filter for the relation.
In "Matching Type" [E], select how you want to match the filter.
Equals to - The related sheet automatically filters and displays records that match the value of the target record in the source sheet. If there is more than one target record, records that match one of the record values will be displayed.
Not equals to - The related sheet automatically filters and displays records that DON'T match the value of the target record in the source sheet. If there is more than one target record, records that don't match any of the record values will be displayed.
In "Key Column in Source Sheet" [F] , select a column in the source sheet that will be used as a key for the linkage. The value in this column becomes the search key for the filter.
In "Use Keys in" [G], specify the scope of records that will be used as a key of linkage.
Selected Records - The related sheet uses the value of the selected records in the source sheet as key. The selected records are either the records on which the cursor is located or the records selected by the record selection checkbox.
All Records in Sheet - The related sheet uses the values of all the records loaded in the source sheet as key.
Press the "Create" button to create a related sheet.
In the added related sheet, records are filtered and only displayed which relates to the selected record on the source sheet. Also, if you change the record selection of the source sheet, you can see that the display in the related sheet will be updated.
