Forum Discussion

SheriWoodward's avatar
SheriWoodward
Qrew Trainee
5 years ago

URL Email data all going to "To" suddenly

Using a URL - Formula, as follows, this normally pre-populates an email with the form fields, but now it's including all details in the "To" field on the email rather than in the proper spots.  Any id...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
try making a new field and try this formula.
But I also had an experience where this syntax which has worked for me for the past 15 years suddenly stopped working for Microsoft Outlook. I never did figure it out. 

"mailto:" & [Customer Support Agent - Reviewer]&
"&subject=" &urlencode("Review Request: "&[Adjustment Type] & " of " & [Credit Amount in USD] & " USD") &
"&body="

& urlkencode("Hello,")
& "%0A%0A"

& urlencode("I am requesting a " & [Adjustment Type] & " with the following details. Please reply with Posted in SAP OR Need More Info")

&"%0A%0A"

& urlencode("Please click here for more details: " & [Link to record])
& "%0A%0A"

& urlencode("Customer Error/Discretionary Credit") & "%0A"
& "%20%20%20" & urlencode([Customer Error/Discretionary Credit?]) & "%0A%0A"

& "Sales Order Number: " & "%0A"
& "%20%20%20" & [Sales Order (SO) number] & "%0A%0A"

& "Original Order Amount in USD: " & "%0A"
& "%20%20%20" & [Original Amount in USD] & "%0A%0A"

& "Credit Amount in USD: " & "%0A"
& "%20%20%20" & [Credit Amount in USD] & "%0A%0A"

& "Sold To Name and Number: " & "%0A"
& "%20%20%20" & urlencode([Sold To Name]) & "%0A"
& "%20%20%20" & [Sold To Number]& "%0A%0A"

& "Original Invoice Date: " & "%0A"
& "%20%20%20"  &urlencode([Invoice Issue Date]) & "%0A%0A"

& urlencode("Here's why I'm requesting the " & [Adjustment Type]) & ":"&"%0A%0A"
& "%20%20%20"  & urlencode([Reason for Credit/Debit or Rebill])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------