Working with Calculation Properties or Formula Fields

There is an important aspect to consider when using calculated fields in Insycle. While Insycle maintains data synchronization from your CRM, it encounters a specific issue with calculated fields. Since calculated fields do not store data directly—instead providing a view of data derived from other records—when Insycle searches for updated records during its regular sync process, it may not reflect changes to the values from other sources.

Continuing with the example from above, changes made to the Last Contact Date field in a contact record are not recognized by Insycle as modifications to the calculated field, "Days Since Last Contacted" in the account record. Though you will see the updated Days Since Last Contacted value when viewing the account in your CRM, Insycle won't pull the updated value.

When viewing data in Insycle, you may notice a data discrepancy where calculated fields are used. Because of this, when filtering or setting up operations in a module, it is best to avoid using these calculated fields to ensure you aren't basing processes on out-of-date data.

If it's important to see and leverage the most up-to-date calculated field data in Insycle, you may want to try the alternative solution below.

If a calculated value is key to operations you want to set up in Insycle, you can create a regular custom field in your CRM and use HubSpot Workflows or Salesforce Flows to write the value into the field. Since the content of the field will actually be modified each time the workflow is triggered, this will be picked up by Insycle's regular sync process.

For this example, we want the automation to look at the "Days Since Last Contacted" calculated field and copy the value (not the formula) to the custom field on a regular basis. This ensures the custom field in Insycle is automatically updated on a regular basis.

Copying a Formula Field to a Regular Custom Field with Salesforce Flow

In Salesforce, create a standard custom field in the same object type as your formula field.

To set up the Flow, click the Setup button at the top-right corner of your dashboard.

Under Platform Tools in the left navigation, click Process Automation > Flows.

Click the New Flow button.

For this example, we want to update the values weekly, and select the Schedule- Triggered Flow. 

Use the Update Records element to copy the calculated "Days Since Last Contacted" value to a regular custom field.

Copying a Calculation Property to a Regular Custom Property with a HubSpot Workflow

In HubSpot, create a standard custom property in the same object type as your calculation property.

To set up the workflow, under Automation > Workflows, click the Create workflow button. In this example, we'll create a workflow From scratch.

Set up a Schedule trigger to update the values weekly.

Use the Copy property value action to copy the calculated "Days Since Last Contacted (from All Contacts)" value to a regular custom field.

If you aren't sure which, if any, of your Salesforce fields are formula fields you can use the Cleanse Data module to look this up. The Type column shows "Formula" for Salesforce's formula fields.