Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoOK 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
------------------------------
- ReneeWilliams23 years agoQrew MemberI was able to get it to work! Thanks.
------------------------------
Renee Williams
------------------------------