ISO FileMaker Magazine

There's this special feeling you get when developing software where you feel like you've created something magical. Sometimes, it doesn't even matter if you've done the same type of thing before. It just feels like you're the master of the universe and you've created something super useful.

This may even be the case when you're simply creating a virtual trash can and providing users with the ability to reverse course on that accidental record deletion.

In this video, we're taking a look at a super simple trash can metaphor. It's easy-to-implement and allows users to bring records back from the dead.

While there are multiple ways to handle record deletions, many of which are discussed in this video, the whole concept of being able to dig in the trash and take something out is familiar territory for many computer users. We're just going to emulate it within our FileMaker systems.

What do the following have in common? Products with component parts, generations of people, complex study topics with prerequisites and a chain of historically related events. Yep, you guessed it, it's a hierarchy of things. Something which comes before another thing and are somehow tied together.

Within any database system, this is easily accomplished with two simple fields. Yet, facilitating the navigation of the content can be accomplished in a number of ways. One of the more common methods for moving up or down any hierarchy is to use what are known in the UI world as breadcrumbs.

When your number of levels is beyond two, you can implement breadcrumbs into your user interface and provide a lot of UI coherence. In this video, we walk through the data structure as well as what's required to use FileMaker's tab panels in order to accomplish this task in the most efficient manner. If you're taking users down (and up) any hierarchy, then you need to know how to use this technique! This video and the technique file will provide you with all the know-how and code to get it done.

There are all kinds of methods for using indicators within FileMaker. We have multi-segment button bars, using the Hide calculation on any number of layout objects and, of course, there's simply using text alone to indicate something. In one of my more recent projects, I needed to group duplicates together.

While normally you'd want to rid your system of duplicates, this particular use case actually wanted them retained as an indication of importance or urgency. So, what was really needed was a method to indicate which members were part of a duplicate group or not.

Within this video article you'll find a very good use of a variety of methods to identify a duplicate and then indicate if it's part of a group of duplicates.

If you've ever have a need for this type of display, you're in luck. And, even if you don't, you'll learn how you can make one record aware of its neighbors. Of course, what you do with that information is between you and your records. ;)

Hopefully, we can all agree that when something is more fully refined, it's the craftsmanship which showcases the higher quality of the work. The time and effort put into making something that much cleaner and that much more efficient.

Such is the case with enhancing FileMaker's portals. Sure, you can use portals as they're provided, and you'll certainly get all the benefits of using them "as is". But, what happens when you want your solution to be that much easier to use and that much more impressive?

That's when you take the opportunity to enhance your portals such that they're more attractive and more user friendly. In this video, we take a look at the various steps you can take to make your portals a bit more attractive and in most cases more useful.

Over my many years of working with FileMaker Pro, I've often talked about adding in a multiple selection feature. Whether working within FileMaker's List View or working with portal rows, this can be a critical feature for allowing users to make selections and then being able to take some type of action against that selection.

Whatever the desired result is, such as processing the data, saving the set, or just being able to see a set of selected records, knowing what your options are, and how to implement is certainly worthwhile.

In this video, I walk through the use of a variety of custom functions and show the multiple options possible when considering a multi-selection technique for record rows. This video is great tool for understanding what can be done and how to implement a multiple-selection strategy.

Over the years, I've created a number of videos which showcase saving the state of various situations. For example, saving how many and which windows a user has open, saving the window positions and also saving the state of which panels are selected on multi-panel objects. Such as tab panels and sliders.

In this video, we revisit the topic because we now have a newer function within FileMaker 18 which makes it even easier to save which panels are frontmost within your user UI. While I personally think this is something FileMaker should do natively, it's currently under our control. With a little bit of code, we can easily keep track of which panes are frontmost and then restore those panes when navigating through the solution.

If keeping things clean and easy for your users is something you desire, then this video will have both the sample code and the instruction you need in order to take full advantage of FileMaker's While() statement and how to keep track of what's going on in the UI while the user is using it.

As the number of web sites hosting icon collections has grown over the years, it makes little sense to have your own collection of icons custom created at a costly premium. Typically, you can find pretty much any icon you could ever want to use and in many cases, you can even modify the icon to fit your specific needs if you need a slight variation.

With the release of Creative Commons licensing, a wide array of freely available collections and the easy ability to modify icons, you can quickly create exactly what you need for most any FileMaker app.

In this video, I go over the recently released Elemental FM Icon database and I cover all the details and specifics about my own personal icon workflow. From finding the right icon to getting it into FileMaker quickly, you'll learn all kinds of information about working with SVG icons.

It's just like when you see someone who is well-dressed, clean and sharp looking, your FileMaker user interface is no different. You're more impressed by that sharp, clean look. In this regard, not having something on your user interface is quite possibly one of the very things which makes your user interface look that much cleaner.

Portals and list views, pretty much anything which repeats itself many times, can be very overwhelming when there are a lot of options. Quite simply, if there are too many buttons, it's too cluttered.

In this video, we talk about getting those buttons off your user interface and making them available only when needed. It's a great way to start to clean up your user interface and make sure that certain option are only available after the user has made the selection of where they want to go next.

It's a simple concept, but one which is often ignored by newer developers because the examples they are shown do not take advantage of the opportunities to hide these types of buttons. So, we end up with FileMaker solutions which are littered with buttons on every list view row and every portal row. So, let's get rid of them until they are needed!

FileMaker Pro provides a more than capable UI surface in order to design great looking user interfaces. In fact, it's the speed with which you can create that user interface which makes FileMaker Pro so appealing. The great thing about recent releases has been the flexibility of the newer layout objects.

When you combine the utility of sliders, tab panels, popovers and layout mode's various layout parts, you can further extend what you can do within FileMaker by quite a bit.

This video presents the top five tips and tricks you can accomplish with offscreen options possible with both native layout widgets and layout parts. If you're looking to increase what you know about how you can make creative combinations within FileMaker's presentation layer, then look no further!

It's a curious question and the answer may be good or bad depending on your perspective. "Why doesn't FileMaker have a time picker?". It has a calendar widget for working with date fields, why not time values?

The solution to the problem, as is often the case, can be managed by simply creating your own picker. In fact, if you don't like FileMaker's desktop based date picker you can create any variation you desire based on being able to create any style of layout you can imagine. While the same applies to a time picker, it may not be obvious how to implement if you've not worked with FileMaker for some extended amount of time.

In this video, I showcase a straight-forward time picker which works with both timestamp fields and time fields. It also includes some valuable utility scripts and concepts which can certainly be used in other areas of your FileMaker solutions. If you've ever come across the need for a time specific picker then adding this to your solution should save you a ton of time!