Jump to content


FileMaker Weetbicks

Unlocking Hidden Error Messages in the ExecuteSQL Function

Posted by Daniel Wood, 06 January 2015 - - - - - - · 163 views

Hi all,

Just posted the first FileMaker Weetbicks article for 2015 about a neat hidden feature of data viewer and the ExecueSQL function which allows you to get meaningful error messages when debugging SQL queries used with the function.

You can check it out here - Unlocking Hidden Error Messages in the ExecuteSQL Function

Look forward to pe...

Proper Printing in WebDirect

Posted by Daniel Wood, 15 August 2014 - - - - - - · 415 views

FileMaker WebDirect is the exciting new replacement to Instant Web Publishing. With it you can access your database via a web browser and do *almost* all of the things that you can do in FileMaker Pro. However proper printing is not one of them. In this article we present a framework and example file for doing proper printing via WebDirect - from basic re...

Creating New Records in a Portal With a Twist

Posted by Daniel Wood, 23 July 2014 - - - - - - · 361 views

When it comes to creating child records records in FileMaker we have a couple of different options available. The first is to enable “Allow creation of records via this relationship” on the relationship graph. This displays an empty set of fields in the last portal row so that the user can enter data and create a record. The second method is to create a...

Popovers that Open and Close on Mouse-Over

Posted by Daniel Wood, 06 July 2014 - - - - - - · 257 views

In this followup to the Sliding Drawers article, we take the technique one step further and apply it to the popover object. We discuss the differences between drawers and popovers in relation to the mouse-over technique, and how the process has been modified to better suit popovers...

Click to read the full article here…

A Sliding Drawer that Opens and Closes on Mouse-Over

Posted by Daniel Wood, 01 July 2014 - - - - - - · 379 views

The slide control is an exciting new layout tool introduced in FileMaker 13. In this article we are building an animated sliding drawer that responds to the users mouse position to open and close. There are a number of cool techniques and features being used to achieve this effect so check it out!

Check out the full article here!

Sending Email from FileMaker using Mandrill

Posted by Daniel Wood, 21 March 2014 - - - - - - · 489 views

UPDATE 27 March: The demo file included with the article now supports Insert from URL ! Both plugin and Insert methods are available in the example file. The article has also been updated to reflect this.

When sending Email from FileMaker the most popular methods are the 'Send Mail' script step or a plugin. In this article we explore another method thro...

A Portal Grey Area

Posted by Daniel Wood, 17 March 2014 - - - - - - · 224 views

A grey fill on the active portal row. For years it has been something that simply 'was'. Well no longer. In FileMaker 13 we can finally easily eliminate this rather annoying design feature, and take back full control of portal fill colours...

Check out the full article here: http://www.teamdf.co...-grey-area/223/

Big Tabs!

Posted by Daniel Wood, 12 February 2014 - - - - - - · 303 views

Building FileMaker solutions for iOS introduces a new set of challenges for developers and requires UI controls that make it easy for users to interact. This article gives a very quick and simple technique you can use to make selecting tab controls much easier for FileMaker Go users on iPad and iPhone.

Read the full article here: http://www.teamdf.c...

Even Cooler Inline Labels

Posted by Daniel Wood, 13 December 2012 - - - - - - · 690 views

One of the cool things that conditional formatting has allowed us to do ever since its introduction in FileMaker 9 is to build inline field labels that become hidden when the field contains text. With the introduction of field state formatting in FileMaker 12, we can take these inline labels even further and make them even more awesome.http://www.teamdf.c...

Weetbicks Gone Wild (and portals…)

Posted by Daniel Wood, 29 August 2012 - - - - - - · 745 views

You may have noticed a lack of article postings over the last couple of months, and fewer articles overall this year. Please don't panic for it has not been through laziness or lack of content. Instead, I have been somewhat pre-occupied with other things that I would like to share with you...

Weetbicks Trivia 1.0

Posted by Daniel Wood, 02 July 2012 - - - - - - · 605 views

A little while ago I received an e-mail asking for ideas on how to implement a multiple choice testing database. It just so happens that I had begun to build a database a few years ago which does just that. While it is not finished, I have decided to release a first version for people to download, dissect and...

Sweet Scrolling in FileMaker 12

Posted by Daniel Wood, 13 May 2012 - - - - - - · 884 views

Portal scrolling has always been a bit of a struggle in FileMaker Go up until the release of version 12. This article outlines some of the changes to portal scrolling in FileMaker Go 12 and we give a couple of examples how it can be set-up to give a very nice native-application look and feel. We also cover field...

Cool things to do with Tab Controls in FileMaker 12

Posted by Daniel Wood, 12 April 2012 - - - - - - · 941 views

FileMaker 12 is here, and with it comes many new cool new features, a lot of which are a result of the new css-based layout engine. In this article we are focusing on one small change borne out of the new layout engine which has massive potential for building new interface...

Tips & Hints - Scripting

Posted by Daniel Wood, 04 March 2012 - - - - - - · 636 views

This is the third article in our series of tips and hints for FileMaker. This time we are focusing on scripts - from their creation, to editing and debugging. Take it as it is - this is just an assortment of our favorite time-savers, shortcuts, tips, hints, tricks, tools of the trade and...

A 'Local' Way to Suppress Script Triggers

Posted by Daniel Wood, 10 February 2012 - - - - - - · 679 views

Script triggers are a great feature in FileMaker that allow you to initiate a script when certain actions occur such as committing a record or leaving a layout. Not only do they run when user initiated, they can also be script initiated by script steps. This can sometimes produce unexpected results and so you may wish for triggers to be disabled. This...

Tips & Hints - The Relationship Graph

Posted by Daniel Wood, 30 January 2012 - - - - - - · 592 views

In this second article in our series of tips and hints we focus on the relationship graph. Take it as it is - this is just an assortment of our favorite time-savers, shortcuts, tips, hints, tricks, tools of the trade and more…

Click to Read the Full Article…

Tips & Hints - Layout Mode

Posted by Daniel Wood, 25 January 2012 - - - - - - · 681 views
This is the first in a series of articles that will present some useful and time saving tidbits for various areas of FileMaker. In this first article we focus on layout mode. There is no rhyme or reason, no common theme - just an assortment of our favorite time-savers, shortcuts, tips, hints, tricks, tools of the trade and...

Printing Records With Different Output Designs

Posted by Daniel Wood, 15 November 2011 - - - - - - · 844 views

Most of the time when we print records in FileMaker, the output of every record appears pretty much the same, with similar formatting and design. But what if we want records to print with a completely different output design depending on the type of record? In this article we detail some of the various ways in which this can be achieved, and the pros and...

Integrating Kiosk Mode into your Solution

Posted by Daniel Wood, 07 October 2011 - - - - - - · 788 views
Kiosk mode is a cool way to run a FileMaker database in a full screen environment where users are prevented from accessing the other functionality of the operating system. But what if you have a normal FileMaker solution and wish to use kiosk functionality in certain areas only?

In this article we illustrate how a typical FileMaker solution can be...

Simple Truncated Displaying of Long Lists (+more)

Posted by Daniel Wood, 24 August 2011 - - - - - - · 476 views

Displaying a long list of items on a layout generally means that the majority of the list is hidden from the user until they click into the field, with no feedback as to the size of the list. This article details a nice technique you can use to present the same list in a truncated style that gives live feedback on the number of items.

FMForum Advertisers