Submit a request

Advanced Form Settings

Avatar
Kepion Support
  • Updated

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 gear.png.

 

 

Settings

mceclip0.png

 

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.

Related articles