- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 21, 2021 05:25 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 21, 2021 05:37 PM
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.