Tuesday, April 8, 2008

FILEMAKER: Current Examples Of Some Custom Functions I Use

From Dwayne Wright
Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com

This is a listing of the current custom functions that are used within InBizness SOHO. None of these custom functions are original because there is such a wealth of complimentary custom functions out there. I wanted to take a moment to acknowledge these resources, thank the providers for them and point you to where these terrific resources are.


SUPERLOG
from NightWing Enterprises (http://www.nightwing.com.au/FileMaker/) part of the 747 collection
Allows each module to do basic auditing of selected FileMaker data entry fields. Found in almost all form views that are associated with major base tables such as clients, invoices, inventory, etc...

ADDDOLLARFORMAT
from briandunning.com (http://www.briandunning.com/cf/196 ) uploaded by Jeremiah Small of Soliant Consulting
This allows me to take number data and show it in proper dollar format in text strings like the emailing the text version of an invoice. You can see this custom function in fields like EMAIL_invoice in the invoice module or c_email_purchase in the Purchase order module.

CFTAB
from briandunning.com (http://www.briandunning.com/cf/570) uploaded by Michele Olson, AppleSauce Productions, Inc. but she acknowledges it came from the FileMaker 8 Desk Reference (another great resource)
This is used to add a tab character in text strings. You will find this used in the proposal module to indent the estimated hours and costs for project milestones.

CHECKTEXT
I guess I did create this custom function but the code was part of an example file gleaned from databasepros.com (http://www.databasepros.com/resources.html). I think there are a number of others at briandunning.com as well.
This takes a number and converts it into written text and this is used in the printing of checks from the Finance module. I did this back when FileMaker 7 was first introduced and it has been a part of InBizness SOHO since the beginning. I took the code from the example file and built a custom function out of it.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

====================== ADVERTISEMENT ==============================
For more information on the Virtual One On One Training, please visit http://www.dwaynewright.com/training.html
===================================================================

No comments: