Exercise: Entity & Entity triggers

Synchronize DayMonthJoinDate column with Join_Date.

Requirements

Define two triggers for the entity “UserName_Acc_customers” (click here to see entity creation steps):

• After Create Trigger: This trigger is initiated when a record is created in the entity. If the value in the entity field Join_Date is present, Actions will be initiated to update the value of the field DayMonthJoinDate in coherence with the values of day and month in the Join_Date value.

• After Update Trigger: This trigger is initiated when a record is updated in the entity. If the value in the Join_Date or DayMonthJoinDate has been modified after the update, Actions will be initiated to update the DayMonthJoinDate value to be the same as the Join_Date value.

Solution

The solution is implemented in two steps:

• Step 1: Define the “After Create” Trigger to update the value in DayMonthJoinDate according to Join_Date when a record is created.

• Step 2: Define the “After Update” Trigger to update the value in DayMonthJoinDate according to the updated value in Join_Date.