Hi, for nested hash variables, you can refer to Hash Variable#NestedHashVariable for the correct formats.

Hi Anders,

Thank you for the direction.

I assume I should be using : #form.tableChild.field1[{form.tableParent.childId}]# to solve my problem

In main_table, column approval_status stores the latest id of main_apprv_comment.

And, remarks field remarks stores the remarks in main_apprv_comment table.

Therefore, I tried using the following code. But, the remarks seems to be empty in the email.

#form.main_apprv_comment.remarks[{form.main_table.approval_status}]#

*Note, in my approval form, there are 2 'remarks' field with same field id called 'remarks'... the first 'remarks' field is for approve case, the second 'remarks' field is for reject case. This is to handle the mandatory field as the remarks field is only mandatory for reject case.

Hi Friend, i think that you must reffer to a record on the TableChild (main_apprv_comment) using a unique Identifier. I will share my case with you i hope that it help you in someting: https://dev.joget.org/community/questions/29822682/using-html-to-get-fields-from-two-or-more-tables-or-trought-query-maded-on-datalists