Setting of number field

  • Last Post 03 October 2018
Stephen posted this 19 September 2018

I have multiple field which belongs to numbers.


I want to make sure no other invalid character is in the field.


One possible solution would be set "AutoReplace" in the field property but i have to set all invalid character in the field and looks not efficeint.


I accidentally found one field fulfil my requirement with an error message as attached.

I cant really spot the difference of that field with my other number field.


Any quick tips for this setting?



Attached Files

Order By: Standard | Newest | Votes
Abbyy_user0707 posted this 19 September 2018

There is two decimal points in the field 24.471.11 because of that reason you are getting this error. You may change that to 24,471.11 then check.


Stephen posted this 19 September 2018


Thanks Abbyy_user0707!


in fact, I intentionally change the 24,471.11 to 24.471.11



Actually I want this error message show on every number field.


But fail to check this field on it's exact setting.


Any idea on how to set a number field not allow input invalid character like !,@,#,$,%..?

Abbyy_user0707 posted this 19 September 2018

Please refer the screenshot and change the setting in respective field. You can create new datatype also, by clicking new option and you can mention the allowed values 

Attached Files

Stephen posted this 19 September 2018

Thanks for the screen cap with explanation.I will check it soon.


I saw that you suggest to check the "Process as text" box, what is the function of that box? I check the help document and not quite understand.


Thanks in advance.

Ekaterina posted this 03 October 2018


The program will treat as text type all data types with different content (not only Text content) See the "Value range constraints for text data type" article in the Developer's Help