Best way to make a text element display different text each day?

Need help Database
5

I think i got it, see the images below:

(note: “daily wisdom” is the DB thing that has 100 rows/entries (i.e. it’s the inventory) whereas “current daily wisdom” is the DB thing that has 1 entry that is being modified.

Screen Shot 2022-09-14 at 5.50.32 pm

Screen Shot 2022-09-14 at 5.50.52 pm
Screen Shot 2022-09-14 at 5.50.52 pm725×444 36.3 KB

Screen Shot 2022-09-14 at 5.52.40 pm
Screen Shot 2022-09-14 at 5.52.10 pm
Screen Shot 2022-09-14 at 5.52.10 pm315×579 29 KB

I think it all works. Only thing left to verify is if it will actually select a new one at midnight.

Let me know if anyone sees a problem with this setup.

1 Like