Button with Mailto link - Code stops working if & is in a field

Question

Hello,&nbsp;I have a button that generates an email with fields from a specific record.&nbsp; If a field contains any contents with an &amp;, anything below the &amp; will not populate in the email. How can I ensure the Mailto Link allows &amp; characters?Example:&nbsp;"mailto:"&amp;""&amp;[Email 1]&amp;"
"&amp;"?subject="&amp;"
"&amp;[Record]&amp;""&amp;"&amp;body="&amp;"Location Name: "&amp; [Location Name]&nbsp;"%0D"&amp;"field2"&amp;"%0D"&amp;"field3"&amp;""&nbsp;--- If Location Name for the records is AT&amp;T, then the body of the email will be "AT" and nothing after... ---&nbsp;How can I ensure the mailto link copies the exact field contents without stopping at the &amp; character?&nbsp;Thanks!------------------------------Meagan------------------------------

jeffpeterson1 · Answer

'&amp;' is a special character in the coding which needs to be 'escaped' or otherwise excluded.&nbsp; One approach is to use ATT instead of AT&amp;T when this happens:
"mailto:"&amp;""&amp;[Email 1]&amp;"
"&amp;"?subject="&amp;"
"&amp;[Record]&amp;""&amp;"&amp;body="&amp;"Location Name: "&amp; (If([Location Name]="AT&amp;T","ATT",[Location Name]))"%0D"&amp;"field2"&amp;"%0D"&amp;"field3"&amp;""
This might work also and retain the '&amp;' correctly in AT&amp;T:

"mailto:"&amp;""&amp;[Email 1]&amp;"
"&amp;"?subject="&amp;"
"&amp;[Record]&amp;""&amp;"&amp;body="&amp;"Location Name: "&amp; (If([Location Name]="AT&amp;T","AT&amp;amp;T",[Location Name]))"%0D"&amp;"field2"&amp;"%0D"&amp;"field3"&amp;""------------------------------Jeff Peterson------------------------------

miketamoush · Answer

Use URL Encode. These are my notes. I am not totally sure if it works with the Ampersand.var text Subject =&nbsp;&nbsp;&nbsp;&nbsp; "Enter Subject Line Text here " &amp; [Add Fields If Desired] ;&nbsp;var text File = URLRoot() &amp; "up/" &amp; Dbid() &amp; "/a/r" &amp; [Record ID#] &amp; "/e57/v0"; //use this if you want to include a file linkvar text Body =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; URLEncode("Enter text for body here")&nbsp;&nbsp;&nbsp; &amp; "%0A%0A"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //THIS IS A LINE BREAK PLUS SKIPS A LINE&nbsp;&nbsp;&nbsp; &amp; URLEncode("Company Name: " &amp; [Company Name]) // EXAMPLE OF HOW TO ENTER TEXT AND A FIELD&nbsp;&nbsp;&nbsp; &amp; "%0D%0A"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //THIS IS A LINE BREAK, DOES NOT SKIP A LINE&nbsp;&nbsp;&nbsp; &amp; URLEncode("File Link: " &amp; $File)&nbsp;&nbsp;&nbsp; &amp; "%0A%0A"&nbsp;&nbsp;&nbsp; &amp; URLEncode("QuickBase Link: " &amp; [Field]));var text Email = "mailto:ThisName@fakeemail.com" //WHAT EMAILS ARE IN THE TO LINE&amp; "?cc=ThisName@fakeemail.com"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //WHAT EMAILS ARE IN THE CC LINE&amp; "&amp;subject=" &amp; URLEncode($Subject)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //NOTE: If you remove the cc line, then: &amp; "?subject=" &amp; URLEncode($Subject)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp; "&amp;body=" &amp; $Body;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // The first line after mail to should have a '?' and NO "&amp;". This indicates everything following is being set.&nbsp;&nbsp;"&lt;a href="&nbsp;&amp; $Email&nbsp;&amp; "&gt;" &amp; "Create Email" &amp; "&lt;/a&gt;"------------------------------Mike Tamoush------------------------------

meagann · Answer

URLEncode worked perfectly! Thanks for the help.------------------------------Meagan Kellagher------------------------------

Forum Discussion

Button with Mailto link - Code stops working if & is in a field

3 Replies

Related Content

%%rid%% has ceased working on mobile - be advised

Google API QR Codes not working?

URL Formula, "mailto:" &

Add Save and Keep Working Button on form for a new record

Button: save the new record and edit the new record

Recent Discussions

'Is Set' in Pipelines

Share your feedback on the new Qrew Discussions

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Forms help

Empower Next Week!