I have an inventory app where once a product stock level gets to a certain number (Different for all products) I want to display it on a list to reorder.
How I currently have collection set up is it is a products collection and there is a number value for the current stock level and a number value for the minimum stock level.
On the list, what I saw in my mind was a list of products where the products stock level was less than or equal to the minimum stock level.
Apparently you cannot compare two different sections of the same entry.
you are right, you can’t use a comparison between a single product’s properties as a list filter. But there is a simple workaround; make a custom list of all product. group each row’s content and add a visibility rule on the group to show only when this product’s current stock level <= this product’s min stock level.
