Skip to main content
I know that the quick and simple solution to this is to change your field type to a number and use the FLOOR() rule.  We cannot change the type of this field because it will delete our existing data and we can't do that.

 

So which gets me asking, how can I make it so only numbers can be entered into a text field?

 

This is what I had before, but I don't want to format the numbers, so I know that I cannot use the REGEX rule.  I was thinking that I may be able to use the VALUE() rule, but I wasn't sure about that either.

 

NOT(

 

OR(

 

ISBLANK( Contract_ID__c ),

 

REGEX(  Contract_ID__c , "{9}")

 

)

 

)

 

Any help would be greatly appreciated. :)
9 answers
0/9000