# Editable data grid

**URL:** <https://www.ruby-forum.com/t/editable-data-grid/72121>\
**Category:** Rails\
**Created:** [October 14, 2006, 3:00pm UTC](https://www.ruby-forum.com/t/editable-data-grid/72121 "2006-10-14T15:00:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![peterbe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/bc79bd/32.png) [@peterbe](https://www.ruby-forum.com/u/peterbe)\
**Post date:** [October 14, 2006, 3:00pm UTC](https://www.ruby-forum.com/t/editable-data-grid/72121/1 "2006-10-14T15:00:21Z")

</div>

Does anyone have a good recommendation for implementing an editable  
data grid (like a spreadsheet) based on a dbase table/model?

What I would like is something similar to Google Spreadsheets.

Thanks,  
Peter

---

<div class="post-metadata">

**Author:** ![peterbe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/bc79bd/32.png) [@peterbe](https://www.ruby-forum.com/u/peterbe)\
**Post date:** [January 29, 2007, 5:23am UTC](https://www.ruby-forum.com/t/editable-data-grid/72121/2 "2007-01-29T05:23:43Z")

</div>

Hi,

Can you please let us know if you were able to make an editable grid ?  
If yes, then please guide me how it can be done.

Thanks.

Peter Ensch wrote:

> Does anyone have a good recommendation for implementing an editable  
> data grid (like a spreadsheet) based on a dbase table/model?
> 
> What I would like is something similar to Google Spreadsheets.
> 
> Thanks,  
> Peter

---

<div class="post-metadata">

**Author:** ![peterbe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/bc79bd/32.png) [@peterbe](https://www.ruby-forum.com/u/peterbe)\
**Post date:** [January 29, 2007, 5:42am UTC](https://www.ruby-forum.com/t/editable-data-grid/72121/3 "2007-01-29T05:42:44Z")

</div>

Rm Rm wrote:

> Can you please let us know if you were able to make an editable grid ?

One might clone in\_place\_editor all over the page.

However, SQL has a notorious problem storing simple arrays, and  
in\_place\_editor inherits this. You can’t pass an index in, so you can’t  
run  
a whole bunch of them all over a page, each with a distinct record :id  
to  
hit.

I “solved” the problem by dumping the source of in\_place\_editor into my  
project, renaming it by adding \_indexed, passing an index in, and gluing  
it  
onto the end of the model.

–  
Phlip  
[Redirecting...](http://www.greencheese.us/ZeekLand) ← NOT a blog!!!

---

<div class="post-metadata">

**Author:** ![peterbe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/bc79bd/32.png) [@peterbe](https://www.ruby-forum.com/u/peterbe)\
**Post date:** [January 29, 2007, 6:28pm UTC](https://www.ruby-forum.com/t/editable-data-grid/72121/4 "2007-01-29T18:28:48Z")

</div>

I implemented this one months ago. Works fine.

> **[unspace.ca](http://unspace.ca/discover/datagrid)**
>
> This domain may be for sale!

---

<div class="post-metadata">

**Author:** ![peterbe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/bc79bd/32.png) [@peterbe](https://www.ruby-forum.com/u/peterbe)\
**Post date:** [January 29, 2007, 3:23pm UTC](https://www.ruby-forum.com/t/editable-data-grid/72121/5 "2007-01-29T15:23:28Z")

</div>

try this great grid:  
[http://www.jackslocum.com/blog/2006/09/10/adding-built-in-editing-](http://www.jackslocum.com/blog/2006/09/10/adding-built-in-editing-)  
support-to-the-yahoo-ui-extensions-grid/

passing and storing data with xml builder works fine.

hth