So I have my result in the textbox I need it in. However, how do I set it up like this:
There are {ResultHere} items currently in the database!
I know I need to use the following:
$w("#textboxid").text = totalCount.toString();
I just need to know how to format it to include custom text AND the query result.
Thanks for reading!
Complete code:
import wixData from 'wix-data';
$w.onReady(function () {
//TODO: write your page related code here...
});
wixData.query("COLLECTIONFIELDKEY")
.isNotEmpty("FIELDKEY")
.find()
.then( (results) => {
if(results.items.length > 0) {
let items = results.items;
let firstItem = items[0];
let totalCount = results.totalCount;
let pageSize = results.pageSize;
let currentPage = results.currentPage;
let totalPages = results.totalPages;
let hasNext = results.hasNext();
let hasPrev = results.hasPrev();
let length = results.length;
let query = results.query;
$w('#ELEMENTID').text=String(totalCount);
} else {
// handle case where no matching items found
}
} )
.catch( (error) => {
let errorMsg = error.message;
let code = error.code;
} );