Add, Edit and Delete validation expressions

<< Click to Display Table of Contents >>

Navigation:  Bizagi Studio > Process wizard > Define Forms > Form Controls > Controls properties > Table validations >

Add, Edit and Delete validation expressions

Add, Edit  and Delete Validation expressions are associated in the Advanced tab of the Table Properties. These expression can be associated if Addition (Add options), Edition (Edit Options) and Deletion (Delete option) are allowed for the control.  This requires the following properties to be set:

In the Add options group, Allow add is enabled (Yes) and Inline add is disabled (No).

In the Row options group, Allow edit is enabled (Yes), Inline edit is disabled (No).

In the Delete options group, Allow delete is enabled (yes).

 

Validation expressions are scripting expressions that evaluate the coherence of the information entered when creating or editing a record of a Table.

 

Validations are executed in the Work Portal when end users add or edit a record in a pop-up window, or click on the Save button.

 

For the Delete validations, when an end user tries to delete a record of a table the Validation will be executed.

 

If a validation expression is thrown the record WILL NOT BE SAVED.

 

These validations are built in the context of the Collection entity. As the new record is filled in the context of the Collection, the validations retain this context. Thus, the Xpath navigation will start from the Collection entity.

 

 

Controls Properties17

 

To include a Validation expression click on the Expression icon (Forms Components151). This will display the Expressions editor.

Delete a related validation by clicking the trash can icon (Forms Components149).

Edit a related validation by clicking on the Name of the expression or the Expression icon (Forms Components151).

 

Example

In a Purchase Request process it is necessary to validate that every new product included has coherent information.

New records are added using an Add form so we can use Validation expressions.

We will validate that the Total price of the product included is the Unit price times the Quantity requested. If not an error message should be displayed.

 

1. On the from, go to the Table's Advanced properties.

Enable the Add option and disable Inline Add. This way the Add form and the Validation expression will be shown.

 

2. Relate and Add Form.

 

3. Create a new Validation expression by clicking on the Expression icon (Forms Components151).

The Expression editor will display.

 

Controls Properties18

 

4. Include the following code:

 

//Validates if the Total price entered is the same as the Unit price times the Quantity entered.

if(<Totalprice>!= (<Unitprice>*<Quantity>))

{

 CHelper.ThrowValidationError("Total price must be Unit price times quantity")

}

 

5. In the Work Portal, a new record is added. This will display a new window where the new record information must be entered.

 

Controls Properties19

 

6. When the information is entered, and the end user clicks on Save, the Validation expression will be executed.

In the image below the error message will display.

 

Controls Properties20