How to pass variable from Code.gs to included script snippet

Question

So I understand that to put a variable in my HTML template I need to do

var html = HtmlService.createTemplateFromFile('Index')    
html.data = data
html = html.evaluate();

and then call it in the HTML with

<?= data ?>

But then if I include a script tag snippet with (in the Code.gs file)

function include(filename) {
   return HtmlService.createHtmlOutputFromFile(filename)
   .getContent();
}

and then include my script snippet in the HTML with

<?!= include('DataHandler') ?>

How do I call that data variable in the DataHandler script?

TheMaster · Accepted Answer · 2021-01-31 18:20:35Z

3

Change the include function to evaluate data:

function include(filename, ...otherData) {
  var html = HtmlService.createTemplateFromFile('Index')    
  otherData.forEach(obj => html[obj.key] = obj.value)
  return html.evaluate();
}

Then use include like:

<?!= include('DataHandler', {key:data, value: [1,2,3]}) ?>

answered Jan 31, 2021 at 18:20

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

littleman27 Over a year ago

After trying your fix, I was wondering why my output was only the dialog saying "Html Output" but just needed to add return html.evaluate().getContent(); and it works. Thanks

Cooper · Accepted Answer · 2021-01-31 02:44:13Z

0

I don't really use templates much but this worked for me:

HTML:

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>
    <div id="lnk"><?= data?></div>
    <script>
      var gdata=<?= data ?>
      window.onload=function(){
        google.script.run.writeData(gdata);
      }
      console.log("My Code");
    </script>
  </body>
</html>

GS:

function launchmydialog() {
  let ui=HtmlService.createTemplateFromFile('ah1');
  ui.data="Hello Work";
  SpreadsheetApp.getUi().showModelessDialog(ui.evaluate(),'Title');
}

function writeData(data) {
  SpreadsheetApp.getUi().alert(data);
}

answered Jan 31, 2021 at 2:44

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Collectives™ on Stack Overflow

How to pass variable from Code.gs to included script snippet

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related