<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');
});
} );
You can jump to the latest bin by adding /latest
to your URL
Shortcut | Action |
---|---|
ctrl + [num] | Toggle nth panel |
ctrl + 0 | Close focused panel |
ctrl + enter | Re-render output. If console visible: run JS in console |
Ctrl + l | Clear the console |
ctrl + / | Toggle comment on selected lines |
ctrl + [ | Indents selected lines |
ctrl + ] | Unindents selected lines |
tab | Code complete & Emmet expand |
ctrl + s | Save & lock current Bin from further changes |
ctrl + shift + s | Clone Bin |
ctrl + y | Archive Bin |
Complete list of JS Bin shortcuts |
URL | Action |
---|---|
/ | Show the full rendered output. This content will update in real time as it's updated from the /edit url. |
/edit | Edit the current bin |
/watch | Follow a Code Casting session |
/embed | Create an embeddable version of the bin |
/latest | Load the very latest bin (/latest goes in place of the revision) |
/[username]/last | View the last edited bin for this user |
/[username]/last/edit | Edit the last edited bin for this user |
/[username]/last/watch | Follow the Code Casting session for the latest bin for this user |
/quiet | Remove analytics and edit button from rendered output |
.js | Load only the JavaScript for a bin |
.css | Load only the CSS for a bin |
Except for username prefixed urls, the url may start with http://jsbin.com/abc and the url fragments can be added to the url to view it differently. |