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?
