Skip to main content
Temas#Flow Formula

#Flow Formula0 debatiendo

Formular una pregunta...
Yair Tsoran (Business Applications Director en AlgoSec)
18 may, 7:24

Solution to Compare Salesforce IDs

 

Purpose

 

This formula converts the Salesforce ID into a numeric value, allowing you to compare IDs directly using greater-than (>) or less-than (<) operators. 

 

  1. Define IdChars: IdChars = '01234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'    

    This string represents the character set used in Salesforce IDs.

  2. Convert ID to Numeric Value:    

    Use the

    FIND function to locate the position of each character in the IdChars string and calculate a numeric value for the ID.    

    Example formula:

(FIND(MID(AccountId, 4, 1), IdChars) - 1) * 100000000000000 +(FIND(MID(AccountId, 5, 1), IdChars) - 1) * 1000000000000 +(FIND(MID(AccountId, 10, 1), IdChars) - 1) * 10000000000 +(FIND(MID(AccountId, 11, 1), IdChars) - 1) * 100000000 +(FIND(MID(AccountId, 12, 1), IdChars) - 1) * 1000000 +(FIND(MID(AccountId, 13, 1), IdChars) - 1) * 10000 +(FIND(MID(AccountId, 14, 1), IdChars) - 1) * 100 +(FIND(MID(AccountId, 15, 1), IdChars) - 1)

 

Now you can compare ID Numeric Value 1 with ID Numeric Value 2 using greater-than (>) or less-than (<) operators. 

 

#Flow Formula  #FlowBuilder

 

 

#Flow

Escribir un comentario...
0/9000
Fahad Karim (Salesforce Developer en Adforce) ha publicado en #Flow
13 sept 2024, 10:39

I m doing Data And Action flow challenge 3

When I start Action Post To chatter in messsage I click chatter message but in Target Name or Id I can't seeRecord in global variables.

#Flow #Screen Flow #Scheduled Flow #LeadBeforeSave Flow #Flow Error #Flow Formula #Flownática #Flow User #Schedule Triggered Flow
ei_1726223958104.jpg
ei_1726223958127.jpg
Escribir un comentario...
0/9000
Sudipta Deb (Enterprise Architect en Silverline) ha publicado en #Formulas
12 jul 2024, 16:09

📣📡 Advanced Salesforce Formulas – Example

Salesforce Formulas are a powerful tool within the Salesforce platform, designed to enhance the functionality and interactivity of your Salesforce  applications. These formulas allow users to perform calculations, manipulate text, and automate processes, thereby transforming data into actionable insights. They are akin to the formulas used in spreadsheet  applications but tailored for Salesforce’s robust CRM environment. By utilizing Salesforce Formulas, administrators and developers can create dynamic fields, validation rules, and workflows that respond intelligently to user input and data changes. This capability not only streamlines operations but also ensures data integrity and enhances the user experience. Whether you are calculating sales commissions, formatting dates, or validating data entries, Salesforce Formulas offer a versatile and indispensable resource for maximizing the efficiency and effectiveness of your Salesforce instance.

Now today, I am going to share some of the advanced formulas which you might need to write during your implementation. I will always keep on updating this blog post as I encounter any such advanced formulas.

đź“’ https://sudipta-deb.in/2024/07/advanced-salesforce-formulas-example.html

 

📣📡 Advanced Salesforce Formulas – ExampleSalesforce Formulas are a powerful tool within the Salesforce platform, designed to enhance the functionality and interactivity of your Salesforce applicatio

@The Blog Group

 

#Formulas  #Formula Help  #Flow Formula

Escribir un comentario...
0/9000
Sudipta Deb (Enterprise Architect en Silverline) ha publicado en #Formulas
8 jul 2024, 0:16

📣📡 Commonly Used Salesforce Formulas – Good To Know

Salesforce Formulas are a powerful tool within the Salesforce platform, designed to enhance the functionality and interactivity of your Salesforce  applications. These formulas allow users to perform calculations, manipulate text, and automate processes, thereby transforming data into actionable insights. They are akin to the formulas used in spreadsheet  applications but tailored for Salesforce’s robust CRM environment. By utilizing Salesforce Formulas, administrators and developers can create dynamic fields, validation rules, and workflows that respond intelligently to user input and data changes. This capability not only streamlines operations but also ensures data integrity and enhances the user experience. Whether you are calculating sales commissions, formatting dates, or validating data entries, Salesforce Formulas offer a versatile and indispensable resource for maximizing the efficiency and effectiveness of your Salesforce instance.

In this blog post, I will share some of the most commonly used formulas. I will try to keep this blog post up to date by posting new formulas as I experience it in future.

đź“’ https://sudipta-deb.in/2024/07/commonly-used-salesforce-formulas-good-to-know.html

 

@The Blog Group📣📡 Commonly Used Salesforce Formulas – Good To KnowSalesforce Formulas are a powerful tool within the Salesforce platform, designed to enhance the functionality and interactivity of your Salesforce

 

#Formulas #Formula Help #Flow Formula

Escribir un comentario...
0/9000
Jason Adams (Founder en Advocate Cloud Solutions) ha preguntado en #Formulas
21 abr 2024, 17:57
Need help with a formula

I am attempting to setup a screen flow to run as a cadence Step.  I want to give the user a few options for Next steps and one of those steps is to pause the cadence until a specified time.  I gave them a screen flow with a date & Time Module  and when adding that value to "Scheduled Resume Time"  I get this error, You’ve received this email because an error occurred while your "Collections Cadence Step Flow" flow was running.

 Error element Schedule_Cadence_Restart_Time (FlowActionCall).

 Specify a resume time value at least 1 hour in the future in the ISO 8601 format [2021-06-25T05:38:15.521917Z]. 

 

I have tried a few formulas to reformat but having no luck.  this is my most recent.

 

TEXT({!Your_DateTime_Field} - 5/24) & '.' & RIGHT('00' & TEXT(MILLISECOND({!Your_DateTime_Field})), 3) & 'Z' 

 

Any Guidance Is appreciated!!

 

#Formulas  #[Flo

1 respuesta
  1. Srinivasa Reddy (AiCloudTimes)
    12 may 2024, 4:42

    it should be as simple as if you are looking to add 1 hour time.

    Please mark as best answer if it helps :) 

    TEXT({!Your_DateTime_Field} + 1/24) & 'Z'
Escribir una respuesta...
0/9000
Anand S (Technical Manager en Preludesys) ha publicado en #Trailhead Challenges
24 mar 2024, 6:05

Trailblazer Meetup '24 - 100 Days Challenge, participants will engage in activities focused on Salesforce fundamentals, Apex programming, and Lightning Web Component Training. This includes participating in running challenges and social interactions.

 

Tech Day-11 - Salesforce Lightning Flow  - 6th Apr 2024 (Sat)

https://trailblazercommunitygroups.com/events/details/salesforce-salesforce-user-group-chennai-india-presents-trailblazer-ninjas24-tech-day-11-lighting-flow-part-1/

 

Tech Day-12 - Salesforce Lightning Flow - 7th Apr 2024 (Sun)

https://trailblazercommunitygroups.com/events/details/salesforce-salesforce-user-group-chennai-india-presents-trailblazer-ninjas24-tech-day-12-lighting-flow-part-2/

Trailblazer Meetup '24 - 100 Days Challenge, participants will engage in activities focused on Salesforce fundamentals, Apex programming, and Lightning Web Component Training.

 

Join our 100 Days Challenges - It's 100% Free.

100 Hours of Salesforce Training : https://bit.ly/100HourOfTraining

100 Days of Self-Learning Challenge : https://bit.ly/100DaysOfSelfLearning

100 Days of Running Challenge : https://bit.ly/100DaysOfRunning

 

For Event Updates:

Telegram  : https://bit.ly/TelegramSFUG

YouTube   : https://bit.ly/YouTubeSFUG

LinkedIn    : https://bit.ly/LinkedInSFUG

Whatsapp : https://bit.ly/WhatappSFUG

Twitter       : https://bit.ly/TwitterSFUG

Instagram  : https://bit.ly/InstagramSFUG

 

Note: Share this with your friends, colleagues, and final-year students who are interested in learning Salesforce as a career path. Let's contribute to our community by spreading the word!

 

#Trailhead Challenges

 

#Flows #Screen Flow #Flow Formula #Schedule Triggered Flow #FlowBuilder #Flow Error #FlowCallout #Flow User 

Escribir un comentario...
0/9000
Chrystele Benjamin
13 mar 2024, 16:36
Syntax Error in Flow Formula

Hello,

I have the following formula in record triggered Flow "Formula evaluates to True". I tried:

OR({!$Record.Opportunity.RecordType.Name}="XYZ",

{!$Record.Product2Id}=01t8Y00000P8C0G )

That one gives me this error: Error: Syntax error. Missing ')' . But it's not missing a ).

 

So I then tried:

OR({!$Record.Opportunity.RecordType.Name}="XYZ",

{!$Record.Product2Id}="01t8Y00000P8C0G" )

but it- then gives me this error: Error: Field Product2Id does not exist. Check spelling.

I get the {!$Record.Product2Id} from the Insert a Resource, so I can't figure out why it gives me either errors.

 

Let me know if you see what I'm doing wrong please?

Thanks,

CB

 

#Flow Formula

5 respuestas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    13 mar 2024, 17:39

    Try this  (you also need the full 18 digit ID, not 15)

    OR(
    {!$Record.Opportunity.RecordType.Name} = 'Sales',
    {!$Record.PricebookEntry.Product2.Id} = '01t50000000v0BpAAI'
    )
Escribir una respuesta...
0/9000