Workflow - HTML decoding of parameters to be used in formulas #5002

New issue

Open

opened 2026-02-20 16:27:42 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:27:42 -05:00

Owner

Originally created by @SinergiaCRM on GitHub (Apr 21, 2023).

Issue

When creating a workflow that performs an action on calculated fields with functions such as substring, length, uppercase or replace, some special characters (such as á,à,ä,ñ) are miscoded.

Expected Behavior

Correct encoding of special characters is expected.

Actual Behavior

For example, when passing montaña to the uppercase function the result isMONTA&NTILDE;A(&NTILDE; is not an HTML entity, the correct one for Ñ is Ñ). Using the length function in this same word calculates 14 instead of the expected 7. This does not happen with lowercase because MONTAÑA becomes MONTAÑA and then montaña which in this case can be reconverted to montaña.

Steps to Reproduce

1.Create different workflows that use the action of calculated fields with functions such as length, or uppercase.
2.Create a record on which the workflow acts that contains special characters such as á,à,ä,ñ.
3.Check that there is a coding problem.

Your Environment

SuiteCRM Version used: 7.12.10
Operating System and version: Ubuntu 20.04

Originally created by @SinergiaCRM on GitHub (Apr 21, 2023).     #### Issue When creating a workflow that performs an action on calculated fields with functions such as _substring_, _length_, _uppercase_ or _replace_, some special characters (such as á,à,ä,ñ) are miscoded. #### Expected Behavior Correct encoding of special characters is expected. #### Actual Behavior   For example, when passing `montaña` to the _uppercase_ function the result is` MONTA&NTILDE;A `(`&NTILDE;` is not an HTML entity, the correct one for Ñ is `Ñ`). Using the _length_ function in this same word calculates `14` instead of the expected `7`. This does not happen with _lowercase_ because `MONTAÑA` becomes `MONTAÑA` and then `montaña` which in this case can be reconverted to `montaña`. #### Steps to Reproduce   1.Create different workflows that use the action of calculated fields with functions such as _length_, or _uppercase_. 2.Create a record on which the workflow acts that contains special characters such as á,à,ä,ñ. 3.Check that there is a coding problem. #### Your Environment  * SuiteCRM Version used: 7.12.10 * Operating System and version: Ubuntu 20.04