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 (AT) tele2 (DOT) ch>, clk (AT) tele2 (DOT) ch (Christoph
Kaufmann) 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.


Helpful Harry )

Your Name <your.name (AT) isp (DOT) com> wrote:

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

Christoph Kaufmann wrote:
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]
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