Microsoft Access has, for decades now, a table editor with a very coherent feel to it.  You add records, and it always provides a (New) record available of some kind.  This is the workflow I would like to reproduce with jqGrid, and I think it should be possible with very few changes.  I've gotten very close already, but need some help - and a jsFiddle? - to get it to come together.

Here is the workflow:

We start with an empty table:

Then, we click on the (New) record and add some data:

Now we have one row that's been inserted into the table, and a new '(New)' row that has appeared.

Let's add another row:

Again, there is always a (New) record that the user knows to click on to add a new row.

If we want to cancel an add:

We can edit it halfway, and then press escape.  Note the (New) record is present while editing the to-be-added record.  Pressing escape cancels the add, and removes the record we were working on:

[Image Can Not Be Found]

And now we are back down to just the two records we started with.

Obviously, this is something that will use inline editing, mouse triggers, and keyboard 'escape' to cancel.  Adding a new record, and then removing the new record on 'new' insertion and cancelling is the tricky part.

As an additional bit of detail, I would expect the new record to be saved when the user presses enter, and no serverside action to occur when the user presses cancel.  Edits of other fields should also result in serverside events (I, personally, use JSON).

Can someone help string the necessary parts of this together?

Cheers,

--G