Loading

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

Date de publication: Oct 13, 2022
Description
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.
Résolution

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
Numéro d’article de la base de connaissances

000385791

 
Chargement
Salesforce Help | Article