Skip to main content

#FlowBuilder1 discussing

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

0/9000

🚀 Sort and Edit in Flow Data Table component | Save Changes within Flow 🚀

 

 

In this quick tutorial, I'll show you exactly how to use the new features of the data table component from Salesforce's Spring 26 release. Learn how to implement inline editing and column sorting directly within your screenflow, making your workflow automation more efficient. This update offers significant enhancements for any Salesforce developer working with Flow Builder. 

 

Also, I have shown how to save the inline edit changes properly in Salesforce.

 

📺 Watch the full video here: https://youtu.be/n_YgSPdj1no

 

 

#Salesforce Developer #Salesforce Admin #Flow #Flownatics #FlowBuilder #New Releases

 

@The Blog Group @* Release Readiness Trailblazers *

   

🚀 Sort and Edit in Flow Data Table component | Save Changes within Flow 🚀 In this quick tutorial, I'll show you exactly how to use the new features of the data table component from Salesforce's Spri

 

 

0/9000

Do you spend your day in Flow Builder? 

I am a Flow Builder designer and seeking to understand more about your backlog and needs for governance tools. Want to weigh in?! Here is a link to a 10 minute survey!  

 

@Salesforce Flow Automation #FlowBuilder  #Flow  #Automation

0/9000

Hello, 

I have created a flow that sends an email to a user when a record is completed.  I would like to include the related order record link in the email. 

 

I am using the rich text editor, and have added a link, but it is environment specific.  is there a better way to do this? 

here's an example of what I am using now 

 

"

https://mycompany--uat.sandbox.lightning.force.com/{!$Record.Order__r.Id}

 

 

#FlowBuilder

1 answer
  1. Nov 4, 2025, 10:01 PM

    I get a 'this site can't be reached' message.  Not sure if I mentioned this, but the user would be clicking the link from the email they receive.

0/9000

I want to create a flow that will parse out the case subject line to populate a custom lookup field on a case. Our subject line contains a Quote number that starts with a SQ or SMQ followed by 6 numbers. I want to pull in the quote number to the custom lookup field from the subject line. I am new to flow so any help is appreciated. 

 

Examples of subject line: 

  1. SQ459927 - A3im FW: A3im New Purchase Order
  2. FW: [External] PO P35072 for SQ459920
  3. Process SMQ666666

 

#Salesforce Flow #Email-to-case #FlowBuilder #Salesforce Developer

6 answers
0/9000

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 

0/9000

Hello Everyone,

 

I created a record trigger flow that when an agent link a contact to messaging session via Messaging Related Contact it should also link the contact into the case object, this flow is working when agent do the linking when messaging session is active but when status is ended it is not working, my question is why its not working?

 

Also below is my flow configuration:

 

Start record trigger flow:

  • Select Object : Messaging Session
  • Configure Trigger: A record is updated
  • Set Entry Condition: None
  • Optimize flow for: Action and Related Records

Decision:

  • Outcome Order:
    • Contact Not Found:
      • Condition Requirements to Execute Outcome: Condition Requirements to Execute Outcome: All Conditions Are Meet (AND)
      • Resource: {!$Record.MessagingEndUser.ContactId} Is Null True
      • When to Execute Outcome: If the condition requirements are met
  • Default Outcome: Contact Found

Update Records:

  • How to Find Records to Update and Set Their Values: Specify conditions to identify records, and set fields individually
  • Object : Case
  • Condition Requirements to Execute Outcome: Condition Requirements to Execute Outcome: All Conditions Are Meet (AND)
  • Id Equals {!$Record.CaseId}
  • Set Field Values for the Case Records:
    • ContactId <-  {!$Record.MessagingEndUser.ContactId}

#FlowBuilder #Record-Triggered #Messaging Session #Case

2 answers
  1. Nov 7, 2023, 10:06 AM

    Hi @Ariel Gencianeo, if you attempt to debug the flow adding a Messaging End User to a Messaging Session record with Status "Ended" , what flow elements are executed?

0/9000

I have a requirement to notify all account team members when a new opportunity is created and I am not sure the best way to do this using flow builder. If I create a record trigger flow when a new Opportunity is created, and then use the get Account Team Member where the AccountId = Record>AccountId. Can I then just use an email action or is there a better way to do this?  Thank you

 

#FlowBuilder #Flow #Email Alerts #Account Teams

1 answer
  1. Nov 9, 2023, 11:32 PM

    Get all Account Team Member's emails and add them to a collection and you can use the send email action. The variable for the email is text and add them to a text collection. You need a loop and two assignments.

     

    Hope this helps. 

0/9000

Hi

 

I have created a schedular flow which will execute everyday, I have added the condition that when last stage change date is older than 14 send a email

 

Please find following results of the flow, 

 

Outcome conditions

{!VarStatusAge} (14) Equals 14

All conditions must be true (AND)

Skipped this outcome because its conditions weren't met:

 

Where {!VarStatusAge} is TODAY() - {!$Record.App_Stage_Change_Date__c} which return the data type number with decimal 0

but when i change condition to equal 13 it is working

 

Outcome conditions

{!VarStatusAge} (14) Equals 13

All conditions must be true (AND)

 

Can you please someone explain how this logic works.

 

Thank you

 

#FlowBuilder #Scheduled Flow #Flows

2 answers
  1. Nov 9, 2023, 6:55 AM

    Hi Ravendr Shukla

     

    Thank you very much for your response, 

     

    my 

    App_Stage_Change_Date__c

    field is date type field, 

0/9000

Hello Everyone,

 

Is it possible to trigger the lookup field of an object in a record trigger flow?

 

#FlowBuilder #Record-Triggered

5 answers
0/9000