Is numeric column - how to?

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

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 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

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 :wink:

2 Likes

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?

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.

In that example I gave earlier, the column configuration looks like this:

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 ?

1 Like

AHHHH sheesh I must have looked a hundred times for it. Thanks so much @darren

There are an awful lot of them, we are spoilt for choice these days :slight_smile:

Usually what I do is head over to the Plugins section 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.

1 Like

You saved me a major headache. Thank you :slight_smile:

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


  1. + ↩︎

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

Note that the logic is switched around, so it returns true if the number is “valid”.

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…

Yes, I’ve noticed that as well. Usually if you enter it a second time it will stick.