-
What are Salesforce formula fields?
i have text string divides with slashes ,
string contains in one text field by using formula field i need to show from last two slashes text ..
EX :Default Category/Home Video,Default Category/Home Video/Blu-ray/DVD,Default Category/Home Video/Limited Editions
Here :o/p Home video/Limited Editions
Here text varies from record to record ...
i written like :LEFT(RIGHT(Category__c,LEN(Category__c) - FIND("/", Category__c)),
FIND("/",RIGHT(Category__c,LEN(Category__c) - FIND("/", Category__c)-1))) -
1 Reply
-
I think we can't achieve it with requirement field formula. It's an interesting question. It would be great to learn about it more.
Log In to reply.
Popular Salesforce Blogs
The Ultimate Guide To Salesforce Data Recovery And Backup
Of course Salesforce manages with the available services and provides different backup and recovery features in case you face data losses or need to return…
Guide to CPQ Tools in Salesforce: Find the Perfect Fit for Your Business
Ever spent hours crafting a quote in Salesforce, only to realize you forgot a discount or made a pricing error? You're not alone. Manually building…
Salesforce Products That Changes the Future of Business
For a business to be successful, it is important to use Customer relationship Management (CRM) to increase your customer base, sales and revenue. The one…
Popular Salesforce Videos
Skills for Salesforce Field Service | Optimize Customer Service for Businesses | Salesforce Webinar
One way to optimize customer service operations is by having the right technician for the right job. How? Skills for Salesforce Field Service is the…
How To Set Up Gmail With Salesforce | Salesforce Development Tutorial
Learn how to set up Gmail with Salesforce. The following points will be covered in this tutorial - 1. Lightning for Gmail Get a brief…
Relationships in Salesforce | Why Relationships are Created?
In this video, Salesforce Rangers goes into detail about what relationships are in Salesforce and why they are necessary in the first place. This is…
