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

Related Content

Address field not working

Maximum Summary field not working

API Button Help

Formula Url Buttons

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