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


  • 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


  • 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]& -- the "" 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","",[Carrier]="Verizon", "", [Carrier]="Sprint", "", [Carrier]="T-Mobile", "", [Carrier]="MetroPCS", "", "");
var text conct = $phonefive & $email;

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.