CS200 Assignment 10
Page 1 of 9
CS200 Assignment 10 – FileMaker Scripting
Due Tuesday March 27th, 2018, 9:00 am
Files
University Starter
: you will use this file once again for your assignment. It is located in the
Week 10
folder
on
Learn
.
UniversityDemo2:
This file shows you how your question 1 will look and how the scripts will work.
SomeNumbers:
This file will be used for question 2, and includes sample numbers for regular
expression searches.
Assignment Objectives
•
To fully explore and understand the power of report making in FileMaker
•
To effectively summarize information in a database report.
•
To create scripts to automate repetitive, mundane tasks.
•
To use regular expressions to create search and replace patterns for more efficient searches.
Assignment Strategy
Question 1 may be done independently or with a partner. If you do work with a partner, please
add both of your names, hand in codes and Student ID numbers to the footer of each layout in
the files and name the file with both Handin Codes (
yHC1_yHC2
).
Question 2 must be done independently.
The bonus question must be done independently.
CS200 Assignment 10
Page 2 of 9
Your Tasks
1.[85%] In lecture we discussed how database reports are produced by sorting on a field to bring together (“group”) records having the same value for the sort field, and arranging to compute summary information about each resulting group. In FileMaker, the data for each record is placed in the “body” of a report, while summary information about each group (and usually fields having the same value for all the records in a group) are placed in a “sub-summary” part whose “break field” is the field by which the group was defined, and on which the data has been sorted. All this is straightforward. What’s annoying about FileMaker is that every time you wish to view the data organized by a report you must remember first to sort on the break field and then to place FileMakerin Previewmode (rather than Browse mode). FileMaker’sscripting facility allows us to automate this tedious process, and ensure that we always sort by the correct field(s). In this assignment you will simultaneously explore both reports and scripting in FileMaker by writing short macros that automate the steps involved in preparing a report, as you would very likely want to do for reports you prepare on a regular basis. You can find a password-protected demonstration solution (UniversityDemo2.fmp12) in the Week 10content on Learn . By selecting the guest account button, FileMakerwill allow you to use the solution without having access to script or layout definitions.
CS200 Assignment 10
Page 3 of 9
Here’s roughly what you have to do. Not every detail is specified—expect to do some thinking
