Decimal validation error for french users

Question

Hi,
I have one DECIMAL field in an English language based form. With English user it works, but for French users it doesn't validate the field saying it isn't a decimal since they use "," instead of "." for decimal field. I have put the condition for all read only fields and it is working fine only problem is with editable fields since the value is saved in a variable.How can I solve this issue?

Thanks.

abishekk109 · Answer

Please make those field to be a text field. so the value entered will be stored in the variable. After that in the process create a rule to convert the value into a decimal value and save it in db. By doing this you should make sure when we retrieve from db the decimal value should be converted back to the text form for the user to view it how they entered. 
 
Hope this helped. Let me know if u want more on this. 
 
Thanks, 
Abishek.

Aditya · Answer

hi amitas0001, 
 
a!textField( 
 label:"", 
 value:ri!dec, 
 saveInto: a!save(ri!dec,todecimal(substitute(save!value,",","."))), 
 validations:if(ri!dec>20,"Error",{}) 
) 
You can use this code to first convert your "," into "." and then save the variable in a decimal type rule input. You can also use validations as shown.