[FEATURE] NocoDB - New or Modified Record source: Add Columns prop to track changes on specific columns

[LucBerge]

Is your feature request related to a problem? Please describe.
Sometimes the user is only interested in specific column updates. The user would want the source to emit event when values in those selected columns updates.

Describe the solution you'd like
We should add an optional prop Columns that allows the user to select columns in the table.

Do you have a workaround?
Filter actions

Comparable features in other tools?
I don't know

Additional context
On nocoDB, I have a table A link to table B (one-to-many) relation.
On pipedream, I have a workflow triggered on record modified in table A.
When I create a new record in table B and link it to a record in table A, the pipedream workflow is triggered. This was expected because record in table A is now liked to a new record in table B.

My problem is that the workflow does not use the column link to table B. It means my workflow is triggered for nothing. I want to ignore updates on a given field.

You cannot currently do it because what you save is the timestamp of the previous execution. While here, you need to know which column was updated. You could do it by saving the whole record and comparing it with the new one.

Similar implementation
#9688

Better implementation idea
Instead of saving the specific fields in your database to compare it, you can stringify all the fields and compute a hash of it. You store the hash instead of the data. It is safer and can take less memory depending on the field values