Sort groups by first create date of record in group

[Nick_Wallace]

I’m trying to be able to sort my groups by the first created date/time of a record in that group.

Essentially, I am trying to create an order form, where the customer’s phone number is the primary field. Each item a customer orders will need to be its own record, and there might be multiple customer orders coming in from the form by different employees sometimes a few minutes apart, but each customers’ items would be fulfilled at the same time.

In my screenshot, I would need the 0433 order to come 2nd, as the the first item for them was placed before the first item for 0422 .

Any help would be greatly appreciated!

[kuovonne]

Welcome to the Airtable community!

Do you have a separate linked table for [Customers] (versus orders)? If not I recommend having one. Then you can use a rollup field in the [Customers] table that identifies the earliest order/item with the rollup formula MIN(values). Then you can send that earliest date/time back to all of the linked [Orders] with another rollup field {Earliest Order Time}.

You will also need to group by the {Earliest Order Time} field in to see the groups in the order you want.