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://cdn.datatables.net/datetime/1.0.3/css/dataTables.dateTime.css" rel="stylesheet" type="text/css" />
<script src="https://cdn.datatables.net/datetime/1.0.3/js/dataTables.dateTime.js"></script>
​
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
      <table id="example" class="display nowrap" width="100%">
        <thead>
          <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office value</th>
            <th>Office label</th>
            <th>Start date</th>
            <th>Salary</th>
          </tr>
        </thead>
​
        <tfoot>
          <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office value</th>
            <th>Office label</th>
            <th>Start date</th>
            <th>Salary</th>
          </tr>
        </tfoot>
​
        <tbody>
          <tr id="1">
            <td>Tiger Nixon</td>
            <td>System Architect</td>
            <td>1</td>
            <td>Edinburgh</td>
            <td>2011/04/25</td>
            <td>$3,120</td>
          </tr>
          <tr id="2">
            <td>Garrett Winters</td>
            <td>Director</td>
            <td>1</td>
            <td>Edinburgh</td>
            <td>2011/07/25</td>
            <td>$5,300</td>
          </tr>
          <tr id="3">
            <td>Ashton Cox</td>
            <td>Technical Author</td>
            <td>2</td>
            <td>San Francisco</td>
            <td>2009/01/12</td>
            <td>$4,800</td>
          </tr>
          <tr id="4">
            <td>Cedric Kelly</td>
            <td>Javascript Developer</td>
            <td>1</td>
            <td>Edinburgh</td>
            <td>2012/03/29</td>
            <td>$3,600</td>
          </tr>
          <tr id="5">
            <td>Jenna Elliott</td>
            <td>Financial Controller</td>
            <td>2</td>
            <td>San Francisco</td>
            <td>2008/11/28</td>
            <td>$5,300</td>
          </tr>
          <tr id="6">
            <td>Brielle Williamson</td>
            <td>Integration Specialist</td>
            <td>3</td>
            <td>New York</td>
            <td>2012/12/02</td>
            <td>$4,525</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() {
  var editor = new $.fn.dataTable.Editor({
    table: "#example",
    fields: [
      {
        label: "Name:",
        name: "name"
      },
      {
        label: "Position:",
        name: "position"
      },
      {
        label: "Office:",
        name: "office_value",
        type: "select",
        options: [
          { label: "Edinburgh", value: 1 },
          { label: "San Francisco", value: 2 },
          { label: "New York", value: 3 }
        ]
      },
      {
        name: "office_label"
        //type: "hidden"
      },
      {
        label: "Start date:",
        name: "start_date",
        type: "datetime"
      },
      {
        label: "Salary:",
        name: "salary"
      }
    ]
  });
​
  editor.dependent("office_value", function() {
    var label = editor
      .field("office_value")
      .input()
      .find("option:selected")
      .text();
    editor.val("office_label", label);
    
    return {};
  });
​
  $("#example").DataTable({
    dom: "Bfrtip",
    columns: [
      { data: "name" },
      { data: "position" },
      {
        data: "office_value"
        //, visible: false
      },
      { data: "office_label" },
      { data: "start_date" },
      { data: "salary" }
    ],
    select: true,
    buttons: [
      { extend: "create", editor: editor },
      { extend: "edit", editor: editor },
      { extend: "remove", editor: editor }
    ]
  });
});
​
Output 300px

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

Dismiss x
public
Bin info
anonymouspro
0viewers