Custome Function: How to write a count function

Recommended Posts

I am a newbie in File Maker Pro. I am using FMP6 on Mac OSX Panther. I am designing a billing system for friend in a creative business. In his invoice, he needs a field against the name of his client indicating how many invoices he has raised for that particular client.

For example if my friend has raised 10 invoices (4 on TOM, 2 on DICK, 3 on HARRY and 1 on GEORGE) and the eleventh invoice is raised on GEORGE, Then in this invoice my friend wants GEORGE-2 indicating that he has raised two invoices on GEORGE so far or if the eleventh invoice is on TOM then the field should indicate TOM-5 indicating that he has raised 5 invoices on TOM so far.

Share this post

Link to post

Share on other sites

Your suggestion was brilliant! You wouldnt know how many cartwheels I have done after your solution. The final calculation I have have taken is:

Count( SphinxBILL::client )

where SphinxBILL is the name of the file and client is the name of the field where we enter the client name. I got what I wanted ..which is how many invoices have been raised on that particular client.