I have a simple inventory app with 2 tables: “Items” and “Inventory.”
My “Items” table contains the individual items we carry while the “Inventory” table contains all the inventory transactions (sign out, returns, etc.)
In my “Inventory” table I have a virtual column called [Current Amount] that calculates current inventory levels via a SUM(Select) expression.
In my “Items” table I have a number column called [Restock Alert] for every item we carry. This number is intended to act as a trigger to notify us when it’s time to reorder an item.
I know how to create the workflow but I can’t figure out the correct expression to trigger the text alert. I’ve tried several SELECT() expressions but can’t crack it. Any guidance is greatly appreciated!