Reputation: 29

Metro UI table not working properly on appscript

I am following a tutorial on youtube on how to make an html sidebar using app script but Im stucked. The search options on the metro ui table isnt showing. It also supposed to have numbering and checkbox but it just shows the th and td.

Here's the html code:

<!DOCTYPE html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

    <!-- Metro UI -->
    <link rel="stylesheet" href="https://cdn.korzh.com/metroui/v4/css/metro-all.min.css">
</head>

<body>
    <h1>Hello, world!</h1>
    <table class="table striped table-border mt-4" data-role="table" data-rows="5" data-rows-steps="5, 10" data-show-activity="false" data-rownum="true" data-check="true" data-check-style="2">
        <thead>
            <tr>
                <th data-sortable="true">Worksheets</th>

            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Sheet 1</td>
            </tr>
            <tr>
                <td>Sheet 2</td>
            </tr>
            <tr>
                <td>Sheet 3</td>
            </tr>
            <tr>
                <td>Sheet 4</td>
            </tr>
        </tbody>

    </table>
    <!-- Metro UI -->

</body>
<script src="https://cdn.korzh.com/metroui/v4/js/metro.min.js">
</script>

</html>

here's the appscript code:

function loadSidebar() {
  const hs = HtmlService.createTemplateFromFile("sidebar") // html service
  const ho = hs.evaluate() // html output

  const ui = SpreadsheetApp.getUi()
  ui.showSidebar(ho)
}

function createMenu(){
  const ui = SpreadsheetApp.getUi()
  const menu = ui.createMenu("Utilities")
  menu.addItem("Delete Worksheets", "loadSidebar")
  menu.addToUi()
}
function onOpen() {
  createMenu()
} }
}

when I paste that code on vscode and run it on the server the table options are showing just fine. It's also working fine on the video tutorial I was following so not sure what went wrong.

Upvotes: 0

Answers (2)

Cooper

Reputation: 64040

This seems to work also. You don't really need to use a template since you have no scriptlets.

GS:

function loadSidebar() {
  const ho = HtmlService.createHtmlOutputFromFile("ah2");
  const ui = SpreadsheetApp.getUi()
  ui.showSidebar(ho)
}

html:

<!DOCTYPE html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

    <!-- Metro UI -->
    <link rel="stylesheet" href="https://cdn.korzh.com/metroui/v4/css/metro-all.min.css">
    <script src="https://cdn.korzh.com/metroui/v4/js/metro.min.js"></script>
</head>

<body>
    <h1>Hello, world!</h1>
    <table class="table striped table-border mt-4" data-role="table" data-rows="5" data-rows-steps="5, 10" data-show-activity="false" data-rownum="true" data-check="true" data-check-style="2">
        <thead>
            <tr>
                <th data-sortable="true">Worksheets</th>

            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Sheet 1</td>
            </tr>
            <tr>
                <td>Sheet 2</td>
            </tr>
            <tr>
                <td>Sheet 3</td>
            </tr>
            <tr>
                <td>Sheet 4</td>
            </tr>
        </tbody>

    </table>
    <!-- Metro UI -->

</body>
</html>

Upvotes: 1

TheWizEd

Reputation: 8598

If I take your html as is this is what I get. I am unable to reproduce your error.

Upvotes: 0

Metro UI table not working properly on appscript

Answers (2)

Related Questions