File
Add library
Share
Login or Register
Help
HTML
 
<!DOCTYPE html>
<html>
<head>
<meta name="description" content="Child Rows">
    <title></title>
    <meta charset="utf-8" />
    <link href="https://cdn.datatables.net/1.13.4/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css">
​
    <script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.js"></script>
      <script type="text/javascript" src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>
​
</head>
<body>
​
  <!--  <script type="text/javascript" src="test1.js"></script> -->
  
  <script>
      $(document).ready(function () {
    $('#example').DataTable({
       ajax: {
           url: 'https://script.google.com/macros/s/AKfycbzwh1BYodp3Ghk7i6zJ9DMOPIaF8DT6m8eclar_1deoieNHM2o-_19GtgDIRvgc3M3l/exec?action=read&table=Sheet1',
​
               
       },
​
        columns: [
            { data: 'id' },
            { data: 'dt' },
            { data: 'date1' },
            { data: 'date2' },
            { data: 'date3' },
            { data: 'DZR1' },
        ],
    });
});
  </script>
    <table id="example" class="display" style="width:100%">
        <thead>
            <tr>
                <th>id</th>
                <th>dt</th>
                <th>DZR</th>
                <th>DZR1</th>
                <th>Start date</th>
                <th>Salary</th>
                 <th>First name</th>
                <th>Last name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Start date</th>
                <th>Salary</th>
                 <th>First name</th>
                <th>Last name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Start date</th>
                <th>Salary</th>
                 <th>First name</th>
                <th>Last name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Start date</th>
                <th>Salary</th>
                 <th>Start date</th>
                <th>Salary</th>
                 <th>First name</th>
                <th>Last name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Start date</th>
                <th>Salary</th>
                 <th>First name</th>
                <th>Last name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </thead>
​
    </table>
    
https://script.google.com/macros/s/AKfycbzwh1BYodp3Ghk7i6zJ9DMOPIaF8DT6m8eclar_1deoieNHM2o-_19GtgDIRvgc3M3l/exec?action=read&table=Sheet1
</body>
</html>
​
​
CSS
 
        td.details-control {
            text-align:center;
            color:forestgreen;
    cursor: pointer;
}
tr.shown td.details-control {
    text-align:center; 
    color:red;
}
Output

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

Dismiss x
public
Bin info
anonymouspro
0viewers