Create email button on the form that contains long body text

QuickBaseCoach App Dev./Training,

I tried to add URLEncode, but the Email Outlook window still does not open up.

Can you post your code?

For the button (Formula URL)
"mailto:"&""&[PR - CR - Email]&"\n"&"?subject="&"\n"&URLEncode([subject1_Warranty Determination]) &""&"&body="&""&([Email body1_Warranty Determination])&"&"

For the [subject1_Warranty Determination] (Formula rich text)
"Warranty Determination - PO#     Ticket#    Customer Name "

For the [Email body1_Warranty Determination] (Formula Text)

"Ticket #\nPO#\nCustomer Name:\n\nDear Service Center,\n\nGxi,  like any other manufacturer, we cover manufacturing defect. \n\nWe adopted  and follow the same process that many other manufacturers� have:\n\n1. They do not warrant products that are outside of the warranty period\n2. They do not warrant products that are customer abuse\n3. They do not warrant services that are routine maintenance\n4. They do not warranty products sold 2nd hand or through auction\n5. They do not warrant freight damage  if the customer did not note the damage at the time of delivery\n\nTicket #\nPO#\nCustomer Name:\n\nDear Service Center,\n\nGxi,  like any other manufacturer, we cover manufacturing defect. \n\nWe adopted  and follow the same process that many other manufacturers� have:\n\n1. They do not warrant products that are outside of the warranty period\n2. They do not warrant products that are customer abuse\n3. They do not warrant services that are routine maintenance\n4. They do not warranty products sold 2nd hand or through auction\n5. They do not warrant freight damage  if the customer did not note the damage at the time of delivery\n\n[IF THIS IS A MOWER] Prior to shipping, we sent _____________________ a pre-shipping notification on how to receive his mower and to note any and all damage at the time of delivery. It is to avoid freight damage issues �after the fact�.  We tested the product before it was shipped to ensure everything worked properly. He has used it extensively for commercially and has __XXX___ hours on it. See our comments below in yellow on each of the issues below: \n\nProblem 1 -  Unless there is a manufacturing defect, we do not cover this. We will cover the ignition switch as a courtesy but customer pay $16 for labor (customer covers the rest).\nProblem 2 � this is not a manufacturing defect.\nproblem 3 � this also not a manufacturing defect.\nProblem 4 -� adjustments are also not a manufacturing defect.\nProblem 5 � We may cover this as a courtesy. We will send a prepaid label to get this hydro back to determine warranty coverage. \nThis is a user issue. Customer are to follow the recommended maintenance schedule to ensure nuts, bolts, cables, are tightened. This also not a manufacturing defect.\n\nParts requested: \nXXXX - quote customer for parts and labor\nXXXXX  � quote customer for parts and labor.\nXXXXX  - We will cover the ignition switch as a courtesy but customer pays the labor.\n"


Can you please assist?

QuickBaseCoach App Dev./Training,

I still would not know why the email button is not working. Can you please dig into this method and help me figure out why this is not working for the long text body?

Thank you!

If you would like one-on-one assistance you would need to contact me directly at QuickBaseCoach.com

I'm not a Quick Base employee :)

Here is an example of code to toggle a checkbox and set a date /time field to the current date time

var bool NewToggle = not [my checkbox field top trigger an email Notification];

var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxx" // or omit this line if you have disabled the need for application tokens.

 & "&_fid_12=" & $NewToggle;
& "&_fid_13=" & urlencode(Now());

"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"


You will need to change the 12 and 13 to your own field IDs.