We are exploring ways to perform batch operations on multiple selected rows in tables that we display in our forms.
In the screenshot, a form displays a view containing a list of "observations". We want to be able to select one or more rows and then click a button once to perform an operation such as deleting or duplicating those rows. Ideally, there would be a widget to display checkboxes next to each row, as I've mocked up in the screenshot. In this example, clicking the "Delete checked" button would execute an SQL statement that would accept the "Observation ID" (primary key) values of the checked items (rows 2 and 4) and perform the desired operation on those records.
Is there a way to do this with the currently available widgets? If not, is it feasible to request this as a new feature? Our current workaround is to add a boolean column in the table which users can change to "true" for any rows they want to delete, but it's preferable to not add extra fields to the database just for UI purposes.