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?
User | Count |
---|---|
15 | |
11 | |
9 | |
8 | |
4 |