Issue with .pdf template

AppSheet AppSheet Q&A
1

Parent Table: “Name List”

Child Table: “Loan Sheet”

Ref Column: “UID”

Column in Common: “UID”

Expression in PDF Template created as .html file

image
image691×194 25.5 KB

It is not getting the values properly. It mixes the different records. Sometimes shows the first record repeatedly.

Any piece of help is much appreciated.

2

Try UNIQUE([Related Loan Sheets]) instead of just [Related Loan Sheets].

2 Likes
3

Hey,

Hope you’re keeping well.

In AppSheet PDF templates, mixed or repeated child records usually happen when the <<Start>>/<<End>> expression isn’t properly scoped to the parent row. In your HTML template, make sure the child table loop references the parent’s key explicitly, for example:


<<Start: [Related Loan Sheet]>>
  <<[ColumnName]>>
<<End>>
```

If you’re using a `SELECT()` instead, filter it with `[_THISROW].[UID]` so only matching child rows are returned. Also confirm the Ref column is set correctly in the Data > Columns tab so AppSheet generates the reverse reference list automatically.

Thanks and regards,  
Taz
4

This response is improperly formatted and therefore difficult to read. Please reformat properly.