Need help in Auto Ticking Boolean Value every 7 days based on a condition

Ask for Help
1

Hi Guys,
I have a requirement which I need help in configuring or doing.

I have a boolean value which will be ticked on toggle from front end.

It should note down the date and time when it toggled.

The table will have multiple rows and each row will have a toggle enabled or disabled

There needs to be Another boolean column enabled for next 52 weeks (One year)

Starting from that day every Monday morning it should check the boolean is true or false

Every monday for the next one year it should check wether the Boolean is true or false and enable the same for Evey monday (Meaning is the boolean is true for next one week it should enable week 1 toggle, If its false for next it should put false for week 2)

What is the best way of doing this? Not able to understand how can I trigger the weekly function of checking the boolean is enabled or not.

Also would it be a good practice to put 52 columns for 52 weeks? There might be more than 50 rows. Would it be a good practice?

Thank you in advance for help.

Regards,
Dilip

2

Hi Guys,

Any help is greatly appreciated.

While I am able to put in the date and time when the boolean is enabled

I am Stil stuck in understanding wether creating 52 columns one for each Week is a good practice , and will it lead to load on database.

Thank you guys in advance.

Regards,
Dilip

3

Hi Guys,

Anyone has any suggestion on this?

Thank you in advance

Regards,
Dilip