Mashmatrix Sheet
English
English
  • Mashmatrix Sheet User Guide
  • Introduction
  • Application Overview
  • Basic Usage
  • Functions about Books / Sheets
    • Create a New Book
    • Change Book Setting
    • Duplicate Book
    • Delete Book
    • Open Book in New Tab
    • Change Book Sharing Folder
    • Split Book Screen
    • Create a New Sheet
    • Change Tab Display Order of Sheets
    • Change Sheet Setting
      • Sheet Setting - Basic
      • Sheet Setting - Options
      • Sheet Setting - Filter
      • Sheet Setting - Actions
    • Maximize Sheet
    • Duplicate Sheet
    • Delete Sheet
    • Create a Related Sheet
    • Create a Card Type Sheet
    • Change Card Type Sheet Setting
    • Configure Views
    • Configure Search Form
  • Functions about Displaying Data
    • Change Columns Order
    • Change Column Width / Height
    • Fix Column from Scrolling
    • Sort
    • Filter
    • Change Column Setting
      • Column Setting - Basic Property
      • Column Setting - Options
      • Column Setting - Format
    • Show / Hide Column
    • Add Column
    • Delete Column
    • Group Column Headers
    • Summary Row
    • Formula
    • Function
      • Salesforce Compatible Functions
      • Aggregation Functions
      • Other Extension Functions
    • Reference Value
    • Navigate Pages and Reload Records
  • Functions about Editing Data
    • Edit / Save Displayed Data
    • Copy & Paste Values
    • Create a New Record
    • Duplicate Records
    • Delete Records
    • Lookup Search
  • Functions about Actions
    • Action Button
    • Standard Actions
    • Marketing Actions
    • Custom Actions
    • Approval Request Actions
  • Functions for Advanced Usage
    • Time-Series Matrix Transformation
      • Overview
      • Add Matrix Column
      • Change Matrix Column Setting
      • Show / Hide Column
      • Add Child Column
      • Delete Child Column
      • Format
      • Matrix Column and Formula
      • Limitations
  • Settings for Admin
    • Assign License
    • Grant Permission Set
    • Administration Console
    • Organization-Level Configuration
  • Customization
    • Access Sheet Directly with URL
    • Sheet Component
    • Embed Sheet in Layout using Visualforce
    • Using Sheet Component in Visualforce
    • JavaScript API
    • Launching Custom Apex / Visualforce
    • Launching Flow
    • Using in Experience Cloud
Powered by GitBook
On this page
  • Filter Group
  • Filter Group Restriction
  1. Functions about Books / Sheets
  2. Change Sheet Setting

Sheet Setting - Filter

PreviousSheet Setting - OptionsNextSheet Setting - Actions

Last updated 3 years ago

In the "Filter" tab, you can update and confirm the filter setting for displaying records.

  • [A] Show me – Specify the target of the record to display in the sheet. Choose one of the following:

    • All Records - Target all accessible records in the organization

    • My Records - Target records owned by logged-in users

  • [B] List of Applied Filters – The list of filter information currently applied is displayed which comes from the filter setting of the columns included in the sheet.

You can manipulate each filter from the filter menu displayed in the list of filters.

  • [D] Disable Filter - Allows you to temporarily disable the filter. Disabled filters are shown in light gray.

  • [E] Clear Filter - Allows you to clear the filter.

Filter Group

From the list of applied filters, you can create a new filter group. A filter group applies a filter by combining multiple filters as a group, subject to satisfying any one of the filters contained in the same group.

To create a new filter group, follow these steps:

  1. From the list of applied filters, select the filter you want to add to a filter group and select "Create New Group" from the menu [a].

  2. A filter group is created in the filter list and the selected filter is displayed in the group [b].

  3. From the list of applied filters, select the filter you want to add to the created filter group and select the name in the "ADD TO GROUP" list in the menu [c].

  4. The filter is added and displayed in the filter group [d].

  5. Repeat steps 3 - 4 for the number of filters you want to add to the group

  6. Press the "Save" button.

  7. On the column headers, numbers are displayed in the grouped filters to indicate the filter is grouped [e].

To exclude a filter from a filter group, follow these steps:

  1. From the filter displayed in the filter group, select "Remove from Group" from the filter menu to be excluded.

  2. The filter is displayed outside of the filter group. Groups with no filters are automatically deleted.

  3. Press the "Save" button.

Filter Group Restriction

Filters in a filter group have the following restrictions, depending on the column where the filter is applied.

  • Filters for different kind of columns cannot be in the same filter group. For example, a filter for a data column cannot be added to a filter group consisting of filters for field columns.

  • Even if the kind of columns are of the same field column, filters for fields through polymorphic relationships and for fields of the object linked to the sheet or through normal relationships cannot be in the same filter group.

[C] Edit Filter - Displays the "Filter Settings" dialog where you can change the filter settings for the column. See for details.

"Filter"