AnsweredAssumed Answered

Get value from last row in a portal to another field and auto update when changes were made to...

Question asked by TaukoririMeita on Aug 5, 2013
Latest reply on Aug 8, 2017 by philmodjunk

Title

Get value from last row in a portal to another field and auto update when changes were made to portal.

Post


     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.

     Thanks.

Snapshot.jpg

Outcomes