Feature Overview

In This Topic

Xross Mode Feature Settings

This topic discusses the flow of feature settings on the Xross mode's Plug-in Settings screen. For more information on view type, refer to View Types topic.

Select a view
Select the view to be configured from Views dropdown of the ribbon area.
※Only views with display format set to custom are displayed in the Views dropdown.
Select a mode
Click the Sheet icon in the upper left and change it to Xross.
Set display items
Drag and drop the field from the field area to the field drag area.
Feature Settings
For detailed description about feature settings, see the sub-topics.
Save the settings and update the app
Click Save and Publish to save the krewSheet settings and overall app settings, and run the app.

Setting Page

This section discusses the details of settings page of Xross mode.

Setting	Description
1	Plug-in information area.
2	Ribbon area. Menus of various features.
3	Field area that displays the fields to be placed in the pivot table area. This area displays the following fields: Fields placed in the Form tab of the Kintone app Tables created in the Form tab of the Kintone app Fields specific to Xross mode Calculated Fields Sub fields of Date / Time / Date and time field You can expand the Date / Time / Date and time field. Also, you can cut out the "Year" and "Month" of the Date / Time / Date and time field and calculate them in groups such as "Year" and "Month". Fields automatically assigned by Kintone when the record is created Record number Created by Created datetime Updated by Updated datetime The following fields cannot be used in PivotTable. Rich editor Text Area Attachment Category
4	Field drag area where you can drop the desired field from the field area to view and aggregate the field. You can customize the display format using the various features of the ribbon area.
5	Pivot table area is an area in which a pivot table is created based on the fields dragged into the field drag area.
6	Click Save Plugin Setting button to save the krewSheet settings done on this page. On clicking the Save and Publish button, changes done in the app are also saved along with the krewSheet settings done on this page. This operation is same as that of Update App button of the App Settings tab.

The data in the sheet area of the Plug-In Setting page is not editable. It is displayed as a sample for confirming the value of the setting.

Ribbon Menus

Home

Reuse the Settings by copying them.
Change the view type (View Types).
Setting up fields
- You can customize the fields in "Settings" as follows.
  - Fields dragged into a row or column field drag area: Change the label, Change column width, Show Items with no data, Sort and Filter and Custom Subtotals.
  - Fields dragged into a value or column field drag area: Change the label, Change column width, Subtotals and Grand Totals、Value to display in null or non null cell and Aggregation.
Set row height: If Auto Fit Row Height option is checked, the height is automatically adjusted in accordance with the font size.
Set format of fields
- Format: Set the format for each field.
- Conditional Format: Set the format applied to cells that satisfy certain conditions.
Set the first month of fiscal year.
- The kintone advanced settings for the first month of the quarter are not enabled in krewSheet.
- Setting the first month of fiscal year affects the date subfields such as "Year-Quarter", "Year-Month", "Year", "Quarter", and "Week".

Data

View

Set Style
Freeze Columns: The columns before the one you've selected will be fixed. The frozen columns aren't scrolled.
Unfreeze Columns: Release the frozen columns.

Design

Subtotals and Grand Totals
+/- Buttons: You can choose to show/hide the +/- buttons and expand the buttons during initial display.
Show Detail View：Display Source Data
Field Drag Area: Set whether to display the field drag area in the Plug-in Settings page.

Settings

Disable Features
Locked Cells Format: Set the text color and background color of cells in non-editable value fields.
Cells to Add New Records Format: Display an icon or set a background color in cells where new record is added.

File

Reusing Settings