Insert record if Field Change

[IVAN88]

Hi,

I have a case : If field A on detail page Changed/Edited, I want to create trigger to insert record to other table. But if Field A NOT changed/edited, the trigger idle.

How can I know if the field A changed/edited ?

Rgds,

[CoopperBackpack]

Hello @IVAN88,

The general approach is to join the updated table and the #inserted table on a unique field. This is needed to identify the record that is updated. 

The next step is to compare the value that was in the field before the update and the new value.

For example, I want to track the changes in the 'Phone' field:

 

What data do you need to insert into the second table? Is it taken from the first table?

[IVAN88]

Thanks @CoopperBackpack it works for my case.

I'll insert data from #inserted table

Rgds,