script and make it available in another namely ReturnToAlbum T Returning to the

Script and make it available in another namely

This preview shows page 19 - 24 out of 24 pages.

script and make it available in another (namely ReturnToAlbum). T Returning to the Correct Layout Monday, November 19, 2012
Image of page 19
FileMaker Scripting CS 200 Fall 2012 We now have two layouts that use the DisplayClickedSongRecord script to display Song info Here’s how we arrange to return easily to the Album layout whence we came 14 Note that we’ve had to use a global field because we need to save a value from this script and make it available in another (namely ReturnToAlbum). T Returning to the Correct Layout Monday, November 19, 2012
Image of page 20
FileMaker Scripting CS 200 Fall 2012 “Print Statements” the Show Message script step the Beep script step create a global text field M on a visible layout & use Set Field to write msgs / values into M both append and replace are supported eg in the Marks Demo’s Choose layout “Breakpoints” the Pause/Resume Script script step the Show Message script step the Show Custom Dialog step or use FileMaker Pro Advanced 15 Debugging Techniques in FileMaker Monday, November 19, 2012
Image of page 21
FileMaker Scripting CS 200 Fall 2012 Similarities you can automate most manual manipulations you can attach scripts to buttons & put them in a menu so you can extend both applications Di erences in FM recording is non-existent in FM editing is very constrained is this good or bad? in FM you can pass parameters explicitly to user-defined scripts but the mechanism is clumsy see online help for the Get(ScriptParameter), Let(...) and Evaluate(...) functions if you’re interested Only FileMaker Pro Advanced has a step-by-step debugger like Excel’s Excel has a larger set of script steps & functions 16 FileMaker’s Scripting As Compared to Excel’s Monday, November 19, 2012
Image of page 22
FileMaker Scripting CS 200 Fall 2012 Network access Field- or record-locking prevent simultaneous modification by two users Transaction support several steps treated as an “atomic action” eg: – $1000 from this account, + $1000 into that account — all are executed (or not) as if a single step Large amounts of data eg gigabytes (billions) or terabytes (trillions) 17 Other Important DBMS Features (Not relevant to this week’s assignment) Monday, November 19, 2012
Image of page 23
FileMaker Scripting CS 200 Fall 2012 It’s boring (and often overwhelming) to “sit down and learn a new application” So a good strategy is to find a project you need to do for some (unrelated) reason, for which you can use the app (or feature) you want to learn, that’s of suitable size and for which you can allocate a bit of extra time. It helps if the project is small, so you can accomplish it quickly, before losing interest or enthusiasm (This is how many of the CS 200 lab exams get set .) 18 The Project Pearl Monday, November 19, 2012
Image of page 24

You've reached the end of your free preview.

Want to read all 24 pages?

  • Fall '13
  • LiBin
  • scripting language, FileMaker, FileMaker Scripting

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture