Solved

Report Rule building email text

  • 22 February 2021
  • 5 replies
  • 204 views
P
Rank
Userlevel 3
Badge +6

We have a report rule that emails invoices to customers.  I want to include a web address that includes the invoice number and invoice amount.  An example below where CD1234 is the invoice number and 200 is the invoice amount.  I am using variables for these values.  My problem is when I try to build the below string the = and & characters are a problem.   It does not include anything after a = or & character.  I have tried wrapping it with single and double quotes with no luck.  Any suggestions?

  https://www.xxx.com/invoice/?invoice_number=CD1234&amount=200

App8sp1+

icon

Best answer by dhlelk 25 February 2021, 18:15

View original
This topic has been closed for comments

5 replies

dhlelk
Rank
Userlevel 6
Badge +15

Hi @pshields,

Did you try using the encoded URL?
ex: https%3A%2F%2Fwww.google.com%2Finvoice%2F%3Finvoice_number%3DCD1234%26amount%3D200

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/
P
Rank
Userlevel 3
Badge +6

It did not translate I get the below in the email

https%3A%2F%2Fwww.google.com%2Finvoice%2F%3Finvoice_number%3DCD1234%26amount%3D200

dhlelk
Rank
Userlevel 6
Badge +15

Hi @pshields,

It does not include anything after a = or & character.

Based on your above statement, could you try the below URL which has only '=' and '&' characters encoded,
https://www.google.com/invoice/?invoice_number%3DCD1234%26amount%3D200

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/
P
Rank
Userlevel 3
Badge +6

The text https://www.google.com/invoice/?invoice_number%3DCD1234%26amount%3D200

in a report rule action results in an email that looks exactly like this.  However, I noticed that when I hold my cursor over the link it shows the & and = sign.  If I use a real web address in the email that contains an = sign in the address, when I click on the link, even though it has %3D in the address, the link is read correctly and the page opens as expected.  Thanks for the help.

Phil

dhlelk
Rank
Userlevel 6
Badge +15

The text https://www.google.com/invoice/?invoice_number%3DCD1234%26amount%3D200

in a report rule action results in an email that looks exactly like this.  However, I noticed that when I hold my cursor over the link it shows the & and = sign.  If I use a real web address in the email that contains an = sign in the address, when I click on the link, even though it has %3D in the address, the link is read correctly and the page opens as expected.  Thanks for the help.

Phil

Hi @pshields,

You are welcome and I'm happy to help 😊

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/
Terms & ConditionsCookie settings