A11_FileMakerScripting_1191.pdf - CS200 Assignment 11 \u2013 FileMaker Scripting Due Friday March 29th 2019 11:59 pm Files University Starter you will use

A11_FileMakerScripting_1191.pdf - CS200 Assignment 11...

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

CS200 Assignment 11 Page 1 of 9 CS200 Assignment 11 – FileMaker Scripting Due Friday March 29 th 2019, 11:59 pm Files University Starter : you will use this file once again for your assignment. It is located in the Assignment 11 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, Usernames and Student ID numbers to the footer of each layout in the files and name the file with both Usernames ( username1_username2 ). Question 2 must be done independently. The bonus question must be done independently.
Image of page 1
CS200 Assignment 11 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 11 Page 3 of 9 Here’s roughly what you have to do. Not every detail is specified—expect to do some thinking about how to carry out each step, and be aware that examination questions will test your
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 9 pages?

  • Spring '14
  • BarbaraDaly
  • Regular expression, The Script, FileMaker

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture