How to Automatically Sort Orders and Trucks Based on Specific Parameters?

[fernet]

Hello AppSheet Community,

I am working on an app that involves two tables: one for orders and another for trucks. Each truck can be associated with one or more orders. I need help implementing a feature where a user can select multiple trucks and orders, and then AppSheet automatically sorts these based on specific parameters like destination or the truck's capacity.

Specifically, I would like to know how to set up the app so that once the trucks and their corresponding orders are selected by the user, they are sorted automatically. This sorting could be based on the destination address of the orders or the capacity of the selected trucks.

Any advice on how to configure this sorting mechanism within AppSheet would be greatly appreciated. Thank you!