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://cdn.datatables.net/v/dt/jszip-3.10.1/dt-2.1.8/b-3.2.0/b-html5-3.2.0/datatables.min.css" rel="stylesheet">
 
<script src="https://cdn.datatables.net/v/dt/jszip-3.10.1/dt-2.1.8/b-3.2.0/b-html5-3.2.0/datatables.min.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</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>
            <td><input type="text" value="Tiger Nixon"/></td>
            <td><input type="text" value="Director"/>
             <select id="selActive" class="border-0 d-none">
                        <option value="Yes" selected="">Yes</option>
                        <option value="No">No</option>
                  </select>
             </td>
            <td><input type="text" value="Edinburgh"/></td>
            <td><input type="text" value="63"/></td>
            <td><input type="text" value="2011/07/25"/></td>
            <td><input type="text" value="$5,30"/></td>
          </tr>
           <tr>
            <td><input type="text" value="Garrett Winters"/></td>
            <td><input type="text" value="Accountant "/>
             <select id="selActive" class="border-0 d-none">
                        <option value="Yes" selected="">Yes</option>
                        <option value="No">No</option>
                  </select>
             </td>
            <td><input type="text" value="Edinburgh"/></td>
            <td><input type="text" value="63"/></td>
            <td><input type="text" value="2011/07/25"/></td>
            <td><input type="text" value="$5,30"/></td>
          </tr> <tr>
            <td><input type="text" value="Ashton Cox"/></td>
            <td><input type="text" value="Software Engineer"/>
             <select id="selActive" class="border-0 d-none">
                        <option value="Yes" selected="">Yes</option>
                        <option value="No">No</option>
                  </select>
             </td>
            <td><input type="text" value="Edinburgh"/></td>
            <td><input type="text" value="63"/></td>
            <td><input type="text" value="2011/07/25"/></td>
            <td><input type="text" value="$5,30"/></td>
          </tr> <tr>
            <td><input type="text" value="Cedric Kelly"/></td>
            <td><input type="text" value="Integration Specialist"/>
             <select id="selActive" class="border-0 d-none">
                        <option value="Yes" selected="">Yes</option>
                        <option value="No">No</option>
                  </select>
             </td>
            <td><input type="text" value="Edinburgh"/></td>
            <td><input type="text" value="63"/></td>
            <td><input type="text" value="2011/07/25"/></td>
            <td><input type="text" value="$5,30"/></td>
          </tr> <tr>
            <td><input type="text" value="Jenna Elliott"/></td>
            <td><input type="text" value="Senior Javascript Developer"/>
             <select id="selActive" class="border-0 d-none">
                        <option value="Yes" selected="">Yes</option>
                        <option value="No">No</option>
                  </select>
             </td>
            <td><input type="text" value="Edinburgh"/></td>
            <td><input type="text" value="63"/></td>
            <td><input type="text" value="2011/07/25"/></td>
            <td><input type="text" value="$5,30"/></td>
          </tr> <tr>
            <td><input type="text" value="Brielle Williamson"/></td>
            <td><input type="text" value="Sales Assistant"/>
             <select id="selActive" class="border-0 d-none">
                        <option value="Yes" selected="">Yes</option>
                        <option value="No">No</option>
                  </select>
             </td>
            <td><input type="text" value="Edinburgh"/></td>
            <td><input type="text" value="63"/></td>
            <td><input type="text" value="2011/07/25"/></td>
            <td><input type="text" value="$5,30"/></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 () {
  
  /* Create an array with the values of all the input boxes in a column */
  $.fn.dataTable.ext.order['dom-text'] = function  ( settings, col )
  {
    return this.api().column( col, {order:'index'} ).nodes().map( function ( td, i ) {
      return $('input', td).val();
    } );
  };
​
  var table = $('#example').DataTable({
    columnDefs: [
      {
        targets: [0, 1, 2],
        orderDataType: "dom-text", type: 'string',
      },
      {
        targets: 1,
        render: function (data, type, row) {
          if (type === 'filter') {
            // Set the orthogonal filter value to the text input value
            var val = $( data ).val();
            return val;
          }
          return data;
        }
      }
    ]
  });
  
  $( '#example' ).on( 'change', 'input', function () {
    //Get the cell of the input
    var cell = $(this).closest('td');
​
    //update the input value
    $(this).attr('value', $(this).val());
​
    //invalidate the DT cache
    table.cell($(cell)).invalidate().draw();
​
  } );
​
} );
Output 300px

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

Dismiss x
public
Bin info
anonymouspro
0viewers