Changing help text based on input in a form?

Topic Labels: Formulas
219 1
Showing results for 
Search instead for 
Did you mean: 
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('', {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.