Go to
- Home > Today > More > Set Up Term & Week Names or
- Home > Setup Files > Calendar or
- Common Tasks > End of Year Procedures > Set Up Term & Week Name for Year.
Here you can enter a term descriptor and week descriptor for each date.
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, and 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 Thursday 6/2/2025, use the Monday date of 3/2/2025.
After the Find has been performed, only the dates inside the term start and end dates will display.
Next, enter the term name in the first date of the term, then, with the field still selected, select Replace.
Review the Replace dialogue, then select Replace.
Next select Enter Week Names. The script will automatically name the weeks "Week 1", "Week 2", etc.
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.
You can also search dates in future years and enter the term dates for them. You can go as far ahead as you have information for.