need to make a query shows an item from a database for all members of the site every 24 hours
as if it were a “product of the day”
which updates every day but is shown to all users
I have no idea how to start more I managed to make a small code to randomize query items
but how do I get all members to see the same item and not a random item?
wixdata.query("database") //random item picker
.eq("check", true)
.find()
.then((results) => {
let item = results; //see item below
let randomNumber = Math.floor((Math.random() * results.items.length));
console.log(randomNumber)
let randomItem = results.items[randomNumber];
console.log(randomItem)
$w("#dayimage").src = randomItem.image;
$w("#nameday").text = randomItem.tittle;
console.log("done")
})