Skip to main content
Question

Concatenate with If formulas

  • December 15, 2022
  • 0 replies
  • 169 views
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement