Forum Discussion

ReneeWilliams2's avatar
ReneeWilliams2
Qrew Member
2 years ago

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). I am planning  fields for cell/text#, list of popular providers, and a field that will  concatenate the cell/text# with the associated gateway domain. Ex

Cell/text#       providers list          based on Provider selected
6175555555      Verizon                  6175555555@vtext.com
                           T-Mobile               6175555555@tmomail.net        

Staff should be able to ender the Cell/Text#, select the provider from a dropdown list, and the email field will populate the concatenated results. Any help would be appreciated.

------------------------------
Renee Williams
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    OK 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
    ------------------------------
    • ReneeWilliams2's avatar
      ReneeWilliams2
      Qrew Member
      2 years ago
      I was able to get it to work! Thanks.

      ------------------------------
      Renee Williams
      ------------------------------