Forum Discussion

SheriWoodward's avatar
SheriWoodward
Qrew Trainee
4 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 idea why?

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

& "Hello," & "%0A%0A"

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

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

& "Customer Error/Discretionary Credit" & "%0A"
& "%20%20%20" & [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" & [Sold To Name]& "%0A"
& "%20%20%20" & [Sold To Number]& "%0A%0A"

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

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

------------------------------
Sheri W
------------------------------
APIs and custom code

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 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
    ------------------------------