search component formula field

  • 1
  • Question
  • Updated 9 months ago
  • Answered
I have a formula field "Search_Name__c" that I am trying to use with Search Component.  I can return the values of the "Search_Name__c".  But the "Search_Name___c" field is not being searched.
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 9 months ago

  • 1
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
Formula Fields are not searchable by SOSL, so they are not searchable using the Search component. One way to get around this is to have a Workflow Rule that copies the values of your Formula Field into a regular Text field any time that the fields which are involved in your Formula Field get updated. Text fields are searchable, so you can then use the text field here instead of the Formula Field, and it should work.

https://salesforce.stackexchange.com/questions/14387/search-formula-fields-using-sosl
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
Worked. Thank you