Print this page

Use a Formula for a field update to copy the value of a Long Text Area to a Text Area

Knowledge Article Number 000220149
Description I would like to copy the value of a Long Text Area field to a Text Area field in a workflow rule when performing a field update.  
Resolution As the Long Text Area field will support up to 131,072 characters you'll need to make sure only 255 characters are copied to your Text Area Field when using a field update in a workflow rule. The Text area fields only support up to 255 characters. Please use the following syntax in your formula:
LEFT( LongTexFieldName, 255 )

Replace "LongTextFIeldName" with the actual name of your long text field. Doing this may help prevent any unintended errors from occurring when the entire content of the long text field is moved to your text area field.

promote demote