How to incorporate ref rows in a doc template

[chiukim]

I have 2 tables:

1. Written Examination - applicant_no is the key column
2. appsheet_work_experience - appsheet_work_experience_id is the key column with [applicant_no] checked as part of table “Written Examination”.

Note : I have a data change both. That send an email when there is addition of data.

I want to achieve a table type of work experience. But with the formula above doesnt show anything.
Here is the result:

[Marc_Dillon]

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Email-Preview-shows-exactly-what-i-want-actual-emails-don-t/m-p/527370

[chiukim]

Thank you @Marc_Dillon

[chiukim]

Thank for the reminder @Marc_Dillon . but i want to clarify this statement number 5. Is composition action is like a group execute action? I already tried the steps but the automation did not send an email.

[Marc_Dillon]

Yes, “composite”=“grouped”.

You’re not using ORDERBY() correctly. Remove that and try with just [related…]