Forum Discussion

11 Replies

  • 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.
    • BLAKECARLSON's avatar
      BLAKECARLSON
      Qrew Member
      What field or fields do i need to make and how do i integrate them in an email??

      ------------------------------
      BLAKE CARLSON
      ------------------------------
  • 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
  • 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).
  • 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
    • RojaM's avatar
      RojaM
      Qrew Member
      Hi Adam,

      How to send message from the QR code.
      Can you please briefly explain?

      ------------------------------
      Roja M
      ------------------------------
    • BarryDolan's avatar
      BarryDolan
      Qrew Cadet
      Hello Adam,

      I'm just wondering if there is an updated method for this QR code. I tried the code and got a QR code but it says "no useable data found"

      Thanks

      ------------------------------
      Barry Dolan
      ------------------------------
  • Twilio and Pipelines or Zapier can be used to do this,  if you're savvy to build your own functions custom.    I'm currently building this functionality into our system.

    ------------------------------
    Jeff Peterson
    ------------------------------
    • BarryDolan's avatar
      BarryDolan
      Qrew Cadet
      Quasi-savy, if that's such a thing. Right now we're using Zapier to integrate with Skipio. But, w/o knowing much about Twilio, I think we might be switching to set it up in Pipelines and connect the Twilio channel. I'm still trying to get info on cost/benefits of making this switch. I'd like to think that using Pipelines is going to be more cost-effective, but I don't have enough info to make that hypothesis at this time.

      Ultimately I want to be able to send a text msg from a triggered event in the database to my customers to confirm an appt, among other things.

      ------------------------------
      Barry Dolan
      ------------------------------
      • JustinAufiero's avatar
        JustinAufiero
        Qrew Member
        Barry,

        We actually have an Add-On that can do EXACTLY what you're looking for (Text My Quickbase) that we'll be going over in our next Office Hours session on October 12th at 2pm EST.

        We'd love to have you there! You'll be not only be able to learn the basics, but you'll also be able to get any questions you have about the Add-On answered in real time.

        Register here: https://us02web.zoom.us/meeting/register/tZwpdOCvqT8iGNDjKz03I3OUXyF1Ja_GPrda

        ------------------------------
        Justin Aufiero
        Juiced Technologies, Inc.
        ------------------------------