Hi Team,
Is it possible to add this to PHP Runner: Mass Updates.
What I mean is a button like "Mass Edit Selected" in the row with 'Add', 'Edit', etc buttons in the List View. Then it could work like this:
- the user selects several records, maybe by filtering, sorting, and selecting checkboxes
- the user clicks the "Mass Edit Selected" button
- a Modal Dialog pops up, containing all the fields which are present on the Edit page for that table. Maybe, the same modal dialog could be used which is already there for the Edit page for single records
- the user gives some or all fields a new value end clicks Save
- the script now saves these values for all selected rows, and the application navigates back to the List view.
For ASP Runner, this question was already asked (see: http://www.asprunner.com/forums/topic/17386-mass-update-on-list-view/), and the answer pointed towards the ASP Runner Manual with the suggestion to add a button which updates the selected rows. This solutions only works with a static new value ("sql = "Update employees set ReportsTo='Bob Smith' where KeyField=" & keys(i)(KeyField"). What would be really useful is to give the user the possibility to fill in the values to be stored.
I think this must be feasable, as there is already a Modal Dialog for the Edit page for single records. What needs to be done is to have a version that works for multiple keys (those selected in the List view) which is opened by the new "Mass Edit Selected" button.