Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoThe issue is that you are building a URL string.
URLs should not have any spaces or special characters in them. So any text which might have spaces or siecial characters needs to be URLEncoded.
var text TextA =URLEncode( [field1]);
do not URLEncode where you are using
&"%0D%0A" & "%0D%0A" &
As that us already URLEncoded.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
URLs should not have any spaces or special characters in them. So any text which might have spaces or siecial characters needs to be URLEncoded.
var text TextA =URLEncode( [field1]);
do not URLEncode where you are using
&"%0D%0A" & "%0D%0A" &
As that us already URLEncoded.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- ROBERTSACHS5 years agoQrew CadetThanks, but that raises more questions.
The button to invoke the email is standard:
"mailto:"&[Submitter.Email] &
"?subject="&[Email.SubjectLine: CTS_Evaluation_Completed]&
""&"&body="&[Email.Body: CTS Evaluation Completed]&""
The problematic component is body field. I understand that this button is constructing a URL, using the computed result in the body field [Email.Body:CTS Evaluation Complete] .
I'm not using URLEncode in the body at all. I'm constructing a large string of defined text blocks concatenated together, using formulas to determine which blocks to select.
Throughout, I use the &"%0D%0A" & "%0D%0A" & for paragraph returns, and it works just fine. The problem arises when I simply add that one extra text block MyTextB. Even if it just 14 chars of straight text, no spaces or special characters, then the entire thing fails.
Indeed, I just ran another text and setting MyTextB to "AAAAAAAAAAAAA" worked, but "AAAAAAAAAAAAAx" failed. That was the only change made, adding "x", and bingo. Nothing.
I do use chars including : and / in the other texts but that does not cause any problems.
Still stumped...
------------------------------
ROBERT SACHS
------------------------------- MarkShnier__You5 years ago
Qrew Legend
I would need to see your current formula which does not work.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- ROBERTSACHS5 years agoQrew CadetI'll send it to your gmail account.
------------------------------
ROBERT SACHS
------------------------------