Validation Control

A validation control ensures that data entered a system meets specific criteria or rules, such as format, range, or completeness. It helps maintain data accuracy and integrity by flagging errors or inconsistencies before the data is processed or stored.

Working with a validation control:

• Create a form, as shown in Figure 1, by dragging validation controls.

Figure 1: Designer

• After adding a validation control to the designer, it’s possible to change its control name, add remarks, and set Validate on save, Validate on Select & Validate on SP in the property panel (see Figure 2).

Figure 2: Properties tab

Validate on Save

Description

This option specifies whether validation should occur when the data is being saved or submitted. When set to “Validate on Save,” validation occurs at the point when the user attempts to save or submit the data.

How to Use:

1.Design Phase:

• Begin by adding all necessary controls to your form designer by dragging and dropping them.
• Access the properties tab of each control and navigate to the Validation section.
• Enable the “Is required” option and provide a required message. This message will be displayed next to the control if the user attempts to save the form without entering a value.

Figure3: Designer

Figure4: Properties Tab-Validation

1. Data Source Configuration

• Set up your form’s data source and configure the Insert operation to include all controls added via drag and drop.

• Begin by dragging and dropping all necessary controls onto your designer.
• Next, set up your form’s data source and configure the Insert operation, ensuring it encompasses all the controls you have added through drag and drop.
• In the validation control’s property tab, activate the “Validate on Save” property to trigger data validation during save operations.
• During preview or testing, attempt an insertion without data to observe the validation process in action, catching and addressing any validation errors that occur before finalizing the insertion.

Figure3: Validate on save

Figure 4: designer

Figure 5: Preview

Validate on Select

Description: This option specifies whether validation should occur when the user selects an option or performs an action.

Validate on SP (Stored Procedure)

Description: This option specifies whether validation should occur when a stored procedure is executed or when a specific server-side action is triggered.

Validation Control Properties 

Here’s the basic list of properties which can be used from rules. 

Style.Width – Specifies the recommended width for the control.

Style.Height – Specifies the recommended height for the control.

Style.TextAlignmet – Indicates whether the text is aligned to the left, right, or center.

Style.Margin – Specifies the outer margin of the control.

Style.BoxShadow – Box Shadow values (horizontal offset, vertical offset, blur radius, color).

Style.TextFont – Specifies the font family for the control.

Style.FontSize – Specifies the font size.

Style.FontColor – Specifies the font color for the control.

Style.BackGroundColor – Specifies the background color for the control.

Style.Visibility – Display or hide the control.

Control Name:  Validation Control

Group:   Validation

Table1: properties