 I'm just learning Nintex Forms and found out that a SharePoint field control, such as a number field set to two decimals, comes over on the Nintex form as a Single Line Textbox control and doesn't respect the SharePoint field settings! So, the user can type in alpha characters, 500 numbers after the decimal, etc. Annoying!
So, here are some of my common expressions used in the Validations section of the Control Settings of the Single Line Textbox SharePoint field control:
Currency
To show currency in ##.## format, 1199 before the decimal and 2 digits after the decimal.
^([1][19][09][19][09][09])((\.)[09][09])$
Decimal
To show a number in #.## format where the decimal is optional, allowing 12 digits before the decimal and 12 digits after the decimal (optional).
^[19][09]{0,2}(?:\.[09]{0,2})?$
Days of the Month
To allow numbers 131 to be entered.
^(3[01][12][09][19])$
Valid Year
To allow a valid 4digit year between 19002099.
^(?:(?:1920)[09]{2})
Valid Zip Code
To allow 0000099999 to be entered.
Number Range
To allow numbers 1160 to be entered.
^([19][18][09]9[09]1[05][09]160)$
