Help

Re: Changing help text based on input in a form?

523 0
cancel
Showing results for 
Search instead for 
Did you mean: 
echointer
4 - Data Explorer
4 - Data Explorer

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

Fillout's advanced forms for Airtable allows formulas in forms.