Concatenate with If formulas

Question

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&nbsp; fields for cell/text#, list of popular providers, and a field that will&nbsp; concatenate the cell/text# with the associated gateway domain. ExCell/text#&nbsp; &nbsp; &nbsp; &nbsp;providers list&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; based on Provider selected6175555555&nbsp; &nbsp; &nbsp; Verizon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6175555555@vtext.com&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T-Mobile&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6175555555@tmomail.net&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;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------------------------------

markshnier__you · Answer

OK try thisFirst section sets up what is called a formula variable. These are useful just to make the formula easy to read.&nbsp; &nbsp;It's just an intermediate calculation.&nbsp;var text Suffix =&nbsp;Case([Provider],"Verizon", "@vtext.com","T-Mobile", "@tmomail.net");[Cell/text#] &amp; $Suffix​------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

reneewilliams2 · Answer

I was able to get it to work! Thanks.------------------------------Renee Williams------------------------------

Forum Discussion

Concatenate with If formulas

2 Replies