The record modified field is set when defining the source object during setup in Data 360.
Required Editions
| Available in: Lightning Experience |
The record modified field acts as a reference point when the system is deciding whether to update the record in the event data is received out of order.
File 1 is received and, as it’s a new customer ID, the record is created and the customer’s favorite color is logged as Blue.
Content of File 1
| Customer_ID | Favorite_Color | Record_Modified_Date |
|---|---|---|
| 123 | Blue | 12/17/2020 00:00:00 UTC |
When File 2 comes into the system, the Record Modified Field was set in the UI as Record_Modified_Date. The system compares the timestamp of the Blue record with the timestamp of the Red record and determines that the Red record is more up to date. So the system overwrites the Blue record with the Red record.
Content of File 2
| Customer_ID | Favorite_Color | Record_Modified_Date |
|---|---|---|
| 123 | Red | 12/17/2020 02:00:00 UTC |
File 3 comes into the system. Because this record’s modified date is older than file 2, it isn’t the most current record. The favorite color attribute isn’t overwritten and remains Red.
Content of File 3
| Customer_ID | Favorite_Color | Record_Modified_Date |
|---|---|---|
| 123 | Yellow | 12/15/2020 13:00:00 UTC |