Building A Custom Menu (part 1)

From Dwayne Wright -

Say that you want to give your users a custom menu at the top of your FileMaker solution? I do this all the time. In fact, sometimes I want to have a custom menu available for each main entity within a solution. If the user is in a layout that is using the clients table, I want a Client menu at the top with available operations specific to client data. The same can be true for layouts using the invoice table, the inventory table or the correspondence table.

The ability to create custom menus is a FileMaker Advanced feature. Before custom menus, you could have custom features available under the Scripts menu but you couldn’t dynamically control what scripts would show under what conditions. As of FileMaker 9 Advanced, you cannot dynamically control custom menus either but by scripting you can change what custom menu is being used at any point in time.

So before you start creating the menu, how about a little planning first? Think about what you want to see under the new menu. Let’s say that we are going to create a custom menu with the user is within any of the layouts that are using the invoice table. Here are some ideas of things you might want to add ...

New Invoice
Duplicate Invoice With Line Items
View Related Inventory Items
Print Current Invoice
Print Invoices In Found Set
Apply Payment To Invoice
Create Related Credit Memo
Create Related RMA
REPORT: Invoices With Balances
REPORT: Invoices Past Due

Wow, that would be custom menu that many professionals that have to work with invoice data may really appreciate! Only one of these may not be script related, that is new invoice. You might be able to rename the New Record menu item to do this for your invoice module. However, you probably would want to have this all script related.

(to be continued)
More info about the author and FileMaker in general, contact me at

© 2007 - Dwayne Wright -

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.