Excluding a calculated column when updating

App Building
1

Hi,
I need to update one or multiple database records and to do that, I'm using the Bulk Update from primary key and I'm setting {{tblOrders.recordUpdates}} in the Array of records to update

The issue is that I have a calculated column, so the update fails.

How can I exclude the column called Amount?

I played a bit with transformer but I'm a bit confused and couldn't sort it out.

2

Hi @nagar,

You can use Javascript inside of {{tblOrders.recordUpdates}} (instead of using a transformer) to remove any values. For example, you can use Lodash's _.omit to remove a specific column as described in this post