Help with PDF Report. How to select data from referenced table

[Crystyano]

Hello Everyone.

I need some help to define a fórmula to extract data from a "child" table. Basically I am developing an Inventory App at Appsheet. I have the table 'Exits' and the table 'Exits Itens'. At the table 'Exits' I have recordes like [date] and [order number]. At the table 'Exits Itens', I have the collum [Exit] that is referenced to table 'Exits' and more columns like [Product] and [Quantity]. My problem is how to define a fórmula to select from the 'Exits' table what the user define at the table 'Exits Report' where we have the filter columns: FromDate, ToDate, Order Number, where Order Number comes from EnumList where the user can select multiple orders. Any help?

[Marc_Dillon]

https://help.appsheet.com/en/articles/961746-template-start-expressions

https://help.appsheet.com/en/articles/2357308-filter

[Crystyano]

Hello, Marc

Thanks in advance for you support, I am sure the link will be very usefulll. But I am "noob" yet at Appsheet, so if you or anyone else should give me more information, I really apreciate it. But, for that, I will try to be more specific, once I know I should give more information.

 "Everything" starts here, where I have this form from 'Itens_Saida_Filter', where the user can insert these data. After to save the form, I already have an automation to generate a PDF where the trigger is to save a new record, like the image below:

What I need with that is to create a PDF Report where I the user can filter by date and choose any 'saidas' (translating from portuguese was like "Go_Out" records) the user needs to. The tables Saida and  Itens_Saida are referenced. This report needs to show:

- All the records based at the period choosed

- All the products (The table Itens_Saida is referenced to the table 'Produtos' (translating: products) from the 'Saidas' the user selected.

- The quantity of products

- The products price. This info is recorded at the table 'Produtos'.

And that´s all! 😉

Here some screenshots from the tables:

  

With that I think It´s necessary some Select() at my PDF Template, but I am really lost how to do that. I´ve made some reports, but not with this complexity 😭

[Tommy62]

Schauen Sie sich dieses Erklärvideo an:Report Table [BUILD]