I have a list that tracks the number of devices based on status by using a lookup "count" column. To this end, I know how many units I have left in inventory by the number of units with the "unassigned" status.
I would like to set up an alert that sends an email when the number of unassigned units is below a certain point, so that I know to reorder more.
I'm fairly new to SharePoint, so the farthest I got is:
If CurrentItem:Status equals Unassigned Calculate CurrentItem:Number of Units divided by 2 (Output to Variable: availableUnits )
(Units are paired, so I'm really interested in half of the value here.)
If Variable:availableUnits is less than 10 Email users
This appears to work great when I start the workflow manually, but I don't know how to make it start on its own. I have the "when an item is created" and "changed" options selected in addition to allowing the workflow to be manually started, but if I try changing device statuses in order to change that number, no email is sent.
I need this workflow to either run weekly, or to run every time the number of unassigned devices changes.