When done right, Excel functions are like magic. 🪄
They can be used for all sorts of things, from simple totaling of items on an order, to composing and appending strings of text to write a customized sentence, to using advanced logic to determine the correct decision based on available data. They're so useful in fact, we've now added them to workflows! You can use them to update fields and in Criteria Logic to select specific branches in Decision Tree steptypes. Follow this guide to get your functions up and running.
First, a point of clarification. Strictly speaking, these aren't true Excel functions. They're Excel-like functions using Formula.js, the tool we use to evaluate and run functions in BrightReps.
Note: While the vast majority of Excel functions are supported here, not all of them are. Your mileage may vary. This is why testing your function here is the best first step. Once you have it running in Formula.js, it's time to bring it over to BrightReps.
Note: Your function should only be entered in ALL CAPS.
As an Admin user, use the Tester feature in Sidekick ( click the ꠵ burger button, then Tester) to run your function in real time to see the result.
Once you've confirmed that the function you've built will run on BrightReps, you can use the ➕ button to the right of the field to pull in BrightReps variables for use in your function to replace any 'cells' or dummy data you had in place from Formula.js.
Using a Salesforce, Zendesk, and Workboard Update Field steptype, navigate to the field you wish to update with the output of your function. For the field value, type function.excel() - this is what tells the steptype that you want to use a function. If you skip this part, the steptype will only write your function into the field rather than running the function and writing the output.
Then paste the function that you evaluated earlier in Tester in between the parenthesis so that your function is properly wrapped up.
For example, function.excel(YOUR FUNCTION HERE)
Again, if you want to use other fields as 'cells' or variables in your function, you can do that too. Just use the ➕ button to the right of the value field to pull in any available fields from your CRM or Workboard.
Note: For the moment, this will only work if the entire field is used for your function. You won't be able to nest your function within a line of text to update a field. If you want to append text to the beginning or end of the field value, it's best to do that in the function itself.
Using functions with Decision Tree steptypes can be incredibly powerful and help your agents speed through flows if the information needed to make a decision is already in your CRM or Workboard fields.
Your function is now ready to use. Have fun Excel-erating your flows!