Is there an app that I can use to communicate to our employees through text messaging?

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • In Progress
Photo of Edward Guy

Edward Guy

  • 80 Points 75 badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of Drew

Drew

  • 522 Points 500 badge 2x thumb
zapier (and probably some others) have integrations that will allow you to send text messages.  I used it before in an internal messaging.  
Photo of Charlie

Charlie

  • 502 Points 500 badge 2x thumb
There is a way to string together an email address based on each person's phone # -- then leveraging the native email notifications to send texts. However you must know EVERY persons cell provider to be able to create the email address. For example something like [phone number]&att.net -- the "att.net" you'd have to store as part of the person's record in QB to concatenate that to the phone #. If this is possible, check this out: 


var text phoneone = Right ([Cell Phone], 13);
var text phonetwo = Left ($phoneone, 3);
var text phonethree = Mid ($phoneone, 6, 3);
var text phonefour = Right ($phoneone, 4);
var text phonefive = $phonetwo & $phonethree & $phonefour;
var text email = If([Carrier]="AT&T","@txt.att.net",[Carrier]="Verizon", "@vtext.com", [Carrier]="Sprint", "@messaging.sprintpcs.com", [Carrier]="T-Mobile", "@tmomail.net", [Carrier]="MetroPCS", "@mymetropcs.com", "");
var text conct = $phonefive & $email;
$conct

If the above isn't achievable then a simple integration between QB and Workato or Zapier with Twilio or their internal SMS (depends on volume/cost) could be done easily.