Hello
Is there an option to make a custom column with calculation based on other columns data, with the temporary value that is currently input? (similar to excel)
I know I can set calculation in columns that will work with the data loaded in the table. But, I'm looking for solution that will change the calculated value when changing any cell's data that is part of the calculation, even without saving the change to the DB.
Hey @MJ23!
You can reference the table's changeSetObject in any calculations you use in the custom column. If you write {{ yourTable.changeSetObject[i]?.yourColumn ?? currentSourceRow.yourColumn }} that should give you the updated value of that cell:
Depending on the complexity of the calculations you need to do, and how many rows you have, it might be good split things out into an indexed transformer or temporary state. Would love to hear more about your use case!