admin管理员组

文章数量:1123009

I append data from 1st row "A-E" Column to new row everyday via google script to keep data history. I need a script to change this last row data in "D" Column as per 1st row when needed.
Please guide on What to add/change in this script

function saveData() {
  
  {

  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName('History');
  const date = sheet.getRange('History!A1').getValue();
  const data1= sheet.getRange('History!B1').getValue();
  const data2 = sheet.getRange('History!C1').getValue();
  const data3 = sheet.getRange('History!D1').getValue();
  const data4 = sheet.getRange('History!E1').getValue();
    sheet.appendRow([date,data1,data2,data3,data4]);
  
}
}

本文标签： google apps scriptHow to edit data of in last row of Column D of Specific SheetStack Overflow

版权声明：本文标题：google apps script - How to edit data of in last row of Column D of Specific Sheet - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736540439a1944381.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。