Hello,
I have been trying to figure out a solution for the visibility of certain tiles depending on the time. I am looking to create 3 types of categories each with their own tile. I also have the date settings for their previous appointment and then when the next appointment is due.
I am looking to make the background gray if the due appointment is between the “previous PHA date” and 9 months from the “previous PHA date”.
A the 9 month mark the background color will change to yellow or a new rectangle appears ‘to the front’ of the gray rectangle between 9 months from the “previous PHA date” to the “PHA due” date
At after the PHA due date the background becomes red or a new red rectangle appears to the “front of the yellow” rectangle.
This is what I have so far for the set up…
Thank you for your help in advance!
Here is the lay out of the rectangles…
Here is my database. I would like to have this set up off of the PHA Due.