File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
        <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <link rel="stylesheet" type="text/css" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.4/css/buttons.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.2.7/css/select.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/fixedheader/3.1.5/css/fixedHeader.dataTables.min.css">
​
    <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 type="text/javascript" src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.5.4/js/dataTables.buttons.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/select/1.2.7/js/dataTables.select.min.js"></script>
    
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
    <body>
    <div class="container">
      <table id="studentsTab" class="display nowrap">
        <thead>
          <tr>
            <th>TestStudent ID</th>
            <th>Student ID</th>
            <th>Student Name</th>
            <th>Absent</th>
            <th>Gender</th>
            <th>Grade</th>
            <th>Accom</th>
            <th>Test Date</th>
            <th>S#</th>
            <th>Room</th>
            <th>Barcode</th>
            <th>Booklet</th>
          </tr>
        </thead>
      </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 formattedString = {
        "d": [{ "TestStudentID": "15534", "StudentID": "432009", "StudentName": "BALBOA, CASSIDY PAOLA", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15542", "StudentID": "432356", "StudentName": "BARROW, IVANA FAYTHE", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15543", "StudentID": "432388", "StudentName": "BLEDSOE, RONIN EARL", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15591", "StudentID": "435096", "StudentName": "BORDELON, JACEE RAIN", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15590", "StudentID": "435072", "StudentName": "BRIDGES, DELSIN JERROD", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15552", "StudentID": "432926", "StudentName": "BRINKLEY, EDGAR MILES", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15606", "StudentID": "436094", "StudentName": "BUCHANAN, CHAD CARAMON", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15548", "StudentID": "432607", "StudentName": "BURKEL, LILLIAN MARGOT", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15525", "StudentID": "431770", "StudentName": "BYRAM, ADRIAN ERIK", "Absent": "True", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15563", "StudentID": "433570", "StudentName": "CALDWELL, TAMARA DEAVION", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15545", "StudentID": "432557", "StudentName": "CLOWERS, MYKEIL ASH", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15533", "StudentID": "432002", "StudentName": "COKER, CORBIN JAMES-CLEMENT", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15531", "StudentID": "431935", "StudentName": "COLLINS, KAELYN REANNA", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15565", "StudentID": "433599", "StudentName": "DIAMOND, JACK JUDE", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15536", "StudentID": "432156", "StudentName": "ECKMAN, EZABEILA CLOER", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15532", "StudentID": "431987", "StudentName": "ENRIQUEZ, LEYLA ELSA", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15592", "StudentID": "435134", "StudentName": "FAABORG, BLADE VINSON", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15540", "StudentID": "432292", "StudentName": "GRAVES, TYLOR MATHEW", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15593", "StudentID": "435221", "StudentName": "GRIMES, MATHIEU JESUS", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15539", "StudentID": "432271", "StudentName": "GROSSMAN, ALEXUS BROOKE", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15580", "StudentID": "434625", "StudentName": "GUTIERREZ, ZACHARIAH JASON", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15572", "StudentID": "433983", "StudentName": "GUTIERREZ-SILVIA, KALAVATI GABRIELLA ANN", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15566", "StudentID": "433686", "StudentName": "HERNANDEZ ZUNIGA, CECILLIA LUCILLE", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15582", "StudentID": "434789", "StudentName": "HICKMAN, DANICA ORTIZ", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15530", "StudentID": "431925", "StudentName": "HIGGINS, GUY SHAWNN", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15594", "StudentID": "435232", "StudentName": "HOLEMAN, ALLIE CITHALLI", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15585", "StudentID": "434943", "StudentName": "HOLLY, HUDSON BRIAN", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15586", "StudentID": "435007", "StudentName": "HORNE, WYATT MAYTOLON", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15588", "StudentID": "435021", "StudentName": "HUNT, COLBY JOSIAH", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15589", "StudentID": "435050", "StudentName": "HUTT, LYNDSEY MICHEL", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15553", "StudentID": "433015", "StudentName": "HYDE, JULIET CARMELLA", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15581", "StudentID": "434729", "StudentName": "LAMAR, XZAVIOR HARRIS", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15584", "StudentID": "434803", "StudentName": "LANDIN, NATHAN ANGEL SEBASTIAN", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15557", "StudentID": "433310", "StudentName": "LANDRUM, JUAN WESLEY", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15569", "StudentID": "433803", "StudentName": "LAVAN, KARLEIGH AZUEENA", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15576", "StudentID": "434405", "StudentName": "LEE, CHLOEE SELINA", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15549", "StudentID": "432618", "StudentName": "LEE, SUSANA SHAE", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15560", "StudentID": "433438", "StudentName": "LLOYD, CARSIN CAROL", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15528", "StudentID": "431803", "StudentName": "LYDEN, CHRISTERFER AIDEN MIKKEL", "Absent": "True", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15554", "StudentID": "433105", "StudentName": "MARCOTT, BASANTA BRANCE", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15544", "StudentID": "432472", "StudentName": "MAREZ, MADELYNN GRAYSON", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15577", "StudentID": "434414", "StudentName": "MCDANIEL, CELINA ANDREA", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15597", "StudentID": "435371", "StudentName": "MCDOWELL, BETZAY MARIAH", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15570", "StudentID": "433807", "StudentName": "MCMULLEN, JULIET AUSTYN", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15600", "StudentID": "435532", "StudentName": "MELENDEZ, MEADOW CITHALLI", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15573", "StudentID": "434238", "StudentName": "MERCER, RYLEI SAMANTHA", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15605", "StudentID": "435969", "StudentName": "MUSSER, KHUE JACKELINE", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15564", "StudentID": "433575", "StudentName": "NEUMAN, BAYLEIGH PHEYDORAH", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15537", "StudentID": "432170", "StudentName": "OZUNA, NEYDA BRIDGET", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15587", "StudentID": "435013", "StudentName": "PANDEY, MARISSA OVALLA RAE", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15551", "StudentID": "432898", "StudentName": "PEREZ, KATIE NACOLE", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15538", "StudentID": "432190", "StudentName": "PIGG, DYLAN BENTON", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15561", "StudentID": "433450", "StudentName": "POLLARD, HOLLAND KORD", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15575", "StudentID": "434402", "StudentName": "PURSELLEY, CIARA LANAE", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15601", "StudentID": "435608", "StudentName": "QUINTANA, DANICA BAYLEY", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15602", "StudentID": "435638", "StudentName": "RASMUSSEN, CLAUDIO BRIAN", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15574", "StudentID": "434252", "StudentName": "RIPPETOE, BRILEY HENRY", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15550", "StudentID": "432621", "StudentName": "ROBINSON, ARIANA HAAG", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15567", "StudentID": "433738", "StudentName": "ROBLES, REBECCA ROSE", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15559", "StudentID": "433381", "StudentName": "ROOKS, BREE KATHRYN", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15598", "StudentID": "435447", "StudentName": "SABEK, KRISTA SUE", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15568", "StudentID": "433775", "StudentName": "SANCHEZ LOPEZ, DYLAN RAINE", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15562", "StudentID": "433528", "StudentName": "SANCHEZ, JAYTON KRAIG", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15546", "StudentID": "432580", "StudentName": "SAUNDERS, OMAR KAY", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15596", "StudentID": "435309", "StudentName": "SEAGO, ISABELLA DAONNA", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15579", "StudentID": "434590", "StudentName": "SEVERN, ALISSA RAYDEAN", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15556", "StudentID": "433258", "StudentName": "SHOOK, BRIANNE SHERREE", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15529", "StudentID": "431843", "StudentName": "SOMMERFELD, XAYNE DEYANIRA", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15571", "StudentID": "433921", "StudentName": "SWICK, CARSYN ALLYSON", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15541", "StudentID": "432323", "StudentName": "TATE, SAYLOR AUBREY", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15603", "StudentID": "435708", "StudentName": "TAYLOR, FABRIZIO JACOB-BOYD", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15535", "StudentID": "432031", "StudentName": "TOVAR HERNANDEZ, ANSON DRAKE", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15595", "StudentID": "435307", "StudentName": "VANN, LAYNE BROOKS", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15547", "StudentID": "432601", "StudentName": "VIELMA MORENO, MCKALYN ALEENIA", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15558", "StudentID": "433355", "StudentName": "WALLS, ARIEL CEDES", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15583", "StudentID": "434799", "StudentName": "WHITMER, NICKOLAS KADEN", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15599", "StudentID": "435505", "StudentName": "WINCHESTER, GLORIA CAROL", "Absent": "False", "Gender": "F", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15578", "StudentID": "434579", "StudentName": "WORTHINGTON, ARON EZEKIEL", "Absent": "False", "Gender": "M", "Grade": 11, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15555", "StudentID": "433163", "StudentName": "YATES, MACIE CARLISLE", "Absent": "False", "Gender": "F", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }, { "TestStudentID": "15604", "StudentID": "435768", "StudentName": "YEATS, ETHANE MACKENZIE", "Absent": "False", "Gender": "M", "Grade": 10, "Accommodation": "False", "TestDate": "", "SessionNumber": null, "Room": "", "Barcode": "", "Booklet": "" }]
    };
​
​
    var table = $('#studentsTab').DataTable({
        dom: 'Blfrtip',
        scrollX: true,
        lengthMenu: [[10, 25, 50, -1], [10, 25, 50, "All"]],
        data: formattedString.d,
        columns: [{
            data: "TestStudentID"
        },
        {
            data: "StudentID"
        },          {
              data: "StudentName"
          },
          {
              data: "Absent"
          },
          {
              data: "Gender"
          },
          {
              data: "Grade"
          },
          {
              data: "Accommodation"
          },
          {
              data: "TestDate"
          },
          {
              data: "SessionNumber"
          },
          {
              data: "Room"
          },
          {
              data: "Barcode"
          },
          {
              data: "Booklet"
          }
        ],
        destroy: true,
        language: {
            emptyTable: "No students added for this test"
        },
        select: {
            style: 'multi'
        },
        buttons: [
            {
                text: 'Select All',
                action: function () {
                    table.rows({
                        page: 'current'
                    }).select();
                }
            },
            {
                text: 'Deselect All',
                action: function () {
                    table.rows({
                        page: 'current'
                    }).deselect();
                }
            }
        ],
        //rowCallback: function (row, data) {
        //    console.log(data.Grade);
        //    if (data.Grade == 12) {
        //        console.log("set row color");
        //        $(row).css("background-color", "yellow");
        //    }
        //},
        //hide the first column
        columnDefs: [
                {
                    "targets": [0],
                    "visible": false,
                    "searchable": false
                },
        ]
​
    });
​
    //if a row is selected. show the move options
    table.on('select', function (e, dt, type, indexes) {
        if (table.rows('.selected').count() != 0) {
            $('#insertStudentsIntoRooms').show();
        }
    });
​
    //if a row is deselected. check to make sure the count is at 0 and hide move options
    table.on('deselect', function (e, dt, type, indexes) {
        if (table.rows('.selected').count() == 0) {
            $('#insertStudentsIntoRooms').hide();
        }
    });
​
​
  
});
​
Output 300px

This bin was created anonymously and its free preview time has expired. Get a free unrestricted account

Dismiss x
public
Bin info
anonymouspro
0viewers