November 2nd, 2014

Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Grid that behaves like MS Access Table Editor
New Member
Forum Posts: 1
Member Since:
sp_UserOfflineSmall Offline

Hello folks -

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:

Empty TableImage Enlarger

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

Image Enlarger

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:

Image Enlarger

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:

Image Enlarger

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?



Forum Timezone: Europe/Sofia

Most Users Ever Online: 496

Currently Online:
14 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam,

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information