Skip to main content
Solved

How do I create click to dial phone numbers from a Phone Number field in my table

  • January 16, 2023
  • 12 replies
  • 463 views

Forum|alt.badge.img+3

So I have a Phone Number field containing phone numbers in this format: (123) 456-7890, and I want to automatically convert those numbers to links so that users can click on them to dial.

Best answer by remekoh

Maybe it was how I worded my question, but this problem has nothing to do with clicking on phone links within Airtable.

However, here's the solution that worked for me, just in case someone else is having a similar issue in the future:

1. Create a Formula field
2. Paste the following formula: 

CONCATENATE('<a href="tel:' & {YOUR FIELDNAME} & '">' & {YOUR FIELDNAME} & "</a>")

Hope that helps!

12 replies

Shannon_Bradley
Forum|alt.badge.img+15

My phone #'s are in that format, and when using the app on my phone it already works the way you describe, tapping that field I have the option to call or text. Are you talking about having that ability in the web version?


Forum|alt.badge.img+3
  • Participating Frequently
  • 7 replies
  • January 16, 2023

On the desktop, you must have a call application. Google Voice has a free plan. I use the $10/ month plan. It makes all numbers callable from my desktop.notebook. The paid version of voice adds a couple of other features. 

 
or 
 

Forum|alt.badge.img+3
  • Author
  • New Participant
  • 4 replies
  • January 16, 2023

My phone #'s are in that format, and when using the app on my phone it already works the way you describe, tapping that field I have the option to call or text. Are you talking about having that ability in the web version?


When you say when using the app on my phone, are you referring to the Airtable app?

I'm looking for a solution that allows for users of my web app to click that field and be able to dial that number... 

I tried this solution but it didn't work for me...


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 4 replies
  • January 16, 2023

On the desktop, you must have a call application. Google Voice has a free plan. I use the $10/ month plan. It makes all numbers callable from my desktop.notebook. The paid version of voice adds a couple of other features. 

 
or 
 

Not really sure this applies to my question, but thanks for chiming in...


Shannon_Bradley
Forum|alt.badge.img+15

When you say when using the app on my phone, are you referring to the Airtable app?

I'm looking for a solution that allows for users of my web app to click that field and be able to dial that number... 

I tried this solution but it didn't work for me...


Yes that is what I referred to. I feel that the user would need a desktop application to call from a separate web app? But there is so much ability AT has I don't know....following to see if someone else as the answer you seek!


Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • January 17, 2023

Not really sure this applies to my question, but thanks for chiming in...


A call application is required on the desktop.  From my desktop or notebook, I can call all numbers. Other features are available in the paid version of voice. 


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 4 replies
  • Answer
  • January 20, 2023

Maybe it was how I worded my question, but this problem has nothing to do with clicking on phone links within Airtable.

However, here's the solution that worked for me, just in case someone else is having a similar issue in the future:

1. Create a Formula field
2. Paste the following formula: 

CONCATENATE('<a href="tel:' & {YOUR FIELDNAME} & '">' & {YOUR FIELDNAME} & "</a>")

Hope that helps!


Forum|alt.badge.img+3
  • Participating Frequently
  • 7 replies
  • January 21, 2023

A call application is required on the desktop.  From my desktop or notebook, I can call all numbers. Other features are available in the paid version of voice. 


What call system do you use? I use Google Voice Business for $10/mo.


Forum|alt.badge.img+3
  • Participating Frequently
  • 7 replies
  • January 22, 2023

Maybe it was how I worded my question, but this problem has nothing to do with clicking on phone links within Airtable.

However, here's the solution that worked for me, just in case someone else is having a similar issue in the future:

1. Create a Formula field
2. Paste the following formula: 

CONCATENATE('<a href="tel:' & {YOUR FIELDNAME} & '">' & {YOUR FIELDNAME} & "</a>")

Hope that helps!


Please provide an example of actual input and output.


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 4 replies
  • January 26, 2023

Please provide an example of actual input and output.


Phone Number FieldFormula field with above formula
(123) 456-7890<a href="tel:(123) 456-7890">(123) 456-7890</a>

TheMortgageMeister
Forum|alt.badge.img+11

Maybe it was how I worded my question, but this problem has nothing to do with clicking on phone links within Airtable.

However, here's the solution that worked for me, just in case someone else is having a similar issue in the future:

1. Create a Formula field
2. Paste the following formula: 

CONCATENATE('<a href="tel:' & {YOUR FIELDNAME} & '">' & {YOUR FIELDNAME} & "</a>")

Hope that helps!


It is not working for me, where are the links appearing for the users to click? in a gridview or interface?


Forum|alt.badge.img
  • New Participant
  • 1 reply
  • June 9, 2023
  1. 'Determine the RowIndex of the Row whose LinkButton was clicked. Dim rowIndex As Integer = Convert.ToInt32(e.CommandArgument)
  2. 'Reference the GridView Row. Dim row As GridViewRow = GridView1.Rows(rowIndex)
  3. 'Fetch value of Name. ...
  4. 'Fetch value of Country.