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!

[erasmo]

Try to use the SORT command.

[erasmo]

Try to use the SORT command. Example: 

Column data type: List
Element type: Ref
SORT((REF_ROWS("GPs_Goods","Id_Ração"), No))

[fernet]

Apologies for my unclear explanation earlier. I have an "Orders" table containing all the necessary details:

1. ORDER ID
2. PALLET NUMBER
3. LOADING LOCATION
4. UNLOADING LOCATION
5. LOADING DATE AND TIME
6. UNLOADING DATE AND TIME

In the "Trucks" table, there's a list of license plates, for example, 20 plates corresponding to the trucks owned by the user.

Additionally, I created a third table where the user can manually select a truck from the "Trucks" table and one or more existing orders from the "Orders" table.

However, I would like to automate this process. I envision a feature where the user can simply click a button to choose which orders to associate with specific license plates. Once the orders and plates are selected, I would like AppSheet to automatically link the orders to the corresponding plates and then reorganize them based on the destination, unloading date and time, and truck capacity.

Do you think this is feasible on AppSheet? Should I use a script based on Google Maps API?

Thank you for your assistance.