Advanced Validation Techniques

Advanced Validation Techniques in Designer Applications Setup a Dynamic Input Range Based on Category Selection: Create a dropdown menu to select a category (e.g., Category A, B, or C). Use a lookup formula to dynamically fill two cells with the minimum and maximum...

Number Formatting

You can set a number or date formatting for tooltip contents using “{keyword:#,##0.00}”. Data field names can be used in tooltips, charts, maps, and other similar controls that share the same structure using “[FieldName:#,##0.00]”. A list of...

Trigger Calculations

If Trigger Calculations is selected, changing the value in this input control will trigger a calculation. Calculations perform a server call with all of the inputs from the user interface and populate the output controls with the values from the updated calculation....

Tooltips and Popover

Tooltip Type Tooltips are informative message boxes that are displayed when you mouse-over or click on a control. The Tooltip Type property determines the message style, and when the information will be shown. Tooltip: The content will appear in a small bubble when...

Masks

The Mask property defines the format of the input’s entered values. The following formats are supported: None: A standard textbox input allowing for free-form string values. Decimal: A numeric textbox input allowing for decimal values. Integer: A numeric textbox input...

Making a Field Required By Another Field

You can make a UI control required by the value of a Boolean field. A required control can prevent page transitioning and/or save actions until the user enters data into this field. The Required field indicates whether the control is required during validation. This...

Hide/Unhide Controls

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...

Required Controls and Validation

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...