You need to sign in to do that
Don't have an account?
Kiyana Dunlock
Storing a list/map in salesforce to reference in formula field
Hi!
I am trying to create a formula field checkbox that checks if a value in a field on the record and on the parent record(master) is a part of the list.
Ex.
Master Record Child Name Field - 'A'
Child Record Name Field - 'B'
UniqueCases List ex.
master record chld name. child recod name
'A' 'B'
Example formula
AND(masterRecordChildName != childRecodName , !Contains(UniqueCases.masterRecordChildName, MasterRecordChildNameField), !Contains(UniqueCases.childRecodName, ChildRecodNameField))
I am trying to create a formula field checkbox that checks if a value in a field on the record and on the parent record(master) is a part of the list.
Ex.
Master Record Child Name Field - 'A'
Child Record Name Field - 'B'
UniqueCases List ex.
master record chld name. child recod name
'A' 'B'
Example formula
AND(masterRecordChildName != childRecodName , !Contains(UniqueCases.masterRecordChildName, MasterRecordChildNameField), !Contains(UniqueCases.childRecodName, ChildRecodNameField))
Can you clarify where you are stuck / the current challenge? Thanks