SaasGuru Logo

Flat 20% OFF on Salesforce Marketing Cloud and Data Cloud + AI Bootcamp 🎉– Offer Ends 30th Nov!

Flat 20% OFF on Salesforce Marketing Cloud and Data Cloud + AI Bootcamp 🎉– Offer Ends 30th Nov!
How To Create Formulas in Salesforce Flow? - A Step-by-Step Guide

How To Create Formulas in Salesforce Flow? – A Step-by-Step Guide

Formulas in Salesforce Flow are like silent algorithms working behind the scenes, ensuring that the platform’s automation capabilities are both dynamic and intelligent. They infuse logic into automated processes, allowing businesses to tailor flows that match their unique requirements and conditions. Whether calculating discounts, transforming data, or deciding which email template to send a customer, formulas are pivotal in making these automations precise and effective.

In this blog, you will learn.

  • Step-by-step guide on how to create formulas in Salesforce Flow.

Let’s walk through a straightforward example to clarify the process of adding a text formula and utilizing the “Add” operator within a workflow. In this specific case, we’re focusing on a workflow designed to update account descriptions.

Step 1: Create a Formula

Begin by clicking “Toggle Toolbox” to reveal the Toolbox. Then, click “New Resource.” Choose “Formula” as the “Resource Type” and name it “frmChangeDateNote” under “API Name.” 

Even though we are dealing with a date, opt for “Text” as the “Data Type” to ensure the result is in text format. 

In the “Formula” field, enter: `”Shipping Address added on ” & TEXT({!$Flow.CurrentDate})`. 

Insert “$Flow > Current Date” within the parentheses. Confirm the formula by clicking “Check Syntax” and finish by clicking “Done.”

DImHtC kEkshPuGi36jy7J0pqaklAbH7pfoUgYde6ea9IJfSiaUmFZ08lAT0OR6M9hfAFOWeM4qUgrq 0mICkkfU kbjfjdydLz2Jgn416GOtY73Dsbcl2VCn3LsfNFTfKdMMr3Av0AH3To1pto94

Step 2: Update the Account Description

Next, click on the “Copy Billing Address” element and select “Edit Element.” 

Add an assignment by clicking “+ Add Assignment.” In the “Variable” field, select “Account” from “Get_Account_Data,” and then select “Description” (the variable to update). 

Choose “Add” as the operator and select “frmChangeDateNote” (the formula with the text value) in the “Value” field. Complete this step by clicking “Done.”

ivMf0kAbmHUyeUOoEc2eZXuvxFG0ns851u BBrTKUL3nMCY08HZ8ADQZ wrZZosRz2qCohtgJsSWNIl8JoUkOBLlgElTQqD2EEn0FDYTaCa

Also Read – Salesforce Flow Formulas: How To Use It in Conditions & Actions

Step 3: Save the Flow

Save the workflow. As a result, when the “Update Records” element updates the account, the Description field will now incorporate the modified text, such as “Shipping Address added on 03-02-2023.”

oMzkSWxJBw5YJljM6RLJTwbhMNDKsbsARm0gX0Goiuuc7b jun8Xq6k3KAwTE9YbuKCPiLqYCzMhw8UlvAJ5BJhyyGD5PHsn9xgCH2elPsT6KZaPgRMrYggnBRoU6abyOaKHWbqKvhflXm5a QF6y7o

Note: If you are simply combining two texts without conversion, you can manually add a space before the new text in the “Value” field, as mentioned in the note at the end. This example illustrates how to incorporate a text formula to alter a field’s value and how to apply the “Add” operator to update the field with the new value.

Online Bootcamps India

Conclusion

Formulas in Salesforce Flow empower businesses by injecting tailored logic into automation processes, ensuring that every action is as precise as it is impactful. As illustrated, crafting formulas, even ones that involve text manipulation, can be straightforward when broken down into systematic steps. Harnessing the full potential of these formulas can lead to advanced, efficient, and intelligent workflow automations tailored to suit the diverse needs of every organization.

Interested in diving deeper into the world of Salesforce? Join our community on Slack, where you’ll connect with experts, enthusiasts, and peers. 

Additionally, consider enrolling in our online Salesforce bootcamps. With hands-on training, real-world projects, and guidance from industry professionals, it’s a golden opportunity to advance your Salesforce skills and capabilities.

Table of Contents

Subscribe & Get Closer to Your Salesforce Dream Career!

Get tips from accomplished Salesforce professionals delivered directly to your inbox.

Looking for Career Upgrade?

Book a free counselling session with our Course Advisor.

By providing your contact details, you agree to our Terms of use & Privacy Policy

Unlock Your AI -Powered Assistant

Gain Exclusive Access to Your Salesforce Copilot

Related Articles

Salesforce Data Loader Errors: How to Identify and Fix Them

Learn how to identify, troubleshoot, and prevent common Salesforce Data Loader errors with actionable tips and best practices. Read now!

Humans of Salesforce – Mauricio Alexandre Silva

Discover Mauricio Alexandre Silva’s inspiring Salesforce journey, tips for success, and insights into the evolving ecosystem. Read now!

Salesforce India Achieves $1 Billion Revenue Milestone

Salesforce India achieves $1 billion revenue milestone, driven by AI, innovation, and digital transformation across industries. Read now!