Apps Script: HTML Templating

[@surajb5139]

Thanks for the explanation. I have a question here. Will the scriplets/printed scriplets work with html called from container bound scripts or will it work only when the html is called from a doGet() function in a webapp standalone script?

[@applicationexplorer9818]

The browser is NOT displaying the static map images, any idea why?

[@1endell]

Very nice, man!
Excellent work

[@jeannettemillandvigio3579]

When you got an using the gs published url ( because the lacking of the spreasheet key between /d/ and /edit), was there a way to avoid this error from happeding from the begining. Where should I have put the Google Spreasheet key while coding?

[@JordanRhea]

Hopefully I answered this question above

[@db2leader]

Awesome Videos Jordan! I'm stuck in a pinch and need help! I've built an application that displays topics for a number of day. Every "day" page is populated by looping through my days sheet and then it pops it in to a htmlTemplate and sends it back to my main application. The trouble is, its tooo slow! Any ideas?

[@TECLEMAIS]

Show, tem como adicionar um favicon?

[@israelrivera4467]

Hey everyone, can someone tell me how I form a scriplet: . Is it in the Appscript code, HTML or withing scriplet? I already tried some thing, did not work. Thank you for your help.

[@admireargumentactivity]

Nice work on all your videos! Watched a ton got way more to go, whats your background?

[@JordanRhea]

Sorry Martin! I never replied to this. My background is in English education.

[@jeannettemillandvigio3579]

Correction When you got an error using the gs published url ( because the lacking of the spreasheet key between /d/ and /edit), was there a way to avoid this error from happeding from the begining. Where should I have put the Google Spreasheet key while coding?

[@JordanRhea]

Hi Jeannette, good question. Basically, if your script is opened from inside a spreadsheet, doc, or what-have-you then you can use the method .getActiveSheet(). However, if you create a stand-alone script file, you need to use the key. Does the answer your question?

[@jeannettemillandvigio3579]

In your tutorial, it is a stand-alone script, so you need to insert the key somewhere in the code. Where would you place it?
function doGet(e) {
var SHEET_ID = e.parameter.sheet_id;
var html = HtmlService.createTemplateFromFile('summerVacation');
var responses = SpreadsheetApp.openById(SHEET_ID);
html.responses = parseResponses(responses.getDataRange().getValues()).sort(function(a,b) {return new Date(a.start) - new Date(b.start);});
return html.evaluate().setTitle('Summer Vacation Schedule');
}

[@jeannettemillandvigio3579]

I receive Bad value (line 4, file "Code")
This is my script url
script.google.com/a/upr.edu/macros/s/AKfycbw5rYnlHEu0cuz--7ec0391Ho6IjzQTJzL_yBzL3wk/dev
and my key is
1wVr5vmgFMmlLjzYLTGRjwSDfx3yl7Tgc5ukqfvfdA5U
I see that I have to follow my script url with a ?sheet_id=
so it shoul be
script.google.com/a/upr.edu/macros/s/AKfycbw5rYnlHEu0cuz--7ec0391Ho6IjzQTJzL_yBzL3wk/dev?sheet_id=1wVr5vmgFMmlLjzYLTGRjwSDfx3yl7Tgc5ukqfvfdA5U
but I would prefer to code it and not to have to enter it every time

[@jeannettemillandvigio3579]

I still showing an error, should be another kind of type from myself
This is what I have

.vacation {
display: inline-block;
position: relative;
color: white;
}
.vacation h3, .vacation h6 {
position: absolute;
background-color: darkgreen;
color:white;
padding:4px 12px;
opacity:1;
transition: all 0.3s;
}
.vacation h3:hover, .vacation h6:hover {
opacity:0;
}
.vacation h3 {
top:20px;
}
.vacation h6 {
bottom:20px;
right:0;
}
.vacation: hover h3, h6 {
opacity:1;
}

[@jeannettemillandvigio3579]

Where should I place the key?

[@RolandKuka]

very good tutorial. Thank you

[@gemavision7330]

Muito bom. Obrigado por compartilhar.

[@JordanRhea]

Gracias!

[@MarisolFlores-jx6bg]

Buen dia me marca un error en: var html=HtmlService.createTemplateFromFile("formulario2");
podria ayudarme
codigo:
var sheetId=e.parameter.sheet_id;
var html=HtmlService.createTemplateFromFile("formulario2");
var responses=SpreadsheetApp.openById(sheetId);

[@thenextbigthingsearchwithi3719]

that really shows how powerful app script is very wonderful indeed

[@jeannettemillandvigio3579]

You are a TREASURE!

[@ryaa4494]

why i got an error in line 11 from code file

[@JordanRhea]

I think that is because I forgot to put the spreadsheet key in. I corrected myself later in the video.

[@ryaa4494]

Jordan Rhea ok,thanks

[@julia.vasilieva]

@@JordanRhea got an error here: return html.evaluate().setTitle("Tasks");

[@rokstar343]

@Rhinzz and Julia, I had a typo in my html file and got the same error.
I had a parenthesis where I should have had a curly bracket.
So here:
I had:

[@alexandre1]

👌

[@jeannettemillandvigio3579]

Alexandre, when Rhea got an error on while publishing the google script because the lacking of the spreasheet code between /d/ and /edit, was there a way to avoid this error happeding from the begining. Where should I have put the Google Spreasheet key while coding?

[@Cuentil]

Heroes exist!. Thanks

[@patrickberkery8854]

I like your vids! Check out Moment.js library for date handling. Much easier than formatting and manipulating dates from scratch.

[@Cuentil]

Heroes exist!. Thanks

[@JordanRhea]

That is quite the compliment +Esteban. Cheers!

[@ashiksaleem360]

@@JordanRhea Not All heroes wear cape