Referral's (affilate) name on e-mail template - How?

[edercoll]

Hi,

 

I have learned that it is possible to pull a custom field value into an email template.

How about the client's referral's name, as all orders placed in my instance of WHMCS have a referral.

 

As I understand I'd need to query for the name of the referral before retrieving and displaying it in a template.

 

Is that correct? and if that is so, how do I go about to do that?

As Im not a coder, If the solution requires coding knowledge, I'd appreciate if someone could charge me a fee in order to implement it for me.

 

Thanks!

 

Eder