# Extract first number of phone number **URL:** \ **Category:** Ask for Help\ **Created:** [February 28, 2024, 8:47pm UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267 "2024-02-28T20:47:19Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [February 28, 2024, 8:47pm UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/1 "2024-02-28T20:47:19Z")
I want to check whether a phone number in a field starts with a 0. Is there a function that can filter out the first number to be able to check wheter it is a 0 or another number? ---
**Author:** ![Myles\_Chaput](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/myles_chaput/32/62176_2.png) [@Myles\_Chaput](https://community.glideapps.com/u/Myles_Chaput)\ **Post date:** [February 28, 2024, 10:52pm UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/2 "2024-02-28T22:52:58Z")
You could use an integration like zapier or more preferably [make.com](http://make.com). so instead of setting column values when your user presses submit, make a custom action to send a webhook to [make.com](http://make.com) with the necessary information, then use a filter there to set variables and do what you need it to do. Then add a new row. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 28, 2024, 11:30pm UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/3 "2024-02-28T23:30:48Z")
You can use the “check text matches” or “text slice” column. Display warnings using the hint component and set the visibility according to what you want to achieve. If you use “check text matches”, you can even check more using regex, for example: the number of digits after the first number. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 29, 2024, 12:41am UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/4 "2024-02-29T00:41:20Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/6/c657262830b53c6906a3a83429b182591cf99fd0.png) Here’s an alternative with JavaScript. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab6bf184e73e78d36edbe1c807bb227bfff6eb15.png) ```auto return /^0/.test(p1) ``` ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 29, 2024, 12:41am UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/5 "2024-02-29T00:41:51Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/216bc461cef837d04b43804fa0b89189cfe1f5a3.png) Here’s “Check text matches”. ---
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [February 29, 2024, 6:23am UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/6 "2024-02-29T06:23:22Z")
Thank you so much. This is very very helpful. I was checking all the documents on how to use these computed experimental text fields as I was suspecting that it might work with one of these, but could not find any. Is there any documentation on these so that I can do my own research before asking here? ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 29, 2024, 7:56am UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/7 "2024-02-29T07:56:19Z")
As far as I know, there isn’t specific documentation for experimental features like computed experimental text fields. However, they are relatively easy to use as long as you’re willing to follow the instructions and give them a try. > **[Experimental Code Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/experimental-code-column#:~:text=It%27s-,Experimental,-Support)** > > Create new computed columns with JavaScript. ---
**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 29, 2024, 9:56am UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/8 "2024-02-29T09:56:18Z")
> [@Himaladin](#): > > there isn’t specific documentation for experimental features like computed experimental text fields. There is this: > **[Plugins | Glide](https://www.glideapps.com/plugins)** > > Extend your apps with experimental features. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 7, 2024, 9:57am UTC](https://community.glideapps.com/t/extract-first-number-of-phone-number/71267/9 "2024-03-07T09:57:04Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.