# Formula Field Update

#### What is Salesforce Formula Fields? <a href="#formulafieldupdate-whatissalesforceformulafields" id="formulafieldupdate-whatissalesforceformulafields"></a>

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 <a href="#formulafieldupdate-needforformulafieldupdateduringreplication" id="formulafieldupdate-needforformulafieldupdateduringreplication"></a>

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 <a href="#formulafieldupdate-stepstofollow" id="formulafieldupdate-stepstofollow"></a>

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.

\
![](https://help.mydbsync.com/docs/download/attachments/53903561/worddav806a528ab062d328f44e61ebc6d728e5.png?version=1\&modificationDate=1622219311000\&api=v2)\
Fig 1: Add App page with an active dropdown view to 'Update Formula Field'

\
2\. **Object Page**

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

&#x20;      b. Select the last option in the dropdown 'Update Formula Fields' for the selected profile.

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

&#x20;      d. The user will now be navigated to the logs page to see the update.

\
![](https://help.mydbsync.com/docs/download/attachments/53903561/worddav07777433552eaeeab0e981574ab76e2e.png?version=1\&modificationDate=1622219311000\&api=v2)\
Fig 2: Object page with an active dropdown view to 'Update Formula Field'\
\
3\. **Logs Page**

&#x20;      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.

\
![](https://help.mydbsync.com/docs/download/attachments/53903561/worddav17fcf4468c9b782dc6f6c9203d349ecb.png?version=1\&modificationDate=1622219311000\&api=v2)\
Fig 3: Log page with an active dropdown view to 'Update Formula Field'

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-replication-main/objects/formula-field-update.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.