Fix reference column to export to PDF

[Draculam]

Hello. I need help composing a PDF document.

 1- I am exporting customer purchase data to PDF, in this we have the customer's general data and a table. This table contains the name of the purchase, date of purchase, value and supplier;

 2 - The supplier is a reference to another table, which has a Label currently appearing in the application, but when I export it to PDF the ID appears, not the Label.

 How do I correctly export Supplier Labels to the PDF table?

 

  

[AleksiAlkio · Accepted solution]

You need to use a deref expression something like..

<<[RefColumnName].[LabelColumnName]>>

[Draculam]

Is there somewhere I can learn about? Is there a way to format the data in a specific way? For example: changing the date from MM/DD to DD/MM.

[AleksiAlkio]

Start learnig from here.. https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,&sjid=...

For the date, you can use TEXT([Date],"dd/mm")