Mashmatrix Sheet
English
EnglishJapanese
English
EnglishJapanese
  • 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
  1. Functions for Advanced Usage
  2. Time-Series Matrix Transformation

Limitations

The time-series matrix transformation currently has the following limitations.

  • Sorting and filtering cannot be applied for the child column of the matrix column.

  • The option setting "Recalculate Formula on Record Update" is not currently available for the formula field child column of the matrix column.

  • Currently only one type of object can be displayed inside one matrix column.

  • If there is more than one record in the related list that matches a certain time series value, the first record found by the Mashmatrix Sheet is selected and used. Any priority or filter condition cannot be specified currently.

  • If you clear the value displayed in the matrix column cell, a blank value is written to that field, not deleting related records automatically. Therefore, if a time-series matrix transformation is performed on a related list that includes required fields, errors for required field may occur when values ​​are cleared to blank and saved.

PreviousMatrix Column and FormulaNextSettings for Admin

Last updated 2 years ago