Skip to main content
Hi Guys, 

 

I am working within (2) custom objects. Object 1 = OCG Order, Object 2 = Diagnostic Order. 

 

I created a lookup relationship from OCG Order to Diagnostic Order. 

 

There are fields that live on diagnostic order that I would like to pull into OCG Order. I've added a formula field on OCG Order to pull in the value from a field on Diagnostic order. I did not get any errors when completing the formula. I simply inserted the field I wanted to pull in by using the advanced formula option: OCG Order>Diagnostic Order>API name of the field I'm after.

 

When I was done creating this field. I switched to my support console to test. I entered a value in the field that I expected to speak back to OCG order on the Diagnostic Order record. Saved. Went to the record OCG Order Record, refreshed the page...Nothing. Please help! I did a bit of digging around and saw some along the lines of this: Data TypeFormula  

 

"Diagnostic_Order__r." + "+Diagnostic_Order_Partner__c" as the formula value...This didn't necessarily work...it populated exactly that, in the field on the OCG order record rather that the actual value...I also saw something along the lines of changing the API name of the field in the formula from ending with c to r so that it's pulling the ID instead...not luck there either. 

 

Grateful to anyone who can save me tonight. I hope this is all clear enough. Thank you!
15 respostas
  1. 30 de set. de 2020, 05:27
    Hi Alisa,

     

    Can you try the following:

    IF(INCLUDES( Diagnostic_Order__r.Diagnostic_Orders__c , "Specialist Referrals"), "Specialist Referrals", NULL) & BR() &

    IF(INCLUDES( Diagnostic_Order__r.Diagnostic_Orders__c , "Cardiovascular Testing Options"), "Cardiovascular Testing Options", NULL) & BR() &

    IF(INCLUDES( Diagnostic_Order__r.Diagnostic_Orders__c , "Pulmonary Function Testing Options"), "Pulmonary Function Testing Options", NULL) & BR() &

    IF(INCLUDES( Diagnostic_Order__r.Diagnostic_Orders__c , "Radiology Testing Options"), "Radiology Testing Options", NULL)