function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Mac SwiftMac Swift 

Update OPP Product field through cross object formula

Hi Guys please help me!

I have a custom picklist field in PRODUCT OBJECT. Which I want to show in my OPPORTUNITY PRODUCT OBJECT.

I tried cross object formula - TEXT(field.name) but its not working nor the workflow rule.

I dont want to use any code or trigger plz help me through formula. Please help me guys i really need help!!
Keyur  ModiKeyur Modi
Hi Mac, 

as per my unserstanding you have one piclist field (product family) which you want to show on Opportunity Product(opportunity line Item ) if yes then you can do that through formula field. you need to write formula field like mentioned below
 
TEXT(PricebookEntry.Product2.Family)   // here I am getting family picklist value on opporutnity Product

here you have to write formula on opportunity product object and you need to pass your custom picklist value in place of family picklist value. 

TEXT(PricebookEntry.Product2.customPicklist__c)

Please check and let me know.

Thanks,
Keyur Modi
Lucas Duque 9Lucas Duque 9
Hello Mac, 
Try to do this ...

1º In your "OPPORTUNITY PRODUCT OBJECT", create a field of formula of type Text with name you want. So write the follow in formula editor:

User-added image
Obs: But replace the fields in function for their. I think that in your case would look like this:
HYPERLINK(Product__r.Opportunity_Product__r.Id, //Coment - It is to create a link for take you to the register.
Product__r.Opportunity_Product__r.Your_Field__c)

This will have the following result
User-added image

I hope I helped you ! 

Good work for you !!!

Lucas.
Mac SwiftMac Swift
Thank you guys for the reply! but nothing worked :(

I have one ITEM Category Custom Picklist on PRODUCT OBJECT.

Which I want in my OPP PRODUCT OBJECT. I tried custome formula text field on

OPP PRODUCT -

TEXT(Product_Group__r.Product__r.Item_Type__c)

I TRIED:


HYPERLINK(Product_Group__r.Product__r.Id,
 IF( ISPICKVAL( Product_Group__r.Product__r.Item_Type__c , 'Black') , 'Black',
IF( ISPICKVAL( Product_Group__r.Product__r.Item_Type__c , 'White') , 'White',''))


I TRIED:

HYPERLINK(Product_Group__r.Product__r.Id,
TEXT(Product_Group__r.Product__r.Item_Type__c))


Please guys help me!
UC InnovationUC Innovation
Hi Mac,

I'm guessing OPP PRODUCT looks up to PRODUCT. You should just need a text formula field on OPP PRODUCT.

TEXT(Product__r.Item_Type__c)

Let me know if it works!