SaasGuru Logo

Kickstart your career with the World's First Salesforce & AI Programs by an IIT - Explore Courses 🎉

Kickstart your career with the World's First Salesforce & AI Programs by an IIT - Explore Courses 🎉
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 Announces Dreamforce 2025: Dates and Key Details

Discover the latest updates on Dreamforce 2025, including dates, location, and what to expect from Salesforce’s premier event. Read now!

Salesforce Named a Leader in 2024 for Multichannel Marketing Hubs

Salesforce recognized as a Leader in 2024 Gartner Magic Quadrant for Multichannel Marketing Hubs, driving personalized, cross-channel engagement.

Salesforce October 2024 Updates by saasguru

Salesforce’s October 2024 updates bring AI innovations, partnerships, and recognitions, driving cloud solutions across industries. Read now!