The Field events option allows performing an action when the cursor enters or leaves an edit field, or when the mouse is over a field. Perform any validation, make other fields hidden or required, etc. This option is designed to work on Add, Edit, and Register pages.
For example, the editing event occurs when an element changes its value. Text fields launch this event when the user enters the text.
Once a field event was added, you can find it on the Events screen.
This example shows how to use the Field events to make it easier to enter categories/subcategories into the table.
The user needs to enter only the numeric value (ID) into the text box to get other values automatically.
Let's take a detailed look.
We have two tables: categories and sub_categories. CategoryID is a two-digit category code.
In the sub_categories table, SubID consists of a two-digit category code and a two-digit subcategory code.
We need to simplify adding a large number of subcategories.
When the user types in the first two digits (category), the category name appears below the text box. The next subcategory number is calculated automatically.
First, we need to create a Field Event for the SubID field. We are going to use the editing event here, which is called every time the content of the field is changed.
In the Client Before code, we check the length of the entered code and send it to the server side only when the code is two digits long.
On the Server side, we pull the CategoryName from the categories table and calculate the next subcategory ID.
We pass both the category name and new subcategory code back to the Client After event.
In this event, we replace the previous category name with a new one. We also make the text blue. Then we set the value of the SubID with a new subcategory code we received from the Server event.
This example shows how to calculate a field value that depends on other field values on the fly.
For instance, in the Cars template, we need to get the Tax value that depends on the Price and Horsepower.
You need to create editing Field events for the Horsepower and the Price fields each. Insert the following code into the events.
The code for the Horsepower field:
The code for the Price field:
Now, each time the Horsepower and Price values are changed, the Tax value is computed automatically without reloading the page.