Jan 16, 2023 10:02 AM
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.
Solved! Go to Solution.
Jan 20, 2023 09:11 AM - edited Jan 20, 2023 09:13 AM
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!
Jan 16, 2023 10:20 AM
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?
Jan 16, 2023 10:40 AM
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.
Jan 16, 2023 11:31 AM
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...
Jan 16, 2023 11:32 AM
Not really sure this applies to my question, but thanks for chiming in...
Jan 16, 2023 12:41 PM
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!
Jan 17, 2023 02:48 AM
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.
Jan 20, 2023 09:11 AM - edited Jan 20, 2023 09:13 AM
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!
Jan 21, 2023 03:47 PM
What call system do you use? I use Google Voice Business for $10/mo.
Jan 21, 2023 04:02 PM
Please provide an example of actual input and output.