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!
Solved
How to require a 10 digit phone number on an Airtable form?
+8Best answer by ScottWorld
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, this is possible with Fillout's advanced forms for Airtable.
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, creating custom PDF files from a form submission, creating 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.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
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
+35That 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, this is possible with Fillout's advanced forms for Airtable.
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, creating custom PDF files from a form submission, creating 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.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
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
+8That 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!
+13Hey 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:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.