Loading

Unable to create a formula field that has a rich text area field

게시 일자: Oct 13, 2022
상세 설명
We have created a formula field that we also want to include a rich text area field.  When we go to insert the field it is not available.
솔루션

Rich text area fields cannot be used in a formula. They can be used in validation rules and workflow rules.

Certain functions cannot be used on Rich Text Area.

For example, while ISNULL could normally be used to check if a field is empty, a Rich Text Field Area field would require you to use LEN(Rich_Text_Area_field_Name) = 0 instead.

In the above example, if an image is inserted in the Rich Text Area, LEN will also not work unless a space is added after the image.

Salesforce supports up to 131,072 characters for each rich text area field and which takes size from 32 KB to 128 KB.

Where as Formula fields can contain up to 3,900 characters which can contain up to 4000 Bytes when saved and 5000 Bytes when compiled. Some functions, such as TEXT, DATEVALUE, DATETIMEVALUE, and DATE significantly increase the compile size.


See also
Formula Field Limits and Restrictions
Rich Text Field Limitations
Knowledge 기사 번호

000385791

 
로드 중
Salesforce Help | Article