I have a table to follow cash transactions and balances for a few places.
Each row has an open balance ( with a sum( select()) formula) , daily transactions , and closing balance.
Depostis are handled in another table , with a bot ,which triggers an actions to update the relevant row on cash table with the deposit and the rows after the date which balnces should be affected.
However , when runing the bot , open balances , will only get updated for the first row, unless runing the bot more than once. This probably happnes becuase the previous row hasnt been updated on time to affect the open balnce of the next row.
The action im runing is excecute an action on a set of rows , which triggers update coolums in this row , which updates it , and app formulas start to work.
However , if i enter a deposit for an old date , all the newer rows will not get updated , unless i run the bot , as the amount of days that have passed.
anytone has better suggestion for this mechanism ?