Help

How to require a 10 digit phone number on an Airtable form?

Topic Labels: Base design Formulas
Solved
Jump to Solution
1362 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Data_Team
6 - Interface Innovator
6 - Interface Innovator

Form question for you all. I need to capture phone number on an Airtable form however I can't figure out how to require it be entered as a 10 digit number so that area code is captured. The Phone number field type does not require the response to be 10 digits. I'm open to using the Formula field type however can't find a formula to use that would require 10 digits. Any help you can offer is greatly appreciated. Thanks!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

That is not possible with Airtable's forms (nor is it possible with Airtable's fields). Airtable doesn't allow us to restrict somebody to typing in a 10-digit number anywhere in Airtable.

However, there are 2 external form tools that provide this functionality:

1. JotForm offers tons of phone number validation functions. And after your form is submitted in JotForm, you can either use Make's JotForm integrations to send your data to Airtable, or you can use JotForm's "more basic" Airtable integrations.

2. Fillout's advanced forms for Airtable is likely the better option here. Fillout is 100% free, and it is the world's most advanced form software for Airtable. Fillout offers a bunch of validation functions, including the ability for you to specify your own RegEx code to validate a field. There is essentially no limit to what you can do with RegEx. Fillout also offers about 100 other advanced features for Airtable, such as updating Airtable records from a form, dynamic linked record filters (i.e. dynamic dropdown selections), the ability to accept payments on forms, the ability to have multi-page forms with conditional paths, the ability to create new linked records on a form, the ability to display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, and so much more.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

That is not possible with Airtable's forms (nor is it possible with Airtable's fields). Airtable doesn't allow us to restrict somebody to typing in a 10-digit number anywhere in Airtable.

However, there are 2 external form tools that provide this functionality:

1. JotForm offers tons of phone number validation functions. And after your form is submitted in JotForm, you can either use Make's JotForm integrations to send your data to Airtable, or you can use JotForm's "more basic" Airtable integrations.

2. Fillout's advanced forms for Airtable is likely the better option here. Fillout is 100% free, and it is the world's most advanced form software for Airtable. Fillout offers a bunch of validation functions, including the ability for you to specify your own RegEx code to validate a field. There is essentially no limit to what you can do with RegEx. Fillout also offers about 100 other advanced features for Airtable, such as updating Airtable records from a form, dynamic linked record filters (i.e. dynamic dropdown selections), the ability to accept payments on forms, the ability to have multi-page forms with conditional paths, the ability to create new linked records on a form, the ability to display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, and so much more.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

@ScottWorld thanks for your response and confirming it isn't possible in forms or fields. Super helpful!

HannesK-ME
7 - App Architect
7 - App Architect

Hey there, I just wanted to add that our miniExtensions Form offers this functionality as well. You can use a simple RegEx expression to force any format you like. ChatGPT is amazing for coming up with the right RegEx these days, in case you don't speak it fluently 😄 Here's an example of what this could look like:

Screenshot 2024-11-07 at 16.40.10.jpg