I’m struggling with some workflow, didn’t find out how to solve it.
I would like to update a column value in an inventory list, depending on its status, which is calculated from another table.
I have a table1 : “Inventory”
==> initial stock
==> restock level
==> real “date since restock needed”
==> virtual “restock needed”
And a table2 : “Line Item” with material inputs and outputs
On the inventory list, I set a “restock level”, so that if an output causes the current stock to drop below a certain level, I set the virtual column “restock needed” to True.
It’s basically a sum : initial stock, minus output, plus inputs ==> if thats sums<restock level ==> True
I would like to get the datetime for this event.
Here is what I think about :
- create a workflow:
==>based on “Line Item”
==> all_changes trigger
==> condition : Here is my issue.
I’m aware this is not correct, but here where I need your help: I would like something like that:
AND([_THISROW_BEFORE].“Inventory”[Restock Needed]<>[_THISROW_AFTER].“Inventory”[Restock Needed];
==>do this : action “set current product restock need date to NOW()”
(normally OK with this part)
I tried to make a workflow based on the Inventory Table, so that if “Restock Needed” switches to “true” then I set current datetime. But because it’s a calculation, I guess the change of result of it is not considered as an update, which eventually does not do anything.
Many thanks in advance for your help