000026651 - Calculation that compares a cross referenced field to its self for changes when the record is saved

Step one:

Create a calculated text field that adds all of the cross-referenced fields record Tracking ID fields together. (Note that you may have to create a tracking ID field in the cross referenced application)

Sample Field Name: Calc of Cross-Ref_Field

Calculation Example:  SUM(REF([Cross-Ref_Field],[Tracking ID]))

Recalculation setting: Always

Step two:

Create a calculated text field that copies the value calculated in Step one.

Sample Field Name: Copy of Calc of Cross-Ref_Field

Calculation Example: [Calc of Cross-Ref_Field]

Recalculation setting: Always

Step Three:

Create a calculated text field that compares the above Step one and two fields to see if they are the same.

Sample Field Name: Comparison of Calc of Cross-Ref_Field and Copy of Calc of Cross-Ref_Field

Calculation Example: IF([Calc of Cross-Ref_Field]=[ Copy of Calc of Cross-Ref_Field], "No Change", "Change")

Step Four: (critically important step)

Recalculation setting: Always

Change the calculation order so that the Step two calculation comes before Step One.

Calculation order:

Step Two

Step One

Step Three