Loading
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Record Modified Field

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Record Modified Field

            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.

            Example
            Example Three files exist, each containing customer record 123. File 3 comes first, then File 1, then File 2. The files are ingested in a different order: File 1, File 2, File 3.

            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_IDFavorite_ColorRecord_Modified_Date
            123Blue12/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_IDFavorite_ColorRecord_Modified_Date
            123Red12/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_IDFavorite_ColorRecord_Modified_Date
            123Yellow12/15/2020 13:00:00 UTC
             
            Loading
            Salesforce Help | Article