FMP 10: Nurserey want's a plan showing what room gets cleaned when. I
have a list view with the rooms from top to bottom. The want the days of
the month from left to right.

        Day1    Day2    Day3    Day4
Room1   Cleaning                
Room2           Cleaning        
Room3                   Cleaning        
Room4                           Cleaning

I made a global date field for the start date and a calc feld with 31
repetitions to display the days of the month (and the first days of the
following month if the current month has less than 31 days).

Can I stay with that or do I have to create 31 fields, because:

Problem #1: I can't have Sundays painted in red with the repetition
field, can I? The dataviewer shows the weekday of the repetition I click
in, but it seems that's not good enough for conditional formatting.

Problem #2: In the resulting grid, the cleaning days need to get marked.
A room get's cleaned on day 2 if the room above (the previous record)
got cleaned on day 1. I have to put in a place to start somehow. To keep
matters simpler, I assume there won't be any iterruptions (they actually
do clean rooms on Sundays).
-- 
http://clk.ch

In article <1jfmg13.167s17h1dhfkwiN%clk@tele2.ch>, clk@tele2.ch (Christoph
Kaufmann) wrote:

> FMP 10: Nurserey want's a plan showing what room gets cleaned when. I
> have a list view with the rooms from top to bottom. The want the days of
> the month from left to right.
> 
>         Day1    Day2    Day3    Day4
> Room1   Cleaning                
> Room2           Cleaning        
> Room3                   Cleaning        
> Room4                           Cleaning
> 
> I made a global date field for the start date and a calc feld with 31
> repetitions to display the days of the month (and the first days of the
> following month if the current month has less than 31 days).
> 
> Can I stay with that or do I have to create 31 fields, because:

Having 31 fields or even better a new Table of Related records (one for
each day, where data is needed) would be the best approach to get around
all sorts of messy problems you'll discover when using Repeating Fields.


Helpful Harry  :o)

Your Name <your.name@isp.com> wrote:

> Having 31 fields or even better a new Table of Related records (one for
> each day, where data is needed) would be the best approach to get around
> all sorts of messy problems you'll discover when using Repeating Fields.

Agreed. I wouldn't want to use repetition fields to store real data,
this is for show only.
-- 
http://clk.ch

Christoph Kaufmann wrote:
> Problem #1: I can't have Sundays painted in red with the repetition
> field, can I? The dataviewer shows the weekday of the repetition I click
> in, but it seems that's not good enough for conditional formatting.

Sure you can.  You need to first determine which repetition represents 
Sunday and then you can use this in your conditional formatting formula, 
for example assuming the 7th repetion is the one that we want to be red:
	Get ( CalculationRepetitionNumber ) = 7

Howard Schlossberg wrote:

[Conditional Formatting of a calc repetition field]
> Sure you can.  You need to first determine which repetition represents
> Sunday and then you can use this in your conditional formatting formula,
> for example assuming the 7th repetion is the one that we want to be red:
>       Get ( CalculationRepetitionNumber ) = 7

Gee, it worked, and even gave me the opportunity to use the choose
function (to pick the days from the start date to the first Sunday).
-- 
http://clk.ch