I'm hoping this is a stupid question with a simple answer.
I have built a system that functions fine except if somebody approves two list items in quick succession.
The process for each list item is:
- Lookup a number in another list ("Total")
- Then minus the number from this list item ("Record Value") from "Total" giving a "New Total"
- "New Total" is then set as "Total" in the other list ready for the next record.
However if two records are submitted in quick succession this happens:
|Record A||Record B|
|Pulls Total = 10||Pulls Total = 10|
|Minus Record Value = 5||Minus Record Value = 4|
|Total "10" Minus Record Value "5" = New Total "5"||Total "10" Minus Record Value "4" = New Total "6"|
|Total = 5||Total = 6|
It should be a Total of 1. What I want to do is pause or not start the workflow for Record B until the workflow for Record A has done its thing.
Any ideas would be greatly appreciated
Please let me know if I have missed out any information
Thanks in advance