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) }}

It can get messy with more complex calculations so you might also try using Preloaded JavaScript to define a function that accepts currentSourceRow and yourTable.changesetObject?.[i] as parameters if need be!


changeset_in_custom_column (2).json

1 Like