J'essaie de trier les données (ASC ou DESC) dans le tableau. Pour celui-ci, je veux trier la date de vl & date / heure d'application chaque fois que je clique sur chaque en-tête. Cependant, mon code actuel ne fait rien chaque fois que je clique. Mais quand je l'ai essayé sur une donnée statique, cela fonctionne.

Voici mon code ci-dessous: P>

    <? var data = SpreadsheetApp
        .openById('sheet ID')
        .getSheetByName("VL Request")
        .getDataRange()
        .getValues(); 
   var timeStamp = [0];      
   var rid = [1];     
   var ldap = [2];
   var aname = [7];
   var lob = [9];
   var dovl = [5];
   var rol = [6];
   var tlapprov = [12];
   var tlrem = [14];
   var stat = [13];
   var schedrem = [11];
   var tl = [3];
   var pocldap = [15];
   var omldap = [16];
   var userName = Session.getEffectiveUser().getUsername();
  ?>
     <table id="vllist" class="vllist2">

       <tr>
           <th colspan=11>POC VIEW</th>    
       </tr> 
    <tr>
           <th colspan=11>Application for Date Range: <?= [formattedStart] ?> - <?= [formattedEnd] ?></th>    
       </tr>   
      <tr>
        <th style="display:none;">Request ID</th>   
        <th>LDAP</th>
        <th>Agent Name</th>
        <th>Lane</th>  
        <th onclick="sortTable(4)">Date of VL</th>
        <th>Reason of Leave</th>
        <th>POC Approval</th>
        <th>POC Remarks</th>
        <th>Scheduler's Approval</th>
        <th>Scheduler's Remarks</th>
        <th onclick="sortTable(10)">Date/Time of Application</th>
      </tr>

     <? for (var i = 1; i < data.length; i++) { ?>
            <tr> 
            <? if ((data[i][tlapprov] === "Pending") && ((data[i][pocldap] === userName) || (data[i][omldap] === userName)) && (data[i][dovl] >= startDate) && (data[i][dovl] <= endDate)) { ?>

            <?
            var vldate = data[i][dovl];
            var formattedDateVL = (vldate.getMonth()+1) + '/' + vldate.getDate() + '/' + vldate.getYear();
            ?>

              <td class="hide">
                <?= data[i][rid] ?>
                </td>
                <td>
                <?= data[i][ldap] ?>
                </td>
                <td>
                <?= data[i][aname] ?>
                </td>
                <td>
                <?= data[i][lob] ?>
                </td>
                <td>
                <?= [formattedDateVL] ?>
                </td>
                <td>
                <?= data[i][rol] ?>
                </td>
                <td>
                <?= data[i][tlapprov] ?>
                </td>
                <td>
                <?= data[i][tlrem] ?>
                </td>
                <td>
                <?= data[i][stat] ?>
                </td>
                <td>
                <?= data[i][schedrem] ?>
                </td>
                <td class="lefttext">
                <?= data[i][timeStamp] ?>
                </td>

                <? } ?>
            </tr>
            <? } ?>

    </table> 

<script>
function sortTable(n) {
  var table, rows, switching, i, x, y, shouldSwitch, dir, switchcount = 0;
  table = document.getElementById("vllist");
  switching = true;
  dir = "asc";

  while (switching) {

    switching = false;
    rows = table.rows;

    for (i = 1; i < (rows.length - 1); i++) {

      shouldSwitch = false;

      x = rows[i].getElementsByTagName("TD")[n];
      y = rows[i + 1].getElementsByTagName("TD")[n];

      if (dir == "asc") {
        if (x.innerHTML.toLowerCase() > y.innerHTML.toLowerCase()) {

          shouldSwitch = true;
          break;
        }
      } else if (dir == "desc") {
        if (x.innerHTML.toLowerCase() < y.innerHTML.toLowerCase()) {

          shouldSwitch = true;
          break;
        }
      }
    }
    if (shouldSwitch) {

      rows[i].parentNode.insertBefore(rows[i + 1], rows[i]);
      switching = true;

      switchcount ++;
    } else {

      if (switchcount == 0 && dir == "asc") {
        dir = "desc";
        switching = true;
      }
    }
  }
}
</script>