6

I am trying to add a custom save button at the end of each row in handsontable. I am using handsontable package in laravel 4.

The button shows up like this:

enter image description here

<button>Save</button>
Alex
  • 8,461
  • 6
  • 37
  • 49
aps5842
  • 125
  • 1
  • 2
  • 10

4 Answers4

9

Try using htmlRenderer

Demo: http://docs.handsontable.com/0.19.0/demo-custom-renderers.html

var actionRenderer = function (instance, td, row, col, prop, value, cellProperties) {
  var $button = $('<button>');
  $button.html(value)
  $(td).empty().append($button); //empty is needed because you are rendering to an existing cell
};

var $container = $("#example1");
$container.handsontable({
  /*....*/
  columns: [
    /*....*/
    {data: "action", renderer: actionRenderer}
  ]
});

For better performance, the renderer could be written in pure JavaScript

Vyacheslav
  • 26,359
  • 19
  • 112
  • 194
warpech
  • 6,293
  • 4
  • 35
  • 36
4

I found an answer to my own question.. I used "renderer" in handsontable to render the cell into HTML

columns: [
                    {data: "unique_no"},
                    {data: "title"},
                    {data: "subject"},
                    {data: "year"},
                    {data: "duration"},
                    {data: "color"},
                    {data: "language"},
                    {data: "synopsis"},
                    {data: "director"},
                    {data: "basic_format"},
                    {data: "created_at"},
                    {data: "updated_at"},
                    {data: "action", renderer: "html",readOnly: true}

                  ],

This is where I found it http://handsontable.com/demo/renderers_html.html#dropdown

aps5842
  • 125
  • 1
  • 2
  • 10
2

you can simply do this custom renderer.

columns: [
    { data: 'basicFormat', renderer: 'text'},
    { data: 'createdAt', renderer: 'text'},
    { data: 'updatedAt', renderer: 'text'},
    { data: 'action', renderer: 'html'},    
]
Sagar
  • 4,473
  • 3
  • 32
  • 37
0
document.addEventListener("DOMContentLoaded", function() {

  var
    data = [{}, {},
      {
        title: createNew()
      }
    ],
    container1,
    hot1;
  
  container1 = document.getElementById('example1');
  hot1 = new Handsontable(container1, {
    data: data,
    colWidths: 220,
    colHeaders: true,
    columns: [
      {data: "title", renderer: "html"}
    ]
  });

  
 function createNew(){
    return "<div class='new'>button</div>"
 };

var button = document.querySelector('.new');
button.addEventListener('click', function(){
    alert('button')
})

});
alex89607
  • 444
  • 7
  • 12