I need help to use a dataset to make a table like this:
This is my current code:
import wixData from 'wix-data';
$w.onReady( function () {
let cols = $w("#table1").columns;
cols = [];
cols.push({
"id": "col1",
"dataPath": "secretaria",
"label": "SECRETARIA",
"width": 100,
"visible": true,
"type": "string"
});
cols.push({
"id": "col2",
"dataPath": "endereo",
"label": "ENDEREÇO E CONTATO",
"width": 100,
"visible": true,
"type": "string"
});
$w('#table1').columns= cols;
wixData.query("Secretarias")
.find()
.then((res)=>{
var finalTab= res.items;
console.log(finalTab);
$w('#table1').rows=finalTab;
});
});This code works, but I need to make a table like the pic above. Sorry for my english 😆