Multi selection on boleen column

I have a column in my database called approved (datatype tinyint basically 1 for approved 0 for not ,default is 0), the column on my table is editable and when I press save it runs the update SQL statement successfully .

is it possible to select multiple rows as approved and press the save button once and run the query for all the selected rows . I thought about storing the selections in an array then writing a js query that loops but the change set object only has the row index and nothings else .

Do you have a PK set for the table? If you so, it should show up in the changeset, which would enable you to run a bulk update by PK.

Set here:
image

Otherwise, you may need to enable this advanced setting under Interaction