Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Syntax in sending a Text Message

What process is sending the text?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

6 Replies

HansHamm
Qrew Assistant Captain
5 years ago
Mark, I think this is one of your's... that I saw
Email Formula field
var text phoneone = Right ([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([Cell Provider]="AT&T","@txt.att.net",[Cell Provider]="Verizon", "@vtext.com", [Cell Provider]="Sprint", "@messaging.sprintpcs.com", [Cell Provider]="T-Mobile", "@tmomail.net", [Cell Provider]="MetroPCS", "@mymetropcs.com", "");
var text conct = $phonefive & $email;
$conct

------------------------------
Hans Hamm
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  It sounds like you are asking how to use a mailto: URL to put up a compose email screen using the default mail client on the users computer or phone and send a text message.
  
  I can't see how that would be reliable as you would need to know their carrier and hence a service like Twilio using a Pipeline or a service like Juiced would be more reliable.
  
  But the problem you are likely having is that you are not URLEncoding the URL that your are building.
  
  & "?subject=" & URLEncode("INFORMATION NEEDED TO ACTIVATE YOUR CARD")
  & "&body=" & URLEncode("Welcome Aboard " & [Associate First Name] & "!")
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - HansHamm
    Qrew Assistant Captain
    5 years ago
    Right now as we recruit people, we are asking for their carrier (giving them the reason)....
    I was hoping I could find a "work-around" to get the at least the body of the message to work for right now.
    If this indeed becomes a gamechanger then I would approach the company for funding an add-on. But until I know that it will make a difference I don't want to spend the $'s
    
    ------------------------------
    Hans Hamm
    ------------------------------