Skip to Content

Visibility columns in Jitterbit App Builder

Visibility columns allow developers to define the visibility of specific data columns at the panel level using a static configuration method. Visibility columns are a good option to control visibility when you have straightforward, unchanging UI requirements where columns do not need to react to user roles or runtime conditions. When the visibility of a given column should change dynamically, visibility rules are the more adequate solution.

Comparison of visibility columns and visibility rules

  • Visibility columns: Effective for simple scenarios where a field should remain hidden or visible in the UI across the entire application.

  • Visibility rules: The preferred method for most modern use cases. These rules allow conditions to be evaluated at runtime, enabling columns to appear or disappear based on specific criteria, such as a record's status or user permissions.

How to use visibility columns

Using visibility columns involves manually setting a "usage block" to hide or show specific fields within a panel. This configuration is "static" because it does not change based on user roles or complex logic during a session.

A visibility column can evaluate to three values with these meanings:

  • 1: Visible.

  • 0: Hidden (collapsing the space on the page where the panel would have appeared).

  • 3: Hidden (preserving the space on the page where the panel would have appeared).

To configure a visibility column, follow these steps:

  1. Navigate in the App Builder app to the parent Panel for the child Panel you wish to hide.

  2. Go the Action Drawer > Design this page.

  3. Select the panel from the page design view.

  4. Click the SQL cog icon to go to the Business SQL for the parent Panel Source.

  5. Click the Columns tab.

  6. Click + Column to add a column with an Expression that evaluates to 1, 0, or 3 and provide an Alias.

    • Example Expression: IIF(P.StepTypeID = Enum(StepType,'Question'),1,0),

    • Alias: QuestionVisibility

  7. Navigate in the app to the page where you want to hide the Panel.

  8. Go the Action Drawer > Design this page.

  9. Select the child Panel (the panel you want to hide).

  10. In the Panel Properties, within the Binding field group, set the Visibility Column as the column you defined in step 5. Example: QuestionVisibility.