Advanced Form Settings – Kepion Support Center

Introduction

Advanced form settings provide users with a deeper level of customizability. You can access these settings by going to the General tab of the Form Editor and selecting Settings .

Settings

Note: All descriptions below refer to when the user has enabled the setting.

Setting	Description
Row aggregate indicator	Displays an entire row when containing a non-leaf member on the row axis, in user-selected color
Input cell and annotation indicator	Displays available input/annotation cells in user-selected color.
Drop-down indicator	Displays all drop-down cells that are available for input with the selected color.
Alternate row color	All even rows use the first color option, and odd rows use the second color option.
Increase and decrease color	On refresh, highlights numbers that increase in first color option and numbers that decrease in the second highlighted color.
Show grids on row	Displays gridlines on the row axis region.
Show grids on column	Displays gridlines on the column axis region.
Show grids on data	When checked, displays gridlines in the data region of the Form.
Show grids on corner	Displays gridlines in the corner of the Form between the row and column axis.
Show borders	Displays a border around the edge of the Form.
Red for negative numbers	Colors negative values in red.
Bold parent members on row	Similar to the row aggregate indicator, but displays data in bold.
Hide spreadsheet headers	Hides all spreadsheet headers.
Auto merge rows	Automatically merges row axis members with the same value to Form continuous cells, when possible.
Auto merge columns	Automatically merges column axis members with the same value to Form continuous cells, when possible.
Enable expand and collapse	Allows hierarchy members along row and column axes to be expanded and collapsed. Click here for more information.
Preserve user expanded and collapsed rows	Expanded or collapsed hierarchy members along the rows won't reset upon refresh. Click here for more information.
Preserve user expanded and collapsed columns	Expanded or collapsed hierarchy members along the columns won't reset when the Form is refreshed. Click here for more information.
Include all writeable to change list	All members within the writeable region will automatically be added to the change list.
Managed Formula	Translates formulas from spreadsheet coordinate space into MDX tuples.
Query includes annotation and text cells	Enables annotations on the Form. For large Forms, it is advised to have this property unchecked for performance considerations.
Smart Refresh	Data changes detected within a Dashboard App triggers an automatic refresh.
Override SSAS format	Formatting applied on the Form overrides any formatting applied by SSAS.
Discard user formula	Submissions automatically discard user-entered formulas upon saving. This feature is useful when managing multiple users who are inputting on the same slice of data, as it prevents formulas from being inconsistent between users.
Auto height	Automatically adjusts the height of rows to fit the content in the largest cell.

Introduction

Settings

Related articles