x===
8/20/2024function onFormSubmit() { // Open the target Google Sheet file const spreadsheetId = '1WCLEKQYYYKVbFzz9ZwaKH3IEEk8JdbmZgecrQHwc4bY'; const spreadsheet = SpreadsheetApp.openById(spreadsheetId); const responseSheetName = spreadsheet.getSheets()[0].getName() // 回應表單名稱 const responseSheetValue = spreadsheet.getSheets()[0].getDataRange().getValues() // 回應表單值 const templateSheet = spreadsheet.getSheets()[1] // 文件模板 const quotationSheetName = spreadsheet.getSheets()[1].getName() //文件模板名稱 const quotationSheetValue = spreadsheet.getSheets()[1].getDataRange().getValues() // 文件模板值
6/7/2024活動簡介:
5/29/2024簡報連結逐字稿
4/16/2024or
By clicking below, you agree to our terms of service.
New to HackMD? Sign up