Fix reference column to export to PDF

AppSheet AppSheet Q&A
1

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?

1000216569.jpg
1000216569.jpg1080×2340 162 KB

1000216570.jpg
1000216570.jpg1080×2340 122 KB

1000216571.jpg
1000216571.jpg1080×2340 75.9 KB

2

You need to use a deref expression something like..

<<[RefColumnName].[LabelColumnName]>>

1 Like
3

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.

4

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

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

1 Like