I am trying to build a date list in my PDF template, but I see only the oldest date for all the rows.
How could I solve?
Codice fiscale is my Key Column and
New Virtual Column is: REF_ROWS(“Totale cumulato su CF”, “Codice Fiscale”)
Try sort()
Hello @jaichith
I have tried with:
<<Start:Sort(Foglio1,[New Virtual Column])>><<[Codice Fiscale].[Data]>>
(Foglio1 is my data source)
but I have this error:
Error 1 : Task ‘Genera Attestato’ Body template. Expression ‘Sort(Foglio1,[New Virtual Column])’ is invalid due to: SORT has invalid inputs.
Error 2 : Task ‘Genera Attestato’ Body template. Start expression ‘Sort(Foglio1,[New Virtual Column])’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.
Error 3 : The document body is empty
Hello @jaichith
I have tried with:
<<Start:Sort(Foglio1,[New Virtual Column])>><<[Codice Fiscale].[Data]>>
(Foglio1 is my data source)
but I have this error:
Error 1 : Task ‘Genera Attestato’ Body template. Expression ‘Sort(Foglio1,[New Virtual Column])’ is invalid due to: SORT has invalid inputs.
Error 2 : Task ‘Genera Attestato’ Body template. Start expression ‘Sort(Foglio1,[New Virtual Column])’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.
Error 3 : The document body is empty
The “Codice Fiscale” is the Ref column name in the child table “Totale cumulato su CF”, but because of the deref [Codice Fiscale].[Data], you are actually reading the date value from the parent table. Without knowing your child table and its structure, I assume you should use just [Data] (if it’s the date column name) on your template.
And.. the SORT() doesn’t have anything to do with this.
1 Like
hello @AleksiAlkio ,
thabks for your reply.
This is my situation following your suggest,
but I have always the same day..
This is the structure of my Child Table
Would you please take a printscreen from your child table’s column structure from the editor.
https://youtu.be/7un-W1wNwuQ?feature=shared
Pls see this video you may get some idea.
It seems that you don’t have a Parent/Child table structure as you are trying to read the data from the same table. Also it’s missing because you don’t have the Ref field either.
So.. what is your goal actually? What is the PDF and the content you are trying to generate?
1 Like
Do you want to generate a PDF where you have the data from the whole table or part of it?
I would have the possibility to incorporate the table for each “CODICE FISCALE”,
so all the dates for that “CODICE FISCALE”
So.. you would like to have all the data, but grouped with the “Codice Fiscale”?
Yes, and each pdf (for CODICE FISCALE) must contains the table with all the dates of that CODICE FISCALE
So.. you don’t want to have all the data in your table to a separate PDF. You need one PDF for only one “Codice Fiscale”?
I would have the possibility to generate for all the CODICE FISCALE I have in the master table (Foglio1) the related PDF
Do you expect result like this ?
Check the video pls https://youtu.be/syc8TgbqZKM?feature=shared
One more thing, you have used the word " table " in the replies do you mean tabular column in PDF or Tables ( Gsheet ) in appsheet?