Can anyone help with my first attempt at a database query please.

Ask the community
,
1

I have a dataset with 2 columns and 7 rows. The first column is days of the week. The second column is quotes.
I want the text box to show Sunday’s quote every Sunday; Monday’s quote every Monday and so on.
Ideally I want the screen output to be white with a bold heading and an italic subhead.
Is there a simple way that I am missing?
I used this to get the name of today

var dayNames = new Array(“Sunday”,“Monday”,“Tuesday”,“Wednesday”,
“Thursday”,“Friday”,“Saturday”);
var now = new Day();

Then I used this to look at dataset2 called dayquotes to find the row that the name of today appears in column dow. I then want the contents of the same row in column quote to appear in textbox30.

$w( “#dataset2” ).onReady( async () => {
$w( “#dataset2” ).setFilter(wixData.filter()
.eq( “dow” , day)
.then(() => {
console.log( “quote” );
});

The collection is called dayquotescollection
The dataset is called Dayquotescollectiondataset and is dataset2
Textbox30 connects a dataset to Dayquotescollectiondataset
Text connects to quotes(rich text)

Thankyou

2

I’ve sorted it myself by not using database.
I used show and hide text boxes with if statements.
Shown here in case it helps anyone else.

Shows a different text box for every day of the week.

$w.onReady( function () {
// This hides text boxes for each day of the week.
$w( “#text30” ).hide();
$w( “#text31” ).hide();
$w( “#text32” ).hide();
$w( “#text33” ).hide();
$w( “#text34” ).hide();
$w( “#text35” ).hide();
$w( “#text36” ).hide();

// This finds out what day of the week today is
//Sunday is 0; Monday 1
var d = new Date();
var n = d.getDay();

// to test - remove the // from the line below and let n be any number between 0 and 6. Then preview
//n=6

// This opens the text box matching the day of the week
if ( n=== 0 ) {
$w( “#text30” ).show();
}
else {
if ( n=== 1 ) {
$w( “#text31” ).show();
}
else {
if ( n=== 2 ) {
$w( “#text32” ).show();
}
else {
if ( n=== 3 ) {
$w( “#text33” ).show();
}
else {
if ( n=== 4 ) {
$w( “#text34” ).show();
}
else {
if ( n=== 5 ) {
$w( “#text35” ).show();
}
else {
if ( n=== 6 ) {
$w( “#text36” ).show();
}

}
}}}}}});