Skip to Content

Visibility views in Jitterbit App Builder

Overview

Visibility Views in App Builder are used to determine the display and mandatory or optional attributes of individual Controls on a Panel. Visibility Views are only available for Form panels. There are three different types of Visibility Views you can configure: Static, Rule, and Plugin.

A use case for Visibility Views is if you want to allow a user to change when something is hidden or enable/disabled without having to change the app itself. For example, there are columns in an OrderStatus table which state that if OrderStatus=Shipped then Order.ShipRequired is disabled. You can then create a page to manage OrderStatuses without having to change the definition of the entire app.

Static visibility view

A Static Visibility View is always active, and therefore cannot be changed unless a developer modifies it.

To configure a static visibility view

  1. Go to the application page Form panel where you want to hide a field
  2. Go to the Action Drawer > Live Designer
  3. Select the Panel for editing and go to More > Visibilities
  4. Click Create and set the Type value to Static
  5. Next select the Column you would like to hide. For example: Shipper

  6. Select the Value you want:

    1. Clear - Hides the field from display and clears the field value
    2. Require - Makes the field a mandatory visible field
    3. Show - Makes the field an optional visible field
    4. Hide - Hides the field from display, field value remains intact

    visibilityvalues.png

  7. Click Save

  8. Navigate back to the app view and confirm the update

Visibility rule

A Visibility Rule is a rule that uses business logic to apply a Visibility View to a Form panel. Visibility Rules must target a data object instead of targeting a table, and to use Visibility Rules you first configure a data object Rule.

  1. Navigate to the app from where you want to leverage the Visibility View
  2. Click the Action Drawer > App Workbench
  3. Click + Rule
  4. Provide a Name for the Rule. For example: Product Source (Unit Fields Visibility)
  5. Set the Purpose to Visibility

  6. Set the Target to the data object where you want to apply a Visibility View. For example: Product (Source)

    • A Visibility Rule must have the Target table and the Primary Keys of that table. Additionally, we will add columns that determine the Visibility View by targeting the column we want to affect and entering Clear, Require, Show, or Hide in the Expression field.

  7. Add in the Target Table for your Rule

  8. Add in the Primary Key(s) for your Rule

  9. Add in any Columns that require defining for the Visibility View by targeting the Column we want to affect, and using the visibilityoption() function to specify either Clear, Require, Show, or Hide in the Expression field.

    visibilitysyntaxexample.png

  10. Navigate back to the panel design and select Visibility

  11. Click Create and set Type to Rule
  12. Select the Rule you created
  13. Save and return to the app view to confirm the update

Plugin visibility views

App Builder supports the option to create Visibility Views using Plugins. Here the Plugin would return a 0, 1, 2, or 3 and you're configuring the rest of it similar to how you configure the Rule type:

  • 0 = Clear - Hides the field from display and clears the field value
  • 1 = Require - Makes the field a mandatory visible field
  • 2 = Show - Makes the field an optional visible field
  • 3 = Hide - Hides the field from display, field value remains intact