How to add a field from another table in notification

[hongsok]

Dear all,

I am working on the email notification on the table name "Assessment Instance [asmt_assessment_instance].

I would like to add a field call "business_case" form another table name "dmn_demand]

I tried to use the following email script but it is not working.

var gr = new GlideRecord("dmn_demand.business_case");

gr.get(current.trigger_id);

template.print("business_case");

I have tried to add the following to the notification message and it's not working as well

Business case: ${dmn_demand.business_case}

I would appreciate your help.

[Brian Lancaster]

You glide record should only have the table name in it.  So it should just be var gr = new GlideRecord("dmn_demand");  That is the first thing I notice.

[hongsok]

Hi Brian,

I did but not working.

See the following pictures.

[Brian Lancaster]

Was the record from dmn_demand what triggered the assessment?

[hongsok]

Hi Brian,

Yes. The connection between this two table is the field call "trigger_id" and the trigger_id is value is the same as Demand number.

Regards,

Hong