function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Workaround to send formula values to external system


I need to pass a value to an external system (Tableau). The value I need to pass is a currency formula in opportunities. I was thinking of applying a workflow where I just have a blank currency field in the background that would get updated when the calculated currency formula field is not NULL. 

I am trying to do this with field updates but I am not quiet sure how this rule can update all pervious values as well. Is this the right approach for something like this? How can I achieve this?  

Reason for this update: salesforce connector does not support extracting calculated fields.


UC InnovationUC Innovation
Hi Arman,

Your approach should work. If you set your workflow to fire on update, you just need to go to the developer's console and run this:
List<opportunity> oppList = [SELECT id FROM opportunity];
update oppList;

This way, you will update all opportunities in your org and your workflow will update the new currency values.

Hope this helps!