File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
​
​
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
​
    <link href="https://nightly.datatables.net/buttons/css/buttons.dataTables.css?_=c6b24f8a56e04fcee6105a02f4027462.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/buttons/js/dataTables.buttons.js?_=c6b24f8a56e04fcee6105a02f4027462"></script>
​
    <link href="https://nightly.datatables.net/select/css/select.dataTables.css?_=9a6592f8d74f8f520ff7b22342fa1183.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/select/js/dataTables.select.js?_=9a6592f8d74f8f520ff7b22342fa1183"></script>
​
    <link href="https://editor.datatables.net/extensions/Editor/css/editor.dataTables.min.css" rel="stylesheet" type="text/css" />
<script src="https://editor.datatables.net/extensions/Editor/js/dataTables.editor.min.js"></script>
<link href="https://nightly.datatables.net/keytable/css/keyTable.dataTables.css?_=ad96c22f9d8971a682bb57b5b94f91ff.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/keytable/js/dataTables.keyTable.js?_=ad96c22f9d8971a682bb57b5b94f91ff"></script>
      
    <link href="https://nightly.datatables.net/autofill/css/autoFill.dataTables.css?_=bc3763029fa6dfaf4c947ef25f079107.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/autofill/js/dataTables.autoFill.js?_=bc3763029fa6dfaf4c947ef25f079107"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.22.2/moment.min.js"></script>
            <script src="https://cdn.datatables.net/plug-ins/1.10.19/dataRender/datetime.js"></script>
​
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
    <body>
    <div class="container">
 
      <table id="example" class="display" cellspacing="0" width="100%">
    <thead>
        <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Age</th>
            <th>Start date</th>
            <th>Salary</th>
        </tr>
    </thead>
    <tfoot>
        <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Age</th>
            <th>Start date</th>
            <th>Salary</th>
        </tr>
    </tfoot>
    <tbody>
        <tr id="1">
            <td>Tiger Nixon</td>
            <td>System Architect</td>
            <td>Edinburgh</td>
            <td>61</td>
            <td>2011/04/25</td>
            <td>$320,800</td>
        </tr>
        <tr id="2">
            <td>Garrett Winters</td>
            <td>Accountant</td>
            <td>Tokyo</td>
            <td>63</td>
            <td>2011/07/25</td>
            <td>$170,750</td>
        </tr>
        <tr id="3">
            <td>Ashton Cox</td>
            <td>Junior Technical Author</td>
            <td>San Francisco</td>
            <td>66</td>
            <td>2009/01/12</td>
            <td>$86,000</td>
        </tr>
        <tr id="4">
            <td>Cedric Kelly</td>
            <td>Senior Javascript Developer</td>
            <td>Edinburgh</td>
            <td>22</td>
            <td>2012/03/29</td>
            <td>$433,060</td>
        </tr>
    </tbody>
</table>
      
    </div>
  </body>
</html>
CSSSaved
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
JavaScriptSaved
 
$(document).ready(function() {
​
  //$.fn.dataTable.render.moment("M/D/YYYY");
  var editor = new $.fn.dataTable.Editor({
    table: "#example",
    fields: [{
        label: 'Name:',
        name: 'name'
      },
      {
        label: 'Position:',
        name: 'position'
      },
      {
        label: 'Office:',
        name: 'office'
      },
      {
        label: 'Age:',
        name: 'age'
      },
      {
        label: 'Start date:',
        name: 'start_date',
        type: 'datetime',
        format: 'YYYY/M/D'
      },
      {
        label: 'Salary:',
        name: 'salary'
      }
    ]
  });
​
  var table = $("#example").DataTable({
    dom: "Bfrtip",
    columns: [{
        data: 'name'
      },
      {
        data: 'position'
      },
      {
        data: 'office'
      },
      {
        data: 'age'
      },
      {
        data: 'start_date'
      },
      {
        data: 'salary'
      }
    ],
    select: true,
    keys: {
      editor: editor
    },
    buttons: [{
        extend: "create",
        editor: editor
      },
      {
        extend: "edit",
        editor: editor
      },
      {
        extend: "remove",
        editor: editor
      }
    ]
  });
​
  table.on('key-blur', function(e, dt, cell) {
    var ev = (window.event);
    var k = (ev) ? event.keyCode : e.keyCode;
    if (k === 9) {
​
      var indexes = table.rows({
        order: 'current'
      }).indexes();
      var lastRow = indexes[indexes.length - 1];
​
      if (lastRow === cell.index().row) {
        if (cell.index().column === table.columns().count() - 1) {
          console.log('Last Cell');
        }
      }
    }
  });
​
});
Output 300px

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers