Get value from last row in a portal to another field and auto update when changes were made to portal.
So I have Two related tables. Table1 and Table2.
In Table1 I have field "LBalance" (A Calculation fiedl which based on this topic ??).
In Table2 I have a Portal with a field "Balance" (A Calculation field of other fields on the same Portal).
So I want to get whatever value in the last row of Balance to show up in LBalance. So I did a simple calculation of:
LBalance = Table2::Balance
Well that works for the first row, but then when a new row is created due to other calculations. The new value of Balance goes into the new row (last row), but the LBalance value stays the same from the first row.
How to make LBalance always get the value of Balance in the last row of the Portal and update itself automatically when new row is added to Balance?
check image below.