You can hide or show UI controls based on the outcome of a Boolean named range in your workbook. This way, you can create a dynamic UI, which will help de-clutter the controls and give your users a better experience. The Visible property indicates whether a control is going to be visible.

This can be configured as Always or Never to indicate whether the input is statically visible or not.

Alternatively, if any Boolean Single Named Ranges (SNR) exists (i.e. ranges pointing to a single cell that evaluates to TRUE or FALSE), then the visibility of the input can be configured to reflect the value of that named range using the ‘By Value Of’ setting.

The Validation Trigger selection will indicate the events that will cause the validation rules to be processed against the control. Validation constitutes any of the other validation options, such as Required and Minimum/Maximum Length. If validation fails (e.g. input is required but no entry exists), then the request calculation will be skipped.

You can select multiple events to trigger validation. The following triggers are available:

  • After Change – As soon as the value in the control is changed.
  • Before Calculate – Before any calculation event is triggered. This could include navigation or button clicks, as well as any other control triggering calculations. It has the ability to cancel the calculation action when failed.
  • Before Navigate – Before any navigation event is triggered. This could include navigation via user clicking a page in the navigation bar or a button-trigger navigation action. It has the ability to cancel the subsequent action when failed.
  • Before Save – Only before a save action is triggered. It has the ability to cancel the subsequent action when failed.