Increase Character Limit Beyond 256 for String Functions (To String, To Lower, Concat String) in Rules Engine Formula Fields

Problem Statement

In the Rules Engine, when using formula fields with string manipulation functions such as Concat String, To String, and To Lower, the current character limit is capped at 256 characters. This creates a significant functional limitation when working with rich-text fields (e.g., Comments) that commonly exceed this threshold.

Specifically, the following issues arise:

• Concat String function fails when the concatenated output exceeds 256 characters
• To String and To Lower functions fail when the source field (e.g., a rich-text Comments field) contains more than 256 characters
• String formula fields cannot be directly compared with rich-text field types, adding an additional layer of incompatibility
• There is no viable workaround currently available to handle this use case when field values exceed the 256-character limit
   

Expected / Desired Behavior

1. Increase the character limit for formula field string functions (Concat String, To String, To Lower) to support a minimum of 2,000+ characters or align with standard rich-text field capacity
2. Enable native comparison between formula-generated string fields and rich-text field types within Rules Engine criteria
3. Optionally, provide a dedicated rich-text formula function that handles large text fields without truncation or failure