Buen día, me gustaría preguntar cómo pasar/mostrar mis variables de Code.gs a mi archivo HTML.
Mi Código.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();Mi 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>