Streaming Newsflashes based on Formula Fields (Hoopla)

Learn how to get around the fact that Formula fields won't work with Streaming Newsflashes

Streaming Newsflashes use Salesforce's "Streaming API" to track changes on individual records based on customized criteria. Unfortunately, Salesforce does not support formula fields in the queries involved with each "Push Topic".

If you are trying to use a formula field in your Streaming Newsflash criteria, you will get an error because it is not supported. However, you can work around this by creating a new field on your object, which is updated by a Salesforce workflow. Here's how!

Create a Field Updated by a Workflow

  1. In Salesforce Setup, navigate to App Setup > Customize and select the object upon which your Streaming Newsflash is based. 

  2. Click Fields to see a list of fields on your object.

  3. Click New to create a new field.

  4. Specify the field type.  For example, select Currency if the number you're seeking to use in your criteria is a currency.

  5. Give the field a label, and save.

Create a Workflow Rule

  1. Navigate to Create > Workflow & Approvals > Workflow Rules.

  2. Click New Rule.

  3. Select the object upon which your Streaming Newsflash is based.

  4. Give the rule a name.

  5. Specify the rule criteria. Example: if you want to update a certain value when a deal is won, add "Won equals True".

  6. Save your new rule.

Add a Workflow Action

After creating your workflow rule, you can add your workflow action.

  1. Click Add Workflow Action and New Field Update.

  2. Give it a name, and select the field to update.

  3. For options, select "Use a formula to set the new value".

  4. Enter the formula that gives you the value you need. This may be copied from the formula field you originally wanted to use in your Newsflash criteria.

  5. Save your changes.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request