Hello Adalo community,
I have read every single post in this forum related to display daily items (also posts related to random picker component) but I cannot find a suitable or clear solution.
I’m creating a social app in which everyday the user has to answer to a Question of the Day, that is, answer a different question every day, picked from a database of questions, and post it so other users can see.
To make it simple, there are three collections: Users, Posts and Questions.
In the Questions collection there is a database of 17 questions (just a small example to test as there will be more questions) assigned to an QuestionID property in sequential order. There is also one relationship with Users (Many Questions, one User) and one relationship with Posts (One Question, many Question Posts). There is also a QuestionDate property (only date not hours). The Users collection has, among other essentials such as username etc, a RandomQuestionID property and a CurrentDate Property (only date not hours).
When the user clicks in the button of Question of the Day, I have managed to display a random question using the RAND(1,17) function, but I CANNOT make it to appear only one question per day. Currently, when you click in the button, you get a different question every time.
Also the Home Screen has an action to Update → Logged In User → CurrentDate Property → Start of Today. But I have problems with the logic related Start of Today and Current Time.
ISSUE → What I need is to show only one question every day so that a new question pops up every day for users to answer it.
There is something that I’m missing I need some help and clarification here. I’m just a beginner and I cannot find an easy solution. I’ll mention some experts I’m learning a lot from in this forum: @Victor @Rozza @Yongki @theadaloguy @Ali-Bazzi @njimmy10
Thanks a lot guys!