How to update database with a mapped computed value

[dru_nasty]

Thanks for that, i'm still really stuck on the fact this mapped value doesn't update my total column in real time. Only after running a save as query on the table and updating the database.
So it's still two issues: 1) Can't see mapped value updates in real time on the table after changing data. 2) The total column data isn't saved to the database.

{{ currentSourceRow.cost * (1 + (reconcileExpenses.changesetObject?.[i]?.markup ?? currentSourceRow.markup)) }}

I used an exact solution i found from this post, which shows it working in realtime:

Use User Input In Table In Part of Calculation Of Another Field

Hello! One other workaround here is to check the changesetObject of your table in the calculated value of your column. For instance, if the mapped value of Column A is {{ currentSourceRow.columnB * currentSourceRow.columnC }} you could do something like {{ currentSourceRow.columnB * (yourTable.changesetObject?.[i]?.columnC ?? currenSourceRow.columnC) }} [image] It can get messy with more complex calculations so you might also try using Preloaded JavaScript to define a function that accepts cur…