Skip to Content

Turn your connections into holiday cash with our new Customer Referral Program! Learn more

✕

This documentation is for version 4 of App Builder, the new name for Vinyl. Access the Vinyl documentation here.

✕

VisibilityOption() mvSQL database function in Jitterbit App Builder

Summary

Provides the ability to use named Visibility Values in an expression.

Note

This function is designed for use with Visibility Views.

Syntax

VisibilityOption(<VisibilityName>)

Parameters

Visibilityname

Visibility Name Value Description
Clear 0 Hides the field from display and clears the field value
Require 1 Makes the field a mandatory visible field
Show 2 Makes the field an optional visible field
Hide 3 Hides the field from display, field value remains intact

Returns

Hides or displays information based on evaluation of the expression

Example

IIF(OS.ShipCountry = 'France', VisibilityOption(Require), VisibilityOption(Hide))

Returns

1 (the value for Require), making the target field required, if the Ship Country is France, 3 otherwise (the value for Hide), hiding that field