How to group multiple orders lists into one 'picking list' with items summary

Hello everybody!
I'm developing an app to receive three orders weekly. I have 90% of the app ready, but I am not managing to generate a report containing a picking list that sums products of all order lists together. Any idea how to achieve this?

0 3 143
3 REPLIES 3

You want to generate some "Grouping" inside the report without needing an extra table?
You need to nest start: expressions.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/PAGE-BREAKS-IN-PDFS/m-p/460458/highlight/true#M...

Almost there! I need something like this:

ORDER  1:

QUANTITYPRODUCT
1PROD-A
4PROD-B
2PROD-C

ORDER 2:

QUANTITYPRODUCT
3PROD-A
5PROD-B
10PROD-C

I need to make this list:

PICKING LIST: (order 1 + order 2)

QUANTITYPRODUCT
4PROD-A
9PROD-B
12PROD-C

You can use as much groups as you want

Top Labels in this Space