Creating an editable table which can be updated I have a site with about 150 users. I am going to implement a system whereby things that they do in the real world (it's a fitness company), such as attending sessions, introducing new customers etc will earn them points.

I would like to create a table with 3 columns:

Name | Points | Update

so something like this:


The idea being that my client (editor role) could log in and amend the points that each user has and then click update to modify each row. I guess the table would be equally useful if there were just a single 'update' button at the bottom of the table to update all entries at once.

I don't know how I might go about making a table such as this 'editable', but would really appreciate some pointers as to how you might accomplish this. I would stress that I'm okay with using contributed modules, but quite poor with creating modules and PHP in general!
For your requirement Slickgrid is the best option for you and for that you need to use views module.


At the front end, users can show/hide, resize, reorder columns &amp;
resize the height of the grid. These settings will be stored per user
and used next time the grid is shown. Saving the view (via the usual
views UI) will reset these settings.

For every field defined in the view, you can set its column width, whether it's sortable, and formatters (how the cell data is displayed), an editor, a validator and filters (for filtering the column data).
This modules comes with the following plugins ready to use:

Editors:

Inline cell editor - for excel-like editing of text &amp; numeric data.
Popup field form - the field form pops up in an overlay. All field types can be edited.



Features of the grid:


Grouping field - group fields with a common value together
Collapsible taxonomy fields (tree structures)
Tabs - organise columns into tabs
Resize, reorder &amp; hide columns
Delete entities via the grid
Force fit columns (to fill the available column space)
Undo (undo previous changes - uses node revisions)
Set viewport height
Set row height
Add entities via the grid*
Clone entities*
Export data (via the views data export module)*
Multi edit/delete/clone/export (checkboxes will be displayed in the rows - select as many rows as you want to perform action against)***



or as  Pontus Nilsson said use this Editable Views module.