Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
You are creating a URL and URL may not have spaces or special charaters in them, so you need to URLEncode the body too
"mailto:" & [PR - CR - Email]
& "?subject=" & URLEncode([subject1_Warranty Determination])
& "&body=" & URLEncode([Email body])
"mailto:" & [PR - CR - Email]
& "?subject=" & URLEncode([subject1_Warranty Determination])
& "&body=" & URLEncode([Email body])
- SalesInfo6 years agoQrew Assistant CaptainQuickBaseCoach App Dev./Training,
I tried to add URLEncode, but the Email Outlook window still does not open up. - QuickBaseCoachD6 years agoQrew CaptainCan you post your code?
- SalesInfo6 years agoQrew Assistant CaptainFor 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? - QuickBaseCoachD6 years agoQrew CaptainI suggest that you use the formula I supplied above.
"mailto:" & [PR - CR - Email]
& "?subject=" & URLEncode([subject1_Warranty Determination])
& "&body=" & URLEncode([Email body]) - SalesInfo6 years agoQrew Assistant Captain
- SalesInfo6 years agoQrew Assistant Captain
- QuickBaseCoachD6 years agoQrew CaptainAn idea is to try making the Subject line not be a formula Rich Text field. That might would tell is if that is the culprit.
But another thing to check is that the URL you are creating is very long and if you are using Internet Explorer (IE) as a Browser it probably exceeds the limitation of the browser handke that long a URL., Try Chrome or Firefox and see if it works. That would tell us if IE is the culprit.
Other than that i would have to work with you one on one to try to solve the problem.
QuickBaseCoach.com - QuickBaseCoachD6 years agoQrew CaptainOK, i just saw your post above. So my guess is that you are using IE and have exceeded its URL length limitation. The only solution is to use a different browser or to turn this into an email Notification where you send all that boiler plate in an email form that is send to the client.
is there an attached document which is being emailed too? is that why you are doing it this way? - SalesInfo6 years agoQrew Assistant CaptainQuickBaseCoach App Dev./Training,
1. I changed the subject line to Formula Text but it still did not work
2. I've been using Chrome for web browser, so IE cannot be a problem. - SalesInfo6 years agoQrew Assistant Captain