Test your reports by manually finding and sorting the Marks records for a

Test your reports by manually finding and sorting the

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

Test your reports by manually finding and sorting the Marks records for a particular course. Please put your name, student number and handin code in the footer of all your reports/layouts, so the tutors can easily identify your work. E. Write a script called “ By Name ” that sorts the data appropriately, puts FileMaker in Preview mode and displays the current found set using the By Name [Detailed] layout. Write a similar script called “ By IDN ” that uses the By IDN [Detailed ] layout. Test these macros by running them manually from the Script menu. F. Write a script called DoIt that: “performs” your Do Find script to find the Marks records for the course selected on the Choose layout; uses FileMaker’s If – Else – End If script steps to “perform” either your By Name or By IDN scripts, depending on the current value of the WhichOrder field. Attach the DoIt script to the DoIt button on the Choose layout. Clicking on the DoIt button should now produce either Figure 1 or Figure 2 , depending on the order last selected via the WhichOrder popup menu. G. Duplicate the By Name [Detailed ] and By IDN [Detailed ] layouts to create layouts named By Name ” and “ By IDN ”. Modify both of these layouts by deleting the body part and all of the fields in that part, ultimately leaving only a sub-summary part, header and footer. Make any other changes needed to produce the layouts shown in Figures 3 and 4. H. Alter your By Name and By IDN scripts so they display data using the By Name and By IDN layouts instead of the By Name [Detailed ] and By IDN [Detailed ] layouts. At this point you should have duplicated the functionality of the Choose layout in the password- protected demonstration solution I have placed on Learn .
Image of page 4
CS200 Assignment 10 Page 5 of 9 2. [15%] This is an application of Regular Expressions. This question must be done individually. Design find and replacement regular expressions that insert commas into the numbers shown so as to group digits to the left of the decimal point in blocks of 3 (currency format, eg 71,243,425). Assume that all numbers will have 8 digits only. Put your answer in yHC_a10q2.doc. Use SomeNumbers.txton in the Assignment Files on Learn to test your find and replace patterns. You should use TextWrangler(freeware for Macintoshes). Make sure that “Use Grep” is selected. Put your find and replace patterns in a nicely formatted MS Word file namedyHC_a10q2.doc. 71243425 75424677 54781475 87886172 39123426 30193577 80139671 10733189 29675544 32544418 37756090 11584051 15989387 80791863 25912684 67493203 99766586 76660544 42229077 20790370
Image of page 5
CS200 Assignment 10 Page 6 of 9 Bonus Would your answer to question 2 be different if the numbers were intermixed with text as follows, and if so, how? Justify your answer. This text is not in a file and you are not required to type it out, however you may want to test your answer by entering a few lines into TextWrangler .
Image of page 6
Image of page 7

You've reached the end of your free preview.

Want to read all 9 pages?

  • Spring '17
  • Regular expression, The Script, FileMaker

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture