I want to group my data from Airtable. I am trying to make a public production plan, so that customers can see status of their order.
Each of these records in the attached screenshots are orders in the production plan. I want to group them for each production batch.
I tried to set up nested collections, so that the first Collection is the batch and the the second Collection is the order. But I can't find a way to only fetch the orders that is under each batch.
I am able to fetch all Orders under each Batch, and then hide the ones that do not have this Batch as a Airtable lookup field.
What is the smartest way to group collection items? Am I approaching it all wrong? Any help is appreciated 🙂
