# Convert number to whatsapp link

**URL:** <https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259>\
**Category:** Ask for Help\
**Created:** [October 18, 2021, 7:53pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259 "2021-10-18T19:53:20Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 18, 2021, 7:53pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/1 "2021-10-18T19:53:20Z")

</div>

Hello ALL…

Is anyone have an idea how to convert this.  
I am going to ask users to add their phone number.  
Once it is recorded on table or GS i need to add the whatsapp web link which always have this pattern: ‘[Share on WhatsApp](http://wa.me/33648381930)’ where the first numbers (or number) is the number of the country.  
I guess it is something related to strings. Once the string is built should it be “passed” to an url column so I can call it in a component?  
In my project it will be a button with the label CONTACT THE SELLER

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 18, 2021, 8:08pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/2 "2021-10-18T20:08:53Z")

</div>

You can built that using a template column. I don’t know if the country code is part of the number column or in a separate column. If it isn’t then it’s as simple as building a template column like this:

```auto
https://wa.me/{number}

```

And create a replacement for {number} to point to your number column. That template column will be your url.

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 18, 2021, 8:09pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/3 "2021-10-18T20:09:42Z")

</div>

Thank you Jeff …  
Wonderful !!! 😀 😀

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 12:17pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/4 "2021-10-19T12:17:42Z")

</div>

@Jeff_Hager Yesterday that seems to me so obvious but I did not had a chance to try it. Today, yes, but I couldn’t figure it out. I only have about 10 days experience… 😏  
I’ve done all the process but I am missing something.  
If someone else tried what explained Jeff, could you share plz?

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [October 19, 2021, 12:22pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/5 "2021-10-19T12:22:54Z")

</div>

Remove spaces, remove +, -, (, ) from the number.

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [October 19, 2021, 12:26pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/6 "2021-10-19T12:26:12Z")

</div>

I tested and it’s working good.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/147c4f7ba0b03aec73a9e4fe87d3dc80d5745a8d.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8d496fe8d67639340726a67ec81952fc4a940a03.png)

Put the Precision to 1 and untick the group separator of that Phone Number column and see @jabid

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 12:36pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/7 "2021-10-19T12:36:52Z")

</div>

I have done that… but my problem is related to template column, can you show me your example?

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [October 19, 2021, 12:38pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/8 "2021-10-19T12:38:16Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55ff94e8fc78c7f1c0dbf91198c8e9e20a31b6f8.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08d6d040ab7906740f4236e33eca2b8879b96bd3.png)

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 1:12pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/9 "2021-10-19T13:12:17Z")

</div>

It does not store the replacement on my column.

 ![Capture d’écran (141)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/019f4596caf3e2cf6e65c91061bfb3cb10b8d795.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 19, 2021, 1:16pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/10 "2021-10-19T13:16:03Z")

</div>

Looks like you are using the phone number from the user profile and you are previewing the app as Hounaiine (sorry about spelling). Does that user have a phone number on their user profile?

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 2:43pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/12 "2021-10-19T14:43:30Z")

</div>

No it has not but I changed that and the problem persists.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 19, 2021, 2:53pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/13 "2021-10-19T14:53:21Z")

</div>

Changed what? The value you are setting for the replacement needs to be populated with something. If it’s empty, then it’s going to replace with an empty value. I don’t know what else to tell you. Based on what you showed in your screenshots, I can only assume that the phone column in the user profile for the user you are previewing as is empty. I can’t see what’s in your users table, so I don’t know of there is a value or not.

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 3:13pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/14 "2021-10-19T15:13:40Z")

</div>

OK. The cell is not empty here is the the table of users the last one is the the one I try to contact via whatsapp try to contact via whatsapp

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 19, 2021, 3:19pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/15 "2021-10-19T15:19:43Z")

</div>

The column in your user sheet is named ‘number’.

In your template column, your replacement is referring to a column named ‘phonenumber’ in your user sheet.

Something isn’t making sense, because your the template column should be pointing to the column named ‘number’.

Are you sure you have your user profiles set to the correct table?

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 3:21pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/16 "2021-10-19T15:21:02Z")

</div>

As you can see in my new try when changing "numberphon"e by “number”  
there a kind of a bug since when I enter the replacement in template column I have my own phone that is displayed automatically

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 3:22pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/17 "2021-10-19T15:22:04Z")

</div>

Sorry l should have mentioned it before my previous post.

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 3:23pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/18 "2021-10-19T15:23:33Z")

</div>

Of course last column should be deleted. It has nothing to do here.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 19, 2021, 3:24pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/19 "2021-10-19T15:24:27Z")

</div>

Of course it’s going to be your number. You are pointing the replacement to the user profile, so it’s always going to pull in the number of the signed in user.

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 3:29pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/20 "2021-10-19T15:29:27Z")

</div>

OK; i AM CLOSE to get it. So, where should it point ? I need to point the users’s number who sent the post

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 19, 2021, 3:43pm UTC](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259/21 "2021-10-19T15:43:47Z")

</div>

IT WORKS. Thanks a lot.  
I understood what happened.  
I could not find the right fake user I created because when you create a user with google login it gives different emails so the cell was empty.  
Thank you so much for the time spent to help.  
I’ll repay you 🙂 I’m still new but I know a lot about concepts …

[Next page](https://community.glideapps.com/t/convert-number-to-whatsapp-link/33259.md?page=2)
