Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Changing help text based on input in a form?

Topic Labels: Formulas
587 1
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
ScottWorld
18 - Pluto
18 - Pluto

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