Retaining Formula, Label, and Comment Rows and Columns on Flex Forms

You can retain formula rows and columns on flex forms by enabling the "Show invalid members for flex form" option during form definition. When a Service Administrator enables this option, formula rows and columns are retained on the flex form after a refresh or a submit.

Note:

Formula rows and columns are also referred to as label or comment rows and columns.

After a refresh or submit operation, all members and data on a formula row or column are highlighted using the same cell style as used for invalid members, described in Retaining Invalid Members on Flex Forms.

Note:

Attempting to delete an entire row or column by using the Delete key to delete only the member cells of a row or column will result in invalid members in the member cells upon refresh. To delete entire rows or columns on a flex form, select the entire row or column, right-click, and then select Delete from the Excel context menu.

Enabling the Show invalid members for flex form option gives users the versatility of flex forms when working with forms containing formula rows and columns.