HI All,
I have a text field which takes decimal values , i want to restrict(put validation) the field with precision of 22 which means user is allowed to enter 13 digits before decimal and 9 digits after decimal point not more than that . Also, i want to store the value as it is (no round off) .
Please can somebody help me with this .
Thanks in advance.
Discussion posts and replies are publicly visible
You can use regexmatch() to acheive this
regexmatch("^-?\d{0,13}(\.\d{0,9})?$",ri!number)
I created this regex expression but it works untill Appian converts value into exponential form . Is this expected behavior ? or Am i doing something wrong?
Hi,
I am facing the similar issue now. Did you manage to solve this problem? Appreciate your response.
Thanks,
Arun
You can store this value into a seperate variable by using text function and do the validation on that variable.
Facing similar issue but regex is not working on decimal text field
can you please help me with this?
I tried fixed but not working.
I need my decimal field only takes decimal up to 2 places
What issue you are facing?
I have replied to your query here - community.appian.com/.../add-specific-validation-to-text