how to add filtered inline table in PDF

[iffis76]

Hi,

I managed to generate PDF file using bot, now my issue is I'm not able to to include filtered inline table in PDF.
Its kind of invoice, I have customer table and sales table
In filtered form selecting Customer Name, Start Date and End Date
which fatch data from sales table for the give customer name and all related sale records (date wise)
I can see correct data in filtered inline table but can not find a way to add these table into PDF. PDF file (invoice) should all sale records (per line) for the given details (customer name, start data and end date)
any idea if it is possible and if yes, how i can achieve this?

[AleksiAlkio]

Yes it's possible using Start: & End expression. The first question is.. from which table are you triggering this Bot? Is it triggered just from a "Filter" table?

[iffis76]

Hi Aleksi

Yes from filtered table, and capturing result in virtual column in same filtered table, which showing at bottom of form, this is what i want to include in PDF

[AleksiAlkio]

If I understood your case, the expressions should be something like..

<<Start: SELECT(SalesRecords[KeyColumn],IN([KeyColumn],[_THISROW].[Matching Milk Sale]))>>

[iffis76]

Still can not figure out, btw if I dont use any expression I can get record's keys in PDF from filtered inline table (records shown in my previous screenshot)

this is what I want to translate as row with their details

In my filtered table this is the virtual column I have with expression

When i tried your given expression bot give me this error

[AleksiAlkio · Accepted solution]

First.. you need to read the rows from the original table like
<<Start: Milk Sale[Key],IN([Key],[_THISROW].[Matching Milk Sale]))>> and when using the Start: expression, you need to end it with <<End>>. That's missing from your template.

Please check this arcticle..
https://support.google.com/appsheet/answer/11541779?hl=en&sjid=3931983941697489635-EU

[iffis76]

Many thanks Aleksi for your valuable suggestion and guiding me in right direction. it helped me to achieve my desire result.

@AleksiAlkio 

[AleksiAlkio]

Good to hear!

[AlexM]

What Aleksi gave you needs to be in the template (Word or Google Doc) and you also need to  have the  << and the >>