This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Only number is allow not other sign like +, %,- and etc

Posted on 01-16-2025 10:04 PM
desmond_lee
Silver 4
Silver 4
Reply posted on --/--/---- --:-- AM

Hi Guy

I have a question here. Is it possible expression under the valid_if for key data ONLY NUMBER under the data type Phone ? Very there is user keep key in +15 or +23 and etc

Solved Solved
0 4 173
Topic Labels
Jump to Solution
0 Likes
2 ACCEPTED SOLUTIONS

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Please try in the valid_if setting of the phone column

SUBSTITUTE(NUMBER([_THIS]),",","")=[_THIS]

View solution in original post

Jump to Solution

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
In response to desmond_lee
Reply posted on --/--/---- --:-- AM

Please try 

AND(SUBSTITUTE(NUMBER([_THIS]),",","")=[_THIS],
NUMBER(LEFT([_THIS],1))>=1
)

View solution in original post

Jump to Solution
4 REPLIES 4
Top Labels in this Space