Formula Field Update

What is Salesforce Formula Fields?

Salesforce Formula Field is a read-only field that derives its value from a formula expression defined by a user. The formula field is updated when any of the source fields change. Sometimes users need to change the value based on the other source field value then we need a formula field.

Need for Formula Field Update during Replication

While running sync using DBSync On-premise Replication, the formula field driven by the value from the formula expression is also required to be stored in the database to understand the reason behind data variations in respective objects and fields.

Steps to follow

Any modifications in the formula field can be updated and saved in the database using DBSync On-premise Replication with just a couple of clicks. Command to update formula field can be run across the application in multiple ways as mentioned below

1. Add App Page
   a. Select profile using the checkbox.
   b. The 'Run All' button will now be active state, click on this button.
   c. Select the last option in the dropdown 'Update Formula Fields' for the selected profile.
   d. The user will now be navigated to the logs page to see the update.

Fig 1: Add App page with an active dropdown view to 'Update Formula Field'

2. Object Page

        a. The 'Run All' button will now be active state post objects selection, click on this button

       b. Select the last option in the dropdown 'Update Formula Fields' for the selected profile.

       c. A pop-up message asking for validation will be shown. Click on the 'Update' button to proceed.

       d. The user will now be navigated to the logs page to see the update.

Fig 2: Object page with an active dropdown view to 'Update Formula Field'

3. Logs Page

       a. Select profile using the checkbox.

b. The 'Run All' button will now be active state, click on this button.

c. Select the last option in the dropdown 'Update Formula Fields' for the selected profile.

d. The user will be able to view the progress and update the logs as the command gets executed.

Fig 3: Log page with an active dropdown view to 'Update Formula Field'