# Is numeric column - how to? **URL:** \ **Category:** Ask for Help\ **Created:** [February 7, 2022, 4:19am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207 "2022-02-07T04:19:25Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 4:19am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/1 "2022-02-07T04:19:25Z")
Hello, I want to check if a column (a phone number) is a number, so on Google sheet, I use a formula like this: =IF(ISNUMBER(D2),“true” , “false”). How do I do the same thing on Glide table column? I checked all the options, couldn’t find anything. Thank you @ThinhDinh @Jeff_Hager ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2022, 4:44am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/2 "2022-02-07T04:44:46Z")
If you only want to allow digits, then you can configure the column type as “Number” in Glide and it will ignore any non-digits. Glide also has a Phone Number column type, but I don’t think it does any validation. But phone numbers can contain more than just digits: `+() -` and spaces are all generally considered valid characters in a phone number - do you also want to allow those, or strictly digits only? To do the same thing that your current Google Sheet formula does, and return a true/false result, you can use the [Check Text Matches](https://www.glideapps.com/plugins/regex-matchany) plugin: If you wanted to extend that a bit to allow for extra characters, then you could use the same plugin and modify the regular expression slightly: `([^\d\s\-\(\)\+]+)` ![Screen Shot 2022-02-07 at 12.55.34 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aaeee426041ef4cfafce1d06e1cadd0784c2a92b.png) This can become a bit of a rabbit hole though. For example, a plus (+) is usually okay in a phone number, but only at the start. So `+1 888-3456` would be a valid phone number, but `1 888 +3456` would not. It just depends how far down the rabbit hole you want to go 😉 ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 6:06am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/3 "2022-02-07T06:06:19Z")
This is great! I just want to allow numbers. A bit confused about how the plugins work. Do I still need to install it or can I find it on column options? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2022, 6:14am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/4 "2022-02-07T06:14:07Z")
Just create a new column in the Data Editor, and you’ll find all the plugin columns at the bottom of the list of column types. Once you select one, it will have input boxes for the expected parameters. In some cases, this can be another column, and in other cases a text input is expected. ![Screen Shot 2022-02-07 at 2.11.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/3046b52d83385df79d230c24cf8364d07a0baaf7.png) In that example I gave earlier, the column configuration looks like this: ![Screen Shot 2022-02-07 at 2.15.48 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/936901037a88198ef0561bc1fd5c0a875acb4dc2.png) ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 6:16am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/5 "2022-02-07T06:16:58Z")
Yes, I looked at all of them and couldn’t find anything like “text match” or any sort of validation action. What should I look for specifically @Darren_Murphy ? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2022, 6:18am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/6 "2022-02-07T06:18:44Z")
![Screen Shot 2022-02-07 at 2.17.40 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08d0d56c3c1cc61284bbfe9768fb92851192c45c.png) ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 6:20am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/7 "2022-02-07T06:20:19Z")
AHHHH sheesh I must have looked a hundred times for it. Thanks so much @Darren_Alderman ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2022, 6:22am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/8 "2022-02-07T06:22:36Z")
There are an awful lot of them, we are spoilt for choice these days 🙂 Usually what I do is head over to the [Plugins section](https://www.glideapps.com/plugins) in the Glide Docs first to find the one I want and do a bit of testing, before I look for it in the GDE. ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 6:26am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/9 "2022-02-07T06:26:31Z")
You saved me a major headache. Thank you 🙂 ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 6:38am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/10 "2022-02-07T06:38:12Z")
> [@Darren\_Murphy](#): > > `([^\d\s\-\(\)\+]+)` How would you validate a WhatsApp number? i can accept it with or without + in the beginning or to keep it simple just validate the amount of numbers but that varies as well … ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 6:46am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/11 "2022-02-07T06:46:10Z")
> [@SuperMerabh](#): > > How would you validate a WhatsApp number? i can accept it with or without + in the beginning or to keep it simple just validate the amount of numbers but that varies as well … Found this one \[1\]_[(]{0,1}[0-9]{1,4}[)]{0,1}[-\s./0-9]_$ Seems to validate it’s all numbers but doesn’t validate how many numbers Source [RegExr: Learn, Build, & Test RegEx](https://regexr.com/3c53v) * * * 1. + ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2022, 6:54am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/12 "2022-02-07T06:54:27Z")
Try this one: `^(\+?\d{6,10})$` That will match if: - the first character is a + (optional) - all other characters are digits only - the length of the number is between 6 and 10 ![Screen Shot 2022-02-07 at 2.52.01 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/7996b7f971eb65b8cfe66a942d3585fc6a682945.png) Note that the logic is switched around, so it returns true if the number is “valid”. ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [February 7, 2022, 7:45am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/13 "2022-02-07T07:45:15Z")
> [@Darren\_Murphy](#): > > `^(\+?\d{6,10})$` Thank you so much, if I enter a number with + into the Glide database, the + sign seem to change to a - Weird. I also changed the amount to 12 characters because looks like some numbers are this long… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2022, 7:47am UTC](https://community.glideapps.com/t/is-numeric-column-how-to/38207/14 "2022-02-07T07:47:39Z")
> [@SuperMerabh](#): > > if I enter a number with + into the Glide database, the + sign seem to change to a Yes, I’ve noticed that as well. Usually if you enter it a second time it will stick.