Google provides a very good Client-to-Server Communication guide that I highly suggest you read to get a better understanding of how this works.
You cannot put apps script code (e.g. SpreadsheetApp.getActiveSpreadsheet()) in your frontend scripts. That code has to be run by the apps script server in the backend and you'll then call it using a google.script.run call.
Code.gs
function doGet(e) {
return HtmlService.createHtmlOutputFromFile('Index');
}
function checkStatus() {
var employee = "John Peter";
var ss = SpreadsheetApp.getActiveSpreadsheet();
var mainSheet = ss.getSheetByName("MAIN");
var data = mainSheet.getDataRange().getValues();
for (var j = 0; j < data.length; j++){
var row = data[j];
var mainSheet2 = row[4];
var mainSheet3 = row[0];
var status = (mainSheet2 =="IN" && mainSheet3 == employee) ;
if (status == true){
return employee + " You Are In";
}
}
}
Index.html
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<div>
<button onclick="onStatus()">Check Status</button>
<font color='Green' id="status" ></font>
</div>
<script>
function onStatus() {
google.script.run
.withSuccessHandler(updateStatus) // Send the backend result to updateStatus()
.checkStatus(); // Call the backend function
}
function updateStatus(notify) {
document.getElementById('status').innerHTML= notify;
}
</script>
</body>
</html>
It worked :) Just one more question, If I want to run 2 functions in one button click, will this modification work? onclick="onStatus();onStatus2();" ?
@MuhammedAadhil Yes, but I would recommend you write a separate function to handle that.
function checkStatus() { actionOne(); actionTwo(); }Thank you :) I'm facing another issue after testing your code. It works fine, but when I refresh the status disappears, I want to keep the status visible untill the employee Clock out. Can you please be kind enough to help me :)
@MuhammedAadhil it is a good practice to post a new question regarding the follow-up modification you want to accomplish so other readers can benefit from both questions.
@Marios I made another Question stackoverflow.com/questions/65076424/…