tabulator GAS loading

by radek

HTML

<link href="https://unpkg.com/[email protected]/dist/css/tabulator.min.css" rel="stylesheet">
<script type="text/javascript" src="https://unpkg.com/[email protected]/dist/js/tabulator.min.js"></script>
<div id="example-table"></div>

CSS

.tabulator-row.tabulator-selected {
    background-color: #9FE620 !important;
}

JavaScript

var do_not_show_checkbox_ids = [1];

var asTextOriginal ='[{id:1, name:"BalanceOil", _children:[{id:2, name:"BalanceOil+  s testy", cena:31, mn:1,cena_1:"", package:159, kredityMesicne:4, kredityBalik:14},{id:3, name:"BalanceOil+ ", cena:31, mn:1,cena_1:"", package:85, kredityMesicne:4, kredityBalik:8},]},{id:11, name:"Xtend x2 Kit", cena:23, mn:1,cena_1:"", package:83, kredityMesicne:3, kredityBalik:8},{id:18, name:"Viva+ Kit", cena:21, mn:1,cena_1:"", package:60, kredityMesicne:3, kredityBalik:4}]';

var asText = '[{id:1, name:"BalanceOil", _children:[{id:2, name:"BalanceOil+  s testy", cena:31}, {id:3, name:"BalanceOil+ ", cena:31}]},{id:11, name:"Xtend x2 Kit", cena:23},{id:18, name:"Viva+ Kit", cena:21}]';

//var tableDataNested = [{id:1, name:"BalanceOil", _children:[{id:2, name:"BalanceOil+  s testy", cena:31, mn:1,cena_1:"", package:159, kredityMesicne:4, kredityBalik:14},{id:3, name:"BalanceOil+ ", cena:31, mn:1,cena_1:"", package:85, kredityMesicne:4, kredityBalik:8},]},{id:11, name:"Xtend x2 Kit", cena:23, mn:1,cena_1:"", package:83, kredityMesicne:3, kredityBalik:8},{id:18, name:"Viva+ Kit", cena:21, mn:1,cena_1:"", package:60, kredityMesicne:3, kredityBalik:4}];


//var tmp = JSON.parse("[" + asText2 + "]");
//var tmp = JSON.parse(asText2);
//console.log(tmp);


var tableDataNested = asText;

//var tableDataNested = [{id:1, name:"BalanceOil", _children:[{id:2, name:"BalanceOil+  s testy", cena:31}, {id:3, name:"BalanceOil+ ", cena:31}]},{id:11, name:"Xtend x2 Kit", cena:23},{id:18, name:"Viva+ Kit", cena:21}];



var table = new Tabulator("#example-table", {
  movableColumns: true,
  data: tableDataNested,
  dataTree: true,
  selectable: true,
  columns: [{
      title: "Name",
      field: "name",
      headerSort: false,
      width: 200
    },
    {
      title: "Cena",
      field: "cena",
      headerSort: false
    },
    {
      formatter: function(cell, formatterParams, onRendered) {
        const data = cell.getRow().getData();
        if...