Display records by Week Commencing

I have tried to use the calendar view, but it doesn’t quite do what I need.

I would like to see clients down the left then in each week display the date that the client had Keywork a bit like this:


The closest I have come to is using the display as list in the calendar, but it will only display 1 week at a time and doesn’t show the clients who haven’t had a keywork that week. I know that I could have an object with each field as a week/commencing but I have not found a way to dynamically create fields also I feel that this would create a massive object in 5 years.

I am not even sure if this is possible.

Any help will be much appreciated.


Hi Craig

I’d suggest a formula like you would in Excel to find the beginning of the week (Monday?): Date - WEEKDAY(Date,2)+1.


Thanks I’ll try that