Pass variable in Google Apps Scriptlet to javascript

Question

I just started coding with HTML and scriptlets within Google Sheets.

Trying to pass the array variable teacherArrayLean from the scriptlet (enclosed by <? ... ?>) to the <script>. However, <script> doesn't read the variable; when I replace the variable with constants, the scripts runs no problem so I know it's not the rest of the code.

Does anyone know how to use the variable in <script>? Thank you!

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
    <style>
    table, td, th {border: 1px solid black;}
    table {border-collapse: collapse;}
    th {text-align: left;}
  </style>
  </head>
  <body>

    <? var querySheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('query');
       var teacherArrayRaw = querySheet
                   .getRange(2, 4, querySheet.getLastRow() - 1, 1)
                   .getValues();
       teacherArrayRaw.sort();
       var teacherArrayLean = [];
       teacherArrayLean.push(teacherArrayRaw[0]);
       for(var n in teacherArrayRaw) {
         if(teacherArrayLean[teacherArrayLean.length-1].toString().trim() != teacherArrayRaw[n].toString().trim()) {
           teacherArrayLean.push(teacherArrayRaw[n]);
         }
       } 
       ?>

    <table id="calendar"></table>

    <script>
    var teacherArrayLean = [];
        var table = document.getElementById("calendar");
        var row = table.insertRow(0);
        for (var col = 0; col < teacherArrayLean.length; col++) {
        var cell = row.insertCell(col);
        cell.innerHTML = teacherArrayLean[col];

      }
    </script>
  </body>
</html>

Titus · Accepted Answer · 2018-08-05 18:28:29Z

4

You can do something like this:

<script>
    var teacherArrayLean = JSON.parse("<?=JSON.stringify(teacherArrayRaw)?>");
    ....
</script>

answered Aug 5, 2018 at 18:28

Titus

22.6k1 gold badge26 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Pass variable in Google Apps Scriptlet to javascript

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related