I have a collection with 7 properties for each of the week: Monday, Tuesday etc… need an ability to add TRUE for someone pressing a button to indicate current day of the week. For example if today is Thursday, I need for the button to record True for Thursday so that my little calendar can show a checkbox over Thursday. If we press button each day then each day of the week would eventually be marked, but it needs to clear at the end of each week to start over.
I am able to detect current day of the week using the formula I searched for the forums, but i am unable to create action based on date matching the current date of week from that formula, which displays 1 through 7 for current day of week.
Another way I can do it is have 7 buttons overlay each other and show each one depending on a detected number with action corresponding to that day of week. The problem with that is that the button needs to have the ability to backdate in case someone forgot to push it for a different day using a date picker.
Any wise souls here can help me with some other ideas?