<!DOCTYPE html>
<html>
  <head>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
    <script src="https://nightly.datatables.net/searchpanes/js/dataTables.searchPanes.js"></script>
    <script src="https://nightly.datatables.net/select/js/dataTables.select.js"></script>
    <link href="https://nightly.datatables.net/searchpanes/css/searchPanes.dataTables.css" rel="stylesheet" type="text/css" />
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <link href="https://nightly.datatables.net/select/css/select.dataTables.css" rel="stylesheet" type="text/css" />
    <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>Value</th>
            <th>Total</th>
          </tr>
        </thead>
        <tbody>
          <tr>
              <td>Tiger Nixon</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>61</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Garrett Winters</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>63</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Ashton Cox</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>66</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Cedric Kelly</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>22</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Jenna Elliott</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>33</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Brielle Williamson</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>61</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Herrod Chandler</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>59</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Rhona Davidson</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>55</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Colleen Hurst</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>39</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Sonya Frost</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>23</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Jena Gaines</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>30</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Quinn Flynn</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>22</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Charde Marshall</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>36</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Haley Kennedy</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>43</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Tatyana Fitzpatrick</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>19</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Michael Silva</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>66</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Paul Byrd</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>64</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Gloria Little</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>59</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Bradley Greer</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>41</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Dai Rios</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>35</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Jenette Caldwell</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>30</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Yuri Berry</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>40</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Caesar Vance</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>21</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Doris Wilder</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>23</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Angelica Ramos</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>36</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Gavin Joyce</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>42</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Jennifer Chang</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>28</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Brenden Wagner</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>18</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Ebony Grimes</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>48</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Russell Chavez</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>20</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Michelle House</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>37</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Suki Burks</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>53</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Prescott Bartlett</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>27</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Gavin Cortez</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>22</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Martena Mccray</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>46</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Unity Butler</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>47</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Howard Hatfield</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>51</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Hope Fuentes</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>41</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Vivian Harrell</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>62</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Timothy Mooney</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>37</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Jackson Bradshaw</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>65</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Miriam Weiss</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>64</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Bruno Nash</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>38</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Odessa Jackson</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>37</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Thor Walton</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>61</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Finn Camacho</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>47</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Elton Baldwin</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>64</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Zenaida Frank</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>63</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Zorita Serrano</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>56</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Jennifer Acosta</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>43</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Cara Stevens</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>46</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Hermione Butler</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>47</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Lael Greer</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>21</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Jonas Alexander</td>
              <td>Director</td>
              <td>San Francisco</td>
              <td>30</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Shad Decker</td>
              <td>System Architect</td>
              <td>San Francisco</td>
              <td>51</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Michael Bruce</td>
              <td>Director</td>
              <td>Edinburgh</td>
              <td>29</td>
              <td></td>
              <td></td>
          </tr>
          <tr>
              <td>Donna Snider</td>
              <td>System Architect</td>
              <td>Edinburgh</td>
              <td>27</td>
              <td></td>
              <td></td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
 
$(document).ready( function () { 
  var table = $('#example').DataTable({
    dom: 'PBfrtp',
    // CascadePanes true/false
    searchPanes:{
      cascadePanes: true,
    },
    columnDefs: [
      {
        render: function (data, type, row) {
          return '<input size="8" name="uservalue" type="number">';
        },
        target: 4
      },
      {
        searchPanes: {
          show: false
        },
        targets: [3]
      }
    ],
    rowCallback: function (row, data) {
      // Get input val of uservalue input
      var val = $('input[name="uservalue"]', row).val();
      // Set to 1 if undefined or blank
      if ( val === '' || val === undefined ) {
        val = null;
      }
      // Multiply by input cell (uservalue)
      var totalrow = data[3] * val;
      // Save in Total column
      $('td:eq(5)', row).html( totalrow.toLocaleString('en-US', {maximumFractionDigits:2}) );
    },
  });
  
  $('#example').on('change', 'input[name="uservalue"]', function () {
    table.draw('full-hold');
  });
  
} );
Output

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

Dismiss x
public
Bin info
anonymouspro
0viewers