{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 小情绪 Triste * 的问题《Passing variable from google apps script to html t》','https://www.manongdao.com/q-984128.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I'm triyng to pass a simple variable (profesorgg) to an HTML template in google Apps Script in order to evaluate the HTML for each teacher in my school and send to them a personalized email. This is the code:
Code.gs
function Recordatorio() {
//COGIENDO UN PROFESOR DESDE GROUPS
var page = AdminDirectory.Users.list({
domain: 'iesovaldemedel.es',
orderBy: 'familyName',
maxResults: 400});
var has = GroupsApp.getGroupByEmail("profesores@iesovaldemedel.es").getUsers();
var users = page.users;
if (users) {
for (var i = 0; i < users.length; i++) {
var email = users[i].primaryEmail;
var nombre = users[i].name.givenName;
var apellidos = users[i].name.familyName;
for (var h in has){
if (has[h] == email){
var profesorgg = apellidos + ", "+nombre;
var subject ="Resumen de faltas para " +profesorgg + "." ;
var body = "Se adjunta el resumen de faltas del mes que termina";
var html = HtmlService.createTemplateFromFile("recordatoriohtml");
html.data = profesorgg;
var htmlbody =html.evaluate().getContent();
MailApp.sendEmail("mariomorenogo@gmail.com", subject, body, {htmlBody:
htmlbody});
}}}}}
HTML FILE: recordatoriohtml
<html>
<head>
</head>
<body>
<h1 align="center">IESO Valdemedel</h1>
<div class = "wrapper3">
<image align="center" src="image>
</image>
</div>
<? var today = new Date;
var mes = today.getMonth();
var ano = today.getYear();
var date = Utilities.formatDate(today, "GMT+1", "dd-MM-yyyy");
var data = SpreadsheetApp.openById("myspreadsheet")
.getSheetByName("DATOS").getDataRange().getValues();
I`m triyng to call profesorgg HERE (HMTL file continuation)
var profesorg = profesorgg;
var faltamas=0;
var faltas =[];
//BUSCANDO A ESE PROFESOR EN LAS FALTAS
for ( var o = 1 ; o<data.length; o++){
var timestamp = data[o][0];
var profesor = data[o][1];
var diadefalta = data[o][2];
var todoeldia = data[o][4];
var motivo = data[o][3];
if(diadefalta != ""){
var diadefalta2 = Utilities.formatDate(diadefalta, "GMT+2", "dd-MM-yyyy");
var mesfalta = diadefalta.getMonth();
var anofalta = diadefalta.getYear();}
else{var diadefalta = "-"}
if (ano == anofalta && mes == mesfalta && profesor == profesorg){
faltamas++
faltas.push([diadefalta2,profesor,todoeldia,motivo]);}}
if(faltamas >0){?>
<hr width=100%>
<h1 align = "center">Resumen Futuro</h1>
<hr width=100%>
<h2> Faltas para mañana </h2>
<?if(faltas !=""){?>
<div>
<table style="width:100%">
<tr>
<th id="t01">Fecha</th>
<th id="t02">Todo el día</th>
<th id="t03">Motivo</th>
</tr>
<?for (var c=0; c<faltas.length; c++){?>
<tr>
<td id="td01"><?=faltas[c]?></td>
<td id="td02"><?=faltas[c][0]?></td>
<td id="td03"><?=faltas[c][2]?></td>
<td id="td04"><?=faltas[c][3]?></td>
</tr>
<?}}}?>
</table>
<br>
<hr width=100%>
<?if (faltas ==""){?>
No tienes faltas este mes
<?}?>
<br>
</div>
<hr width=100%>
<h3>Atentamente, IESO Valdemedel</h3>
<hr width=100%>
</body>
<footer>
<b><i><small>Powered by</small></i></b> <br>
<a href="http://www.teachinginsights.es">
<img src="image>
</a>
<hr width=100%>
</footer>
</html>
¿It is possible? Thanks a lot for your help
Mario Moreno
If I read your code right, you are passing the variable "profesorgg" like this:
Which is the right way to go, but note that you are actually declaring a variable "data" to your html and assigning the value of profesorgg to it. This means that in your html
would return the value of profesorgg execpt that I think you are overriding it in the line
anyway, for the next line to work in your html - file:
you would need to do this in your .gs file: