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

Need help Database
1

How would i setup a feature where a text element displays a different text from its source in the database each day?

2

You could give it an ID (one thru X would work just fine) and then have it display the text based on the ID. This could be very heavy handed if you have a very large DB, however.

3

Yeah nah. I just want to like schedule some kind of backend workflow or something idk.

4

Basically i want to make something where every time it hits midnight, the database thing is modified.

So let’s say i have a thing with 100 entries in the database. and i have another thing in the database which is just a single empty slot (to receive 1 of those 100 entries) that (every night at midnight) gets modified to be another different one of those 100 entries (maybe at random).

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
6

Hey there, did you get this to work?

7

If you need help creating a system like this, I made a post about it recently. It’s not exactly the same, but it follows the same process.