How would i setup a feature where a text element displays a different text from its source in the database each day?
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.
Yeah nah. I just want to like schedule some kind of backend workflow or something idk.
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).
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.
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.
Hey there, did you get this to work?
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.