-
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
Redefining the future of Marketing – Salesforce Marketing Cloud Integration with Google Analytics 360
Know your customers better and make smarter, insight-based marketing decisions through Salesforce’s massive customer relationship management platform twinned with Google Analytics 360’s market-leading digital analytics solution…
Integrating Salesforce and DevOps to Streamline Your Sales Cycle
In a growth facilitating business environment, a smooth transition between development and sales is essential. Salesforce, the industry's premier CRM platform, meets DevOps, a set…
Decorators in Salesforce
Salesforce is the best-known CRM in today’s world. It provides many functionalities that make our lives easier. Lightning web components and Apex classes are one…
Popular Salesforce Videos
myTrailhead Product Filters | Salesforce Tutorial Video
Salesforce myTrailhead has now released their next update in product filters. You can now create your own product filters that are relevant to your business…
The Power Of Displaying Salesforce Data in Google Maps
Ever wondered where on earth your Leads are? Or your customers and prospects for that matter? Well here’s the way to find out. Display your…
Nonprofit Summit 2022 - Go Further with Salesforce Reports and Dashboards Hands-on Training
Salesforce reports and dashboards are the analytical sides of CRM. They are used to convert business requirements into Visual representations like Graphs, Pie Charts, Tables,…
