QB and SMS

  • 0
  • 2
  • Question
  • Updated 4 months ago
  • Answered
Is QB capable of sending SMS notification? If so, how would I go about setting this up?
Photo of Carlos Juarez

Carlos Juarez

  • 100 Points 100 badge 2x thumb

Posted 5 months ago

  • 0
  • 2
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
There are ways of doing it natively using emails; but there is also a Juiced Technologies' tool to do this as well if you want something more sophisticated.

Sending sms notifications via email involves knowing the correct format for each phone providers network to send sms throught email.

Case([Cell Provider],
"AT&T",[Cell # (as number)]&"@txt.att.net",
"Verizon",[Cell # (as number)]&"@vtext.com",
"T-Mobile",[Cell # (as number)]&"@tmomail.net",
"Sprint PCS",[Cell # (as number)]&"@messaging.sprintpcs.com",
"Virgin Mobile",[Cell # (as number)]&"@vmobl.com",
"US Cellular",[Cell # (as number)]&"@email.uscc.net",
"Nextel",[Cell # (as number)]&"@messaging.nextel.com",
"Boost",[Cell # (as number)]&"@myboostmobile.com",
"Alltel",[Cell # (as number)]&"@message.alltel.com",
"MetroPCS",[Cell # (as number)]&"@mymetropcs.com"
)

I have this working in one client's app.
(Edited)
Just toss it out there that integration tools like Workato have out of the box features like this - and build in additional features like logging what was sent when, to who etc. A third party tool will give you a little more visibility overall when you're trying to outbound communication
 
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
Photo of Jonathan Heuer

Jonathan Heuer

  • 402 Points 250 badge 2x thumb
One more suggestion: use Quick Base's Webhooks and a service like Twilio to send SMSs. If you don't know the recipient's carrier, this is probably the cheapest option (though you'll still need to pay Twilio per SMS).
Juiced has an add-on which will send and receive texts.  I have used it and its very solid. Never had a problem.
https://www.juicedtech.com/text-my-quickbase
Photo of Adam Keever

Adam Keever

  • 2,430 Points 2k badge 2x thumb
Check out the ABC QRCode Example app on the exchange. It uses Google API to send SMS.

Here is the code in the formula rich text field that accomplishes the SMS:
"<img src=\"http://chart.apis.google.com/chart?chs=200x200&amp;cht=qr&amp;chl=SMSTO%3A"; & [Mobile] & "%3A" & [SMS Message] & "\" alt=\"Send text message to the contact\" title=\"Send text message to the contact\"/>"

// This code was originally generated at https://www.the-qrcode-generator.com/
// The above link contains URL encoded characters.
// Legend:
// %3B ;
// %3D =
// %3A :
// %0A space