FileMaker 7 Example Files

• Date Picker Popup: A date picker example, that pops up a new window with a date picker in it.
  Usage: See the datePick Options layout to setup a list of holiday patterns and day colors.
  
  • Dev 7: Date Picker Popup (as a single file) Since this example uses custom functions, you can only recreate its structure using Developer 7.
  • FM 7: Date Picker Popup (multi-file) This version is broken into two files, so its more suitable for being dropped into your existing solutions.
  • FM 7: Date Picker Popup (multi-file) This version is also changed to start the week on Monday (used everywhere but US and Japan), its also a multi-file version.
• Value Iterators - Value Iterators allow moving forward/backward through a list of values. They are an example of FileMaker objects implemented via storage in global variables.
• Property Lists - A collection of misc custom functions that implement property lists, bitwise and/or/not, and some other stuff.
  
• Perl-Style Regular Expressions inside FM Pro 7 - A group of custom functions that implement a regular expression matcher.
  
• Bar graphs in a single auto-enter field - Similar to the TicTacToe example, but a little more useful. The numbers can be edited in-place, and the bar graph will adjust itself when you leave the field.
• Matrix Object Example - Custom functions demonstrating matrix objects, including some simple matrix opertaions: Transpose, Multiplication by scalar or matrix, etc.
• Style Manipulation Example - A more elaborate example of custom functions that uses the built-in GetAsCSS() function and custom functions to manipulate text styles and colors without interfering with other styles/colors that are already present in the text.
  There is little point of downloading this without Dev 7, it will just make you jealous.
• Edit Distance Example - Attempt to locate the gross difference between two pieces of text.
• A simple invoicing example - A simple invoicing system for a used bookstore, with a some example data to show how it might work.
  [ 290K download - contains 6000 example book titles and authors. ]
• Bill-of-Materials example - Showing computations required to obtain a final price from a recursive component list.
• Tic-Tac-Toe in a single auto-enter field - Motivated by an example by Court Bowman in the Cleveland Consulting custom function forum.
• Chess Board
  Usage: Click on any row of the gameView portal and click the "Goto Game" button. Now you can select the script "Slide Show" to see that game played, at one move every two seconds. I include data for several of the Kasparov vs Deep Blue games as an example.

  To play your own game, choose the "New Game" script. Click on a piece to move, then click again on the destination square. The board will move the piece and fill in the chess notation for you. The board enforces who's turn it is, and that the pieces are being moved in a (mostly) legal fashion. When you finish playing - your new game is now available to watch as a slide show also!

  Demonstration of new FM7 features:

  • The board images is done with a single repeating field, with 64 repetitions. I use the ability to show only a portion of the reps each time the field appears on the layout (once for each row of the board).
  • 64 buttons (one per board square), all using the same script with a script parameter.
  • Custom functions: used to generate complex multi-keys for joins, generating SAN (chess notation) and other things.
  • Multi-way join with multi-keys: Used to determine legal moves using a table of rules about each type of piece and how it is allowed to move, and which squares between must be empty.

  Limitations:
  

  • The chess notation is more verbose than usual, normally it only includes the destination square except when that alone would be ambigious. To trim it down, the database would need to understand when only a single piece could move to the destination.
  • The board doesn't automatically add marks for check (+), they need to be appended manually after the move occurs.
  • The board *does* know how to "castle", just move the king two squares to the right or left, and the rook will be moved for you.

Go back up to my homepage.

Mail me at: flisakow at spf-15.com