Shows a view usefull when planning/scheduling (service) attendances.
The view shows 32 day-columns (one month) ahead. This can easily be changed, and is only limited by max columns of Notes.
An agent runs once a day and performs followinf actions:
- It updates the columns titles (date)
- Marks saturdays and sundays with a different colors
- Re-designs the columns formulae.
The original problem was to avoid using @Today in column-formulas, because this will result in a big server load. Another challenge was to get something like vertical seperators.
This has been achieved by using webdings font together with a color column instead of the standart notes numbered icons.
In version 1.4 this was still done by customized icons, but when the view grew bigger it resulted in a lot of NSD's.
The use of a font instead of custom icons has been implemented in version 2.0.
Then I realised, that because I use color-columns, it should also be possible to mark the weekends. This resulted in version 2.1. Guess this also finalizes the project a bit, I can't think of anything more to put in. Any suggestions?
The responsible code can be found in the script-librabry and is called upon by a scheduled agent.
Keep in mind that the changes made by the code are in fact design changes; therefore it should only run on 1 server. The design changes will be replicated to other servers (if any) after the nexr replication.
Have fun,
AceIndy