Problem: Data from a referenced table in PDF is not displayed.

[UI_Zephyr]

I have 2 sheets in spreadsheets as databases they are 2 small databases and I have in one sheet a column called ID_REF that refers to the other table, in the spreadsheets the new records do appear but when I want to see them in the pdf the data from the referenced table is not visible.

[WillowMobileSys]

---

@UI_Zephyr wrote:

when I want to see them in the pdf the data from the referenced table is not visible.

---

First, make sure that you are storing in the Ref column the row key for the row in that other table that is being referenced.  Think of a Ref column as a "pointer" to a specific row via that key.  Look in your sheets and make certain that the Ref column does indeed have row key valued from the referenced table.

Once that is confirmed, then to show Ref data you have to implement something in the PDF template to access that Ref data.  For instance, you can access each column using "dot" notation like so:   [Ref Column].[Column 1], [Ref Column].[Column 2], [Ref Column].[Column 3], etc - where the Column 1, 2 and 3 are names of specific columns in that referenced table.

If this isn't helping then please show us how you have your Ref column configured AND how you are attempting to use it in the template for more assistance!!

I hope this helps!