Hello everyone.
I am using this formula on a Google Doc template for my PDF generation Workflow:
SELECT(Listas de asistencia[Nombre],and([_thisrow].[Fecha asamblea]=[Fecha asamblea],[Asistencia]=โasistenciaโ))
Which works perfectly and brings back these results in the PDF file:
What Im trying to do is to present these into a table so they can sign next to their nameโฆ
Iยดve tried
<<start: SELECT(Listas de asistencia[Nombre],and([_thisrow].[Fecha asamblea]=[Fecha asamblea],[Asistencia]=โasistenciaโ))>>
<<[End]>>
But this didnยดt work. The PDF is not generated. So I went into the Workflow Log and found this error:
(the SELECT expression) 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.
Im kind of stuck here, I dont understand why the expression works fine without the โstartโ function, and it doesnt when I try the enlist the results.
I also tried creating a Virtual column with the same SELECT formula, and added <<[VCName]>> to the Template. The test results of the formula for the VC are correct, but when the PDF is generated I just get blank spaces and commas (separators):
Solved! Go to Solution.
The SELECT() expression used in a <<Start>>
tag must produce a list of key column values; if it produces a list of anything else, it wonโt work. Really, FILTER() is a better choice than SELECT(), as thereโs no way to get the wrong values using FILTER().
Try this:
<<start: FILTER("Listas de asistencia",and([_thisrow].[Fecha asamblea]=[Fecha asamblea],[Asistencia]=โasistenciaโ))>><<[Nombre]>>
<<[End]>>
The SELECT() expression used in a <<Start>>
tag must produce a list of key column values; if it produces a list of anything else, it wonโt work. Really, FILTER() is a better choice than SELECT(), as thereโs no way to get the wrong values using FILTER().
Try this:
<<start: FILTER("Listas de asistencia",and([_thisrow].[Fecha asamblea]=[Fecha asamblea],[Asistencia]=โasistenciaโ))>><<[Nombre]>>
<<[End]>>
Thanks @Steve! Once more you nailed it!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |