1. Working with Oracle Smart View for Office
  2. Data Forms
  3. Flex Forms
  4. Best Practices for Working with Flex Forms
  5. Using Suppression Options in Flex Forms

Using Suppression Options in Flex Forms

  • In the form designer, the Use database suppression option is not supported; however, the Suppress missing blocks, Suppress missing data - Rows, and Suppress missing data - Columns options are supported.

    Note:

    Groovy rules are not supported in flex forms when suppression options are enabled.
  • The Suppress missing blocks, Suppress missing data - Rows, and Suppress missing data - Columns options defined in the web for a flex form are applied only when first opening the flex form in Oracle Smart View for Office. Depending on the form definition, flex form users can enter members on columns or rows even though the suppression options are enabled in web form. Users can also enter data and submit data for the suppressed members.

    If the suppression options in the Smart View Options dialog, Data Options tab, for Suppress Missing Blocks, Suppress Missing Rows, and Suppress Missing Columns are selected, they are applied to the flex form. Users can uncheck these options in Smart View and then add members (by typing them on the sheet or using Member Selection), enter data, submit data, and refresh the flex form.