Copying across field values in a Template

[Wayne Richmond]

I've created a Template that I assumed would copy across a field value from a referenced table using the simple ${u_order_number.number} method but simply inserts '${u_order_number.number}' rather than the value. Is there a way to get field values onto a record using a template?.

[samiul1]

When you expand the available fields for that table, and the referenced fields, does it have the 'Number' field for that referenced 'Order Number' ?

Sample navigation to referenced fields within a specific table:

[Wayne Richmond]

Thanks Samiul but I think you're looking at a different table to me. I'm trying to achieve this using a standard Template (sys_template). I think you're on the Email Templates table there (sysevent_email_template).

[samiul1]

Hi Wayne,

Apologies, yes, I assumed you were inquiring about sysevent_email_template table.

In any case, have you tried using {u_order_number.u_number} instead of {u_order_number.number} ?

[Wayne Richmond]

I tried using one of the fields on the form rather than dot walking and it still didn't work. There doesn't seem to be this mechanism for standard templates.