Hello
I want to hide an empty row in the table which is connected to the database.
The columns of the table are connected with the 4 columns of the database.
The problem is that when we skip to fill these columns and fill the rest columns in the database,
the table shows the results as empty rows in the front end.
Please note: I don’t know to code.
It would be great if you can help me with the code itself.
I want to solve this urgently.
thanks in advance
Pulkesh
$w.onReady(() => {
$w("#dataset1").onReady(() => {
let rows = $w("#table").rows;
rows = rows.filter(r => r.projectName);//use the field path
$w("#table").rows = rows;
})
})
Hi J.D. .
Thanks for reaching back.
Really appreciate your efforts.
I put the same code as you advised for the 5 columns.
In order to eliminate the empty ones.
But in output. i am getting a complete blank table on the website.
Please see the code I entered.
-----------------------------
$w.onReady(() => {
$w("#dynamicDataset").onReady(() => {
let rows = $w("#table2").rows;
rows = rows.filter(r => r.projectNameCommissionStats);//use the field path
rows = rows.filter(r => r.totalSqftCommissionStats);
rows = rows.filter(r => r.totalCommissionCommissionStats);
rows = rows.filter(r => r.commissionReceivedCommissionStats);
rows = rows.filter(r => r.projectStatusCommissionStats);
$w("#table2").rows = rows;
})
})
Hello J.D.
Just checked again.
It is working totally fine.
Thanks a lot for your help.
Thanks
Pulkesh
Really helpful, thank you! 
