Action on group of rows

[Igor_XH]

Hello, all
I am new to AppSheet so sorry if my question is trivial
I am working on an application that processes orders. Each order contains multiple items
Up to this point all is well.
I need to issue invoices to customers depending on the terms of the contract: someone for each order, someone once a week, someone once a month
Now I do it manually: Order has a Ref field Invoice
I want to create an action that will iterate through all orders, select all unbilled orders that meet a billing condition (e.g. weekly), group by customers, and bill each Customer
Or as an option - select all the unbilled orders for specific customer and make one bill for them
Can I ask for recommendations on how to build a solution?
How to loop through all orders? Or maybe through all Customers?

[Suvrutt_Gurjar]

You may want to take a look at the below sample app. It has similar structure that you are looking for and creates a single report for each customer for open orders. You will of course need to adjust the concepts to match your needs.

AppSheet

AppSheet : mobile apps from spreadsheets : Template: Other for the industry

This app can be used to manage customers, products, and orders. The app user can: - Create and edit a customer list. - Create and edit a product list. - Create orders associated with a customer. Orders can have three statuses: Open, Complete,...