Inventory Reorder List

[aremey]

I am trying to build an inventory management app that allows us to track raw good inventory and gain visibility into timing around reordering. I want a reorder tab that only shows items from the main inventory list if the qty is lower than X. Any help would be appreciated. 

My two existing data sets are Inventory (contains inventory levels) and Reorder (only want inventory with qty lower than X).

[TeeSee1 · Accepted solution]

If you simply want to see a list of materials whose inventory qty is below a certain value, I either

1) create a slice of the Inventory table with a row filtering condtion [qty] < reorder level

https://help.appsheet.com/en/articles/895302-slices-the-essentials

2) create an action with LINKTOFILTEREDVIEW and set the filter condition to [qty] < reorder level

https://help.appsheet.com/en/articles/2357260-linktofilteredview

[aremey]

Thanks so much for the help - I created a slice with some filters and it worked beautifully.