Replace the "comma" character with the "period" character

Question

Hi all
I am following Appian standard in using a text field on a form with which to populate a decimal field in my rule input.
Appian standard behavior for a decimal field is that if a comma symbol is used to indicate a decimal place, the symbol is automatically removed and the value is then displayed with no separation.
Example:
The user enters 650,52
On refresh, the comma disappears and the value saved in the rule input is now 65052
If one uses the period symbol, the value is displayed correctly, thus 650.52, and the value is saved correctly into the rule input
We cannot assume that the target group of users will understand the distinction between the symbols, so we need to put in some sort of validation in order to avoid the issue.
I have tried using the cleanwith() function, but am unable to make it work.
I would like to be able to do one of the following (in order of preference):

have the comma symbol automatically replaced with the period symbol
set the field up so that it is impossible for a user to enter a comma symbol
set up a validation rule that recognises a comma symbol and requires the user to input a period symbol

Any help will be greatly appreciated!

marcelp0001 · Answer

Something along these lines? Does the job but probably could use some tinkering.

a!textField(
        label: "Your Decimal",
        saveInto: a!save(target: ri!decimal, value: todecimal(replace(save!value,find(",",save!value),1,"."))),
        value: ri!decimal,
      )

Out of interest, what Appian standard of using a text field instead of a decimal field are you referring to?

Sign up

Login with SSO

Login to the community

Login with SSO