Quick Links:

FileMaker Pro

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

Troi Number plug-in logo

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:


Transaction description



May 1




May 15

Chicago Rib Shack



May 29




July 4

Ice Cream



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


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