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
Bella Patel 21Bella Patel 21 

Cross formula is not populating the field.

I have this formula on case object but the field is not getting populated
TEXT(Source:LiveChatTranscript.Chat_status__c)

I have created a lookup field to Chat transcript oject.

Any suggestions why the field is not populating?
PriyaPriya (Salesforce Developers) 

Hi Bella,

Please explain this in detail. 

Regards,

Priya Ranjan

Bella Patel 21Bella Patel 21
Hey Priya.

So I created a picklist field on Chat Transcript based on Chat Transcript Event. The picklist works on the Chat Transcript Record and now I am trying to show that field on case records.

I created a formula field on case object and set the formula return type as text. The formula I am using is TEXT(Source:LiveChatTranscript.Chat_status__c). The field is not showing the result that is showing on the Chat Transcript reocords.


 
Bella Patel 21Bella Patel 21
User-added image
 
mukesh guptamukesh gupta
Hi Bella,

Please follow below url with work around :-

https://trailblazer.salesforce.com/issues_view?id=a1p3A0000003eiRQAQ&title=when-creating-a-formula-field-on-chat-transcript-the-insert-field-dialog-does-not-show-lookup-fields-that-exist-on-the-transcript (https://trailblazer.salesforce.com/issues_view?id=a1p3A0000003eiRQAQ&title=when-creating-a-formula-field-on-chat-transcript-the-insert-field-dialog-does-not-show-lookup-fields-that-exist-on-the-transcript)

if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh 
Bella Patel 21Bella Patel 21
The formula field works on Chat transcript. I am just trying to show the result of that field on Case records.