Phone Number Format "CLICK TO CALL" option on Web App

Thank you Justin! :smiling_face_with_three_hearts: Do you know if there are currently any ways to make the phone number clickable inside of Airtable or do we just need to copy and paste the phone number into our calling system? Thank you in advance!

Per the conversation earlier in this thread, you can add the “tel://” prefix in a formula field to make it clickable in the browser version:

"tel://" & VALUE({Phone Number})
2 Likes

Thank you, Justin. I will try that. I saw that but I wasn’t sure if there were updates since then.

Alright, this is no bad. But how can i make the formula field not to delete the first “0” in numbers? We are calling customers in France, Switzerland and Germany and the format should be either:

0041791112233 or +41791112233 (if we get the phone numbers in this format 0041xxxxxxx) the zeros are deleted.

0041791112233 tel://41791112233 -> which does not work.

Any help?

1 Like

Welcome to the community, @Sven_Klein! :smiley: In your situation, you should drop the VALUE() wrapper around the phone number field reference.

"tel://" & {Phone Number}

For ten-digit phone numbers, referencing the field alone will return a string that includes punctuation in & around the digits:

(111) 222-3333

VALUE() strips away the punctuation, returning the numerical value of the numbers within the string. Because a true number (i.e. not a phone number) wouldn’t have leading zeroes, they’re removed by VALUE() automatically.

FWIW, if your base has a mix of ten-digit numbers and longer overseas numbers, this formula will work for both:

"tel://" & IF(FIND("(", {Phone Number}), VALUE({Phone Number}), {Phone Number})

Screen Shot 2020-06-15 at 9.33.06 PM

1 Like

Hi @Justin_Barrett, thank you very much for your quick response. This is highly appreciated. I think, we can you set up Airtable for our team :slight_smile:

I exported all our contacts from Google as a CSV and uploaded it to Airtable. I’d like for users to be able to call contacts directly through the app by turning the phone numbers into links that prompt the phone to dial–not calling through the app.

If I make a column to the left or right of the numbers with the following formula, tel://(referencing a phone number next to it) can it work?

I can’t seem to make it work or any of the formulas I’ve seen in this specific forum.

Thanks!

That depends on the data in the phone number field. If you could provide specific examples of the phone numbers, we can offer more specific guidance on how to set this up.