Hello,
I would like to have only one product from each category.
There are two lit in stock but I want only the first one in the grid
Thx for helping
Yes,
This is the complete list and I would like a list of products, in stock, by Type (I know how to do it) and only one product by category.
I have 2 products in the category lit. I would like to filter the second product if the first product are in stock, the right type.
I hope I am clearer
So If I want a lit from chambre, the result will be Lit A
Thanks for the clarification. I still don’t understand everything you’re trying to do, but for now let’s focus on this individual task. Here’s how I set up my test. I used a checkbox field to represent your status lookup field, but it should still work the same. I also added a lot more examples just to make sure the process works with large quantities. I named this table [Main] for this test:
Over on the [Products] table, I first added two lookup fields, both using the links from the [Main] table. One looks up the stock status, the other looks up the {Product Position} value.
Jumping over to the [Categories] table, I added a rollup field named {Smallest In Stock}:
That gave me the position number of the smallest item that’s in stock:
Back in the [Products] table, I added a similarly-named rollup field to pull in that value, and compare it against each item’s position value. This will return a 1 where that product matches the lowest number, and a 0 for any product that doesn’t match.
Returning to the [Main] table, we can lookup that value, and use it in a view filter to control which item is displayed in each category.
I’ll leave the filter off, but you can see that if you applied a filter to only show records where {Display Filter} contains a 1, it will only show the first item.
If several items are out of stock, only the next one in line will display.
If I have multiple items in different categories, each category will show its lowest available item.
