We have introduced a new function, CLAMP, to restrict both numeric and text values to a specific range.

Use CLAMP to:

• Normalize numbers: Keep numerical values, such as scores or percentages, within a specific range. (e.g., CLAMP(score, 0, 100)).

• Constrain strings: Use lexicographical sorting to ensure string values fall within an alphabetical range (e.g., CLAMP(priority_level, "P2", "P4")).

For more information, see our documentation.