Activity Forums Salesforce® Discussions What are Salesforce formula fields?

  • What are Salesforce formula fields?

    Posted by D on May 3, 2019 at 9:46 am

    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)))

    lavish replied 4 years, 10 months ago 2 Members · 1 Reply
  • 1 Reply
  • lavish

    Member
    May 17, 2019 at 9:48 am

    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

Popular Salesforce Videos

Salesforce Admin Certification 2020 Questions Explained with References - Part II

Video in

How to prepare and pass Salesforce Admin Certification with Practice Exam Questions 2020 practice questions and answers for the Salesforce Administration Salesforce Certified Admin Exam Questions Salesforce Administrator Certification Exam…