A10_FileMakerScripting_1181.pdf - CS200 Assignment 10 FileMaker Scripting Due Tuesday March 27th 2018 9:00 am Files University Starter you will use this

A10_FileMakerScripting_1181.pdf - CS200 Assignment 10...

This preview shows page 1 - 4 out of 9 pages.

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.
Image of page 1
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.
Image of page 2
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
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture