Hi Yoav ,
i followed your code but i cant get the deleting step to work.
let deleteId = $w("#dataset1").getCurrentItem()._id;
wixData.query("COFFEE-TABLE-DROPDOWN")
.eq('coffeeTableName', deleteId)
.find()
.then((res) => {
console.log("query run");
res.items.forEach(item => {
wixData.remove('COFFEE-TABLE-DROPDOWN', item);
wixData.query('COFFEE-TABLE-DROPDOWN')
.eq('coffeeTableName', deleteId)
.find() // Run the query
.then(results => {
if (results.items.length === 0) {
console.log("no query result");
wixData.remove("COFFEE-TABLES", deleteId)
.then((result) => {
let item = result; //see item below
console.log("item deleted");
$w('#table1').refresh();
$w("#box18").hide();
})
.catch((err) => {
let errorMsg = err;
});
//refresh the table with the updated info
};
})
.catch((err) => {
let errorMsg = err;
});
})
.catch((error) => {
let errorMsg = error.message;
let code = error.code;
});
});
}