Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 19, 2024 09:15 AM
Hi! I'm trying to make it easier to check which cell phone carrier a person uses based on their phone number. Right now I have a formula I use, but formulas can't appear in forms
This is the formula I use:
IF({Phone Number} = BLANK(), '',
CONCATENATE('http://www.carrierlookup.com/index.php/api/lookup?key=', {API Key}, '&number=',
(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Phone Number}, '(', ''), ') ', ''),"-",""))))
Is it possible to replicate this effect in any way in a form?
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 19, 2024 09:29 AM
Fillout's advanced forms for Airtable allows formulas in forms.
