如何使用Apps腳本使用預設選項填充HTML表格列之一？

我試圖讓這個表顯示每個表行的選項，但我不太明白：

我想我會在 seconf 中設定它for loop，但我是新手，html無法繼續前進。

<script>
    //PREVENT FORMS FROM SUBMITTING / PREVENT DEFAULT BEHAVIOUR
          function preventFormSubmit() {
            var forms = document.querySelectorAll('form');
            for (var i = 0; i < forms.length; i  ) {
              forms[i].addEventListener('submit', function(event) {
              event.preventDefault();
              });
            }
          }
          window.addEventListener("load", preventFormSubmit, true); 
              
           
          //HANDLE FORM SUBMISSION
          function handleFormSubmit(formObject) {
            google.script.run.withSuccessHandler(createTable).processForm(formObject);
            //document.getElementById("search-form").reset();
          }
         
          //CREATE THE DATA TABLE
          function createTable(dataArray) {
            if(dataArray && dataArray !== undefined && dataArray.length != 0){
              var result = "<table class='table table-sm table-striped' id='dtable' style='font-size:0.8em'>" 
                           "<thead style='white-space: nowrap'>" 
                             "<tr>"                                //Change table headings to match witht he Google Sheet
                              "<th scope='col'>Client</th>" 
                              "<th scope='col'>Name</th>" 
                              "<th scope='col'>Date</th>" 
                              "<th scope='col'>Approval</th>" 
                            "</tr>" 
                          "</thead>";
              for(var i=0; i<dataArray.length; i  ) {
                  result  = "<tr>";
                  for(var j=0; j<dataArray[i].length; j  ){
                      result  = "<td>" dataArray[i][j] "</td>";
                  }
                  result  = "</tr>";
              }
              result  = "</table>";
              var div = document.getElementById('search-results');
              div.innerHTML = result;
            }else{
              var div = document.getElementById('search-results');
              //div.empty()
              div.innerHTML = "Data not found!";
            }
          }
  </script>

uj5u.com熱心網友回復：

我相信你的目標如下。

• 您想將下拉串列放在“批準”列中。

在這種情況下，如何進行以下修改？

修改后的腳本：

createTable請按如下方式修改函式。

function createTable(dataArray) {
  if (dataArray && dataArray !== undefined && dataArray.length != 0) {
    var option = "<select name='D1'>"  
      "<option value='volvo'>Volvo</option>"  
      "<option value='saab'>Saab</option>"  
      "<option value='mercedes'>Mercedes</option>"  
      "<option value='audi'>Audi</option>"  
      "</select>";
    var result = "<table class='table table-sm table-striped' id='dtable' style='font-size:0.8em'>"  
      "<thead style='white-space: nowrap'>"  
      "<tr>"                                 //Change table headings to match witht he Google Sheet
      "<th scope='col'>Client</th>"  
      "<th scope='col'>Name</th>"  
      "<th scope='col'>Date</th>"  
      "<th scope='col'>Approval</th>"  
      "<td>"  
      "</td>"  
      "</tr>"  
      "</thead>";
    for (var i = 0; i < dataArray.length; i  ) {
      result  = "<tr>";
      for (var j = 0; j < dataArray[i].length; j  ) {
        result  = "<td>"   dataArray[i][j]   "</td>";
      }
      result  = "<td>"   option   "</td>";
      result  = "</tr>";
    }
    result  = "</table>";
    var div = document.getElementById('search-results');
    div.innerHTML = result;
  } else {
    var div = document.getElementById('search-results');
    //div.empty()
    div.innerHTML = "Data not found!";
  }
}

• option來自你之前的問題。參考

標籤：javascript html 谷歌应用脚​​本

上一篇：不小心直接用`node`運行TypeScript代碼，沒有`ts-node`，為什么會起作用？

下一篇：我可以將輸入范圍變成音頻播放器嗎？以及如何鏈接按鈕？[復制]