Nintex Form Regex Validation on Decimal with 2 Decimal Places

  • 14 September 2021
  • 1 reply
  • 200 views

I have a SharePoint list field which is numerical with 2 decimal places.

In my Nintex form I have a Single Line Text Field which is tied this SharePoint list.

The String format on the control is set to 0.00

The validation is Regex ^[0-9]*.[0-9]{2}$

This regex seems to work just fine elsewhere (i.e. not in Nintex), but this regex does not match an entry of say 10.00, or 100.00.  My guess is Nintex is stripping off the .00 but why?

 


1 reply

Badge +8

hey @blythesr ,


 


I just tested ur Regex and it worked just fine.


 


could u provide some screenshots?


 


I have created a test list with a numerical field (2 decimal places)...then i startet the nintex form and edited the regex to the field... that was it.


 


where and why did u set the string format?

Reply