Category Posts: FileMaker

Dynamic Compound Finds with FileMaker and PHP

The default behavior for FileMaker’s PHP API find requests is “AND.” Enter multiple criteria in the find request, and FileMaker treats this it as a “Find records where A = ‘this’ and B = ‘that’ in the request. But what happens if you need to search using OR? The PHP API documentation states that you [...]

Posted in FileMaker | Tagged , , , | Leave a comment

FileMaker Go Quick Tip #35: Field Interaction Behavior

Thought I would share a quick tip that I learned while working on a mobile database application for a customer. Naturally there are many user interface behavioral differences between the desktop and mobile versions of FileMaker. This one involves the display of a field when the field has focus. Here are two screen shots of [...]

Posted in FileMaker | Tagged , , | 2 Comments

Virtual List in Three Easy Steps

The Virtual List technique has been around for a few years (created by Bruce Robertson ca. 2009). Over time and with changes to FileMaker, implementation of this technique has evolved. Knowing how to set up and use virtual lists will help with creating certain reports, especially if you draw the values from ExecuteSQL statements in [...]

Posted in FileMaker | Tagged , , | Leave a comment

FM Academy Presents: A FileMaker Ecosystem: From Desk to Web to Mobile

Join FM Academy for a free webinar showcasing the FileMaker Ecosystem. During the webinar we will demonstrate the many ways in which a FileMaker database can be accessed directly by users as well as other systems. We will discuss the 4 major ways in which a FileMaker database can interact with users and systems and [...]

Posted in FileMaker | Tagged , , , | Leave a comment

Gotcha #87: GTRR and the Modal Dialog Advanced Window Style

Here is small development gotcha regarding FileMaker 12 advanced window styles. If you create modal dialog window, and then execute a Go To Related Record (GTRR), creating a new window from the modal dialog, the window style of the new window must also have an advanced style set to modal dialog. You might want to [...]

Posted in FileMaker | Tagged , , | 4 Comments

Getting Started with QuickBooks Integration

Intuit’s QuickBooks software organizes business information: contacts, vendors, orders, invoices, inventory, and more. Many small businesses use QuickBooks as their back-end accounting software, alongside FileMaker. Often these two applications perform separate functions, but sometimes there may be a need to integrate them. I’m going to briefly discuss one such method, using the FM Books Connector [...]

Posted in FileMaker | Tagged , | 1 Comment

Happy St. Patrick’s Day!

Posted in FileMaker | Leave a comment

FM Academy: Building a Powerful Business Solution on a Budget

For those of you who missed the presentation, Building a Powerful Business Solution on a Budget, by John Mathewson, President and co-founder of Kyo Logic, the webinar video is now available for review. We are working on a schedule for our next presentation and hope to have something announced soon. Check the FM Academy website for [...]

Posted in FileMaker | Tagged , , , , | Leave a comment

Pro/Con: Using Tab Panels for User Interface Pop Ups

FileMaker 12 includes significant changes to tab panel objects that make using pop-up overlays far easier to implement. Now, tab panels are “less sticky” and can be moved freely around a layout without the risk of inadvertently picking up objects that were not intended to be contained in the tab panel. Our colleague Daniel Wood [...]

Posted in FileMaker | Tagged , , | 6 Comments

Are You Ready for Coaching?

Consider team sports. They consist of players on various surfaces and sizes of environment (fields, courts, pitches, etc). The player performs the actions that directly affect whether the team wins or loses. Although not directly involved in the action on the field, virtually every sport includes a coach, someone who comes up with the game [...]

Posted in FileMaker | Tagged , , , , , , , , , , | Leave a comment