Good day, I would like to ask on how to pass/display my variables from Code.gs to my HTML file.
My Code.gs
function activities_displayTicketType() {
var GetActiveSpreadsheet = SpreadsheetApp.openById("SpreadSheetID"); //Removed ID
var GetActiveSheet = GetActiveSpreadsheet.getSheetByName("SheetName"); //Removed Sheet name
var total_ft = GetActiveSheet.getRange(2,2).getValue();
var total_crf = GetActiveSheet.getRange(3,2).getValue();
var total_others = GetActiveSheet.getRange(4,2).getValue();
Logger.log(total_ft);
Logger.log(total_crf);
Logger.log(total_others);
document.getElementById("ticket_ft_count").innerHTML = total_ft;
}
activities_displayTicketType();
My HTML:
<div class = "col-sm-3">
<div class = "card">
<div class = "card-header"> <h6> Ticket Type Summary </h6> </div>
<div class = "card-body"> FT - <text id = "ticket_ft_count"></text> </div>
<div class = "card-footer"> </div>
</div>
</div>