Concatenate with If formulas
I am very new for formulas and could use any help. We are trying to send text message via email. This can be done if you know the provider (ex. 555-555-5555@vtext.com to email to a Verizon cell phone)...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOK try this
First section sets up what is called a formula variable. These are useful just to make the formula easy to read. It's just an intermediate calculation.
var text Suffix =
Case([Provider],
"Verizon", "@vtext.com",
"T-Mobile", "@tmomail.net");
[Cell/text#] & $Suffix
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
First section sets up what is called a formula variable. These are useful just to make the formula easy to read. It's just an intermediate calculation.
var text Suffix =
Case([Provider],
"Verizon", "@vtext.com",
"T-Mobile", "@tmomail.net");
[Cell/text#] & $Suffix
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I was able to get it to work! Thanks.
------------------------------
Renee Williams
------------------------------
------------------------------
Renee Williams
------------------------------
