developer licenses FileMaker Pro    Plug-ins Activator Plug-in ClipSave Plug-in Coding Plug-in Dialog Plug-in File Plug-in Grabber Plug-in Graphic Plug-in Number Plug-in Ranges Plug-in Serial Plug-in Sesame Plug-in Text Plug-in URL Plug-in other software: Astro Tool OsErrrs database ProMaker Utils ©2001  Troi Automatisering		Troi Number Plug-in 1.1   This plug-in makes it possible to show a running balance of a value in any portal, especially sorted portals. It does so on-the-fly, whenever any portal data is entered or edited, including changes to the sort key field(s). This functionality is accomplished without scripting. overview | details | buy-it List of Features FileMaker Pro 5.5 and MacOS X Compatible Troi Number Plug-in 1.1 has been tested with FileMaker 5.5 and is made compatible for Mac OS X. The Mac OS version of the plug-in is now a so called 'Super Fat' plug-in that will run on Mac OS 8, 9 and Mac OS X. It also works for any version of FileMaker 4 or later. Create a running balance Say you have a file "Customers.fp5" holding customer information and "Transactions.fp5" holding financial transactions. Customers.fp5 has a relation "Customer Transactions" that relates all transactions of each customer. With the Balance function it is possible to define a field that calculates a running balance. After defining the proper fields with the balance function you can get this balance to show in a portal. If a new transaction is added (or deleted) the balance is recalculated automatically. So this may result in the following portal data: Date Transaction description Amount Balance May 1 Deposit 100.00 100.00 May 15 Chicago Rib Shack -49.50 50.50 May 29 Pie -8.00 42.50 July 4 Ice Cream -1.00 41.50 This even works with sorted portals (like in this case where transactions are sorted by date). Version function helps in registering With the Tnum-Version function you now can now: return the version string, for example Troi Number plug-in 1.1". return the version number (x1000) of the plug-in, for example 1100. show the Flash Dialog of the plug-in, so that users can see the registration status. resister the plug-in, so that no extra files are needed. Function overview Below are all functions of the Number Plug-in. Function name Short description Tnum-Version Returns the version of the plug-in. Can also be used for registration. Tnum-BalanceStart * Starts the balancing Tnum-BalanceCalc * Returns the running balance Tnum-BalanceResult * Returns the total * note that these 3 function should be used together to get the desired result. See the examples or the user guide for more info. User Manual You can view the user guide online: NumberUserGuide11.pdf. (You need Acrobat Reader 4 for this). In the download the user guide is also included. What can you do with the Number Plug-in ? Suggested uses of this plug-in are: Show a historic list of transactions, with the balance after each transaction shown. Show the end times of a list of actions. Of course more is possible. The best way to see if it can help you is to try it out. Please mail us if you have an interesting application of the Number Plug-in. We are always interested in what you can do with it. What are the costs? Below are the prices for new licenses. (Updates from previous versions are free). 1 or more Single user license(s): US$ 19 per user Site license: US$100 per site World-Wide license: US$200 per company Developer Distribution license (Mac and Windows): US$ 120 Developer License available For the Number Plug-in we have a developer license specially intended for developers of databases. This license allows you to include our plug-ins with ALL databases or FileMaker solutions that your company sells. See the Developer License page for more information. Back to main Number Plug-in page
www.troi.com/software		Products | Purchase | Support | Newsroom | About Troi | Mailing lists | Tips | Links