- I have a list of “Month” with a “beginning amount” property, this property should match the “end amount” of the previous month (“end amount” is virtual, “beginning amount” is not).
- Each month has some element, and on element update, I have to update the current month’s “end amount” (already done automatically as it’s a virtual column).
- By now, you probably guess what’s the problem: each month superior to the current one should update their “beginning amount” to match the previous month’s “end amount”.
I tried a simple “update a set of rows”, but it seems to happen simultaneously, therefore results are wrong. I tried to create a bot, with a set of conditions which calls a second bot that does the same and repeats. But ended up with an error “Cycle detected in processes”.
I looked up some “tips and tricks” about loops, but they all seem overpowered for my needs.
Does anyone have an idea on how to handle this case? Thanks =)