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]); }
1 ответ
+ 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)