0

Java script

var sheet_id = "1tLe_DtcYxT_M7vxxxxxxxxy7uZs6aQ8"; // Corrected sheet_id var sheet_name = "attendance"; function doGet(e) { var ss = SpreadsheetApp.openById(sheet_id); // Using the corrected sheet_id var sheet = ss.getSheetByName(sheet_name); var date = e.parameter.date; var time = e.parameter.time; var employeeID = e.parameter.empid; var employeeName = e.parameter.empname; var employeeEmail = e.parameter.empemail; var position = e.parameter.emppos; // Now you can use these extracted parameters to update your spreadsheet // For example, you can use sheet.appendRow() to add a new row with the provided data // sheet.appendRow([date, time, employeeID, employeeName, employeeEmail, position]); }

7th Oct 2023, 3:21 PM
Aye Sandar
Aye Sandar - avatar
1 Respuesta
+ 3
Aye Sandar , not quite clear what your issue or question is. can you give some more details? your post seems to be incomplete. it should include: > if your post is related to a sololearn tutorial, we need to know the name of it, also the chapter and lesson name. > a clear task description with input / output sample > a description what exactly your issue is, (if possible including an error message)
7th Oct 2023, 6:15 PM
Lothar
Lothar - avatar