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?
Solved! Go to Solution.
You need to use a deref expression something like..
<<[RefColumnName].[LabelColumnName]>>
You need to use a deref expression something like..
<<[RefColumnName].[LabelColumnName]>>
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.
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")
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |