Overview
Music Monitor has a Calendar file with a record for each day of any year. If you label the days according to the Term and Week they fall in, Music Monitor will use that information in other parts of the system, such as labelling the rolls.
The screen has buttons that make it easier to apply the labels quickly.
The Process
Go to Home > Setup Files > Calendar
Alternatively, get to the same place by one of these paths:
Home > Today > More > Set Up Term & Week Names or
Common Tasks > End of Year Procedures > Set Up Term & Week Name for Year.
Every day of the year is shown here, with space to enter the term and week information according to your school's term dates.
You could, if needed, work down the list entering term and week information for each date one at a time.
But There Is a Quicker Way
The process below describes a recommended method, using the tools Music Monitor provides, to enter the whole year's dates as quickly as possible. In brief, you use the Find function to show a list of the dates within one term, use the automated buttons to fill the dates in that term, then repeat for the other terms.
First, select Find and enter the date range of Term 1 in Date.
Use the format: 29/01/2024...28/03/2024.
The year must have the full 4 digits.
The "..." tells FileMaker to search for a range.
Always use a Monday as the start date even if the first day of school is later in the week. For example, if school term starts on Wednesday 28/1/2026, use the Monday date of 26/1/2026.
After you have performed the Find, only the dates inside the range you specified will be displayed.
Next, enter the School Term information in the first record and then, with the field still selected, select the blue Replace button.
Review the Replace dialogue, then select Replace.
Next, just select the green Enter Week Names button. The script will automatically name the weeks "Week 1", "Week 2", etc., changing to a new week each Monday.
If any manual adjustments are needed, they can also be made, either one date at a time, or in bulk using the replace button.
Repeat the process for the other terms of the year, by doing a new Find for the Term 2 dates, and so on.
Next Year's Dates
From September on, if you run the script at Common Tasks > End of Year Procedures > Set Up Term & Week Names for Year, Music Monitor will automatically generate records for next year's dates ready for you to apply the labels.
*New in 2026!* From version 10.009 onward, you have the option to set up these dates earlier.
Go to Home > Setup Files > Calendar
Select the Help icon
Select Create dates for new year





