To update a field through Trigger, you must first create a Trigger that runs within the database.
In this example, a Trigger will be developed so that before updating (BEFORE UPDATE) it updates a certain field in real time.
So, the steps to follow are:
1. A Trigger is created as follows:
2. When creating the Trigger, within the ScriptCase you must create a form from the table that contains that process
3. Finally, within the onChange event of the field that you want to be added, an UPDATE must be performed for each time the value of that field is changed