Syntax in sending a Text Message
So most of our new hires are all "texters", so I am trying to get it figured out. I have looked around and have a portion of it built. BUT... What would be the texting equivalent of the email subjec...
Forum Discussion
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
------------------------------
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
Qrew LegendIt 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
------------------------------
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
------------------------------
- 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
------------------------------ - MarkShnier__YouYour question really has nothing to do with texting. It really has to do with building the URL for a MAILTO:
Let me know if you are a still stuck with any of that.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - Mark -
Finally got back to this... I found out our recruiters use Google Messaging. I have seen a few posts on integration into QB, have not really read in depth though. Have you tried this before?
------------------------------
Hans Hamm
------------------------------ - MarkShnier__YouNo, I don't know anything about that. Maybe post a new question.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
