javascript - 如何允许用户写入电子表格而不共享正在写入的文件

Question

我希望用户能够将信息写入主表。我可以让用户通过共享主表来写入内容。但是，我不希望他们真正有权查看它。有什么解决方法吗？

function writeRecords(currentSheet) {
  // get current sheet
  var currentLastRow = currentSheet.getLastRow();
  var currentRange = currentSheet.getRange(2, 1, currentLastRow, 6);
  var currentValues = currentRange.getValues();
  // get master sheet
  var masterSpreadSheet = SpreadsheetApp.openById("fakesheetid")
  var masterSheet = masterSpreadSheet.getSheetByName('Sheet1');
  var masterLastRow = masterSheet.getLastRow();
  
  // need to insert into master spreadsheet startin from its last row
  masterSheet.getRange((masterLastRow + 1), 1, currentLastRow, 6).setValues(currentValues);
}

Answer 1

创建一个随您运行的网络应用程序。

相关

• HOW TO modify a google spreadsheet from collaborators that aren't editors?