Article Tags

Hide tags

Click or tap one of the article tags to filter down to a smaller selection.

Our Library of Videos

839 videos found.
Sorting Columns - The expected default behavior 11/22/2004 - 6:00pm
No preview video available.

Whether you're using Mac OS X or any flavor of Windows or Linux, there's one thing you come to expect - and that's sorting list views. Can you really imagine a modern day interface which does not offer both ascending and descending views on each and every column shown in a list? I didn't think you could. Now can you expect your users to do with any less?

Adding the ability to sort on each column in your FileMaker list views is an easy task to accomplish. You simply have to think of the core pieces to the puzzle. Once you know what you need to track you can put the system together. If you can't figure it out on your own then watch this video for all the details.

Power Filterting for Portals 11/15/2004 - 6:00pm

Accessing information quickly is what it's all about. Portals present the perfect opportunity to show a smaller subset of a larger amount of data. The trick is getting the smaller subset to be recognized from the larger set. This is when we arrive at the FileMaker 7 technique for filtering portals. It's a little known trick that will let you add power filtering with little (if any) cost to the size of your database.

The older method was to break out a string of text into each of its possible combined parts. You know, "matt" would be "m", "ma", "mat" and "matt". Well, do away with the costly older method and use this new power method. Watch it now and know within minutes!

Infinite Assignments - Never ending value lists 11/08/2004 - 6:00pm

When simple related value lists just aren't enough, you have to come up with a solution that allows for the assignment of a hierarchy of values. The trick is creating a method which limits any subsequent selection to staying within the hierarchy of the parent selection. You may be working with the classification of organisms or tracking all the various parts that make up a computer circuit board. Whatever the task is, there may be a need for infinite assignments.

Working off of what we learned in Infinite Hierarchies, we can create a system which is not only structurally correct, but allows for an infinite level of flexibility!

15 Minute Tabs - The quickest way to make a tabbed interface 10/28/2004 - 7:00pm
No preview video available.

Ok, so it sounds like your standard late night infomercial, but this is real! You can add a system for managing tabs, which is not only dynamic, but also supports as many languages as you want. This is dynamic design at the best level.

Need to add a new tab? Don't waste time dragging graphics around. Just duplicate the layout and type in the name of your tab. It really can be that easy. Watch this video to learn how quick it can really be.

The Separation Model (Part 2) - Breaking up your data and interface 10/25/2004 - 7:00pm

This video article is a follow up to the first article about separation of data from interface. If you are working in a situation where many different groups or departments must access the same data, yet will want to design or create their own interface to that data, then this article has the information you need. This is also a great way to deploy a shrink-wrapped solution.

While separation in FileMaker is possible, this article provides some insight about the pros and cons of making the jump to a separation model.

The Separation Model - Breaking up your data and interface 10/18/2004 - 7:00pm

Separation is a popular topic for FileMaker Pro. The reason for this is, FileMaker Pro was never intended to be a "front end" to be used for a database "back end" - at least not in the way it is with SQL. Separation is popular because it allows for different types of front ends to be build for one common back end. One department may want feature set X and another department may want feature set Y. With separation this is possible.

Today, FileMaker 7 does allow a greater degree of separation. Keeping your data clean from ancillary calculation fields is the goal. This video will present the beginnings of how to truly separate your data from your interface.

Infinite Hierarchies - Creating a Folder Tree 10/07/2004 - 7:00pm

Folder Trees, as they are commonly known in an interface designer's vocabulary, are one of the more complex techniques to add to a database. You need to have a solid understanding of the Parent > Child relationship between records and understand how one series of inter-related records is different from any other series - all within one table. Oh, and there's that new aspect of FileMaker Pro 7 that allows for recursion within calculations.

This video presents a very powerful technique which teaches you how to create and use an infinite hierarchy of records - well, maybe not infinitely, but a whole bunch!

Portal Results - Showing search results in a portal... and more! 10/01/2004 - 7:00pm
No preview video available.

Search FileMaker help for the word "multi-key" and you'll find one page that includes it. Yet, showing what you want within a portal hinges on knowing about multi-keys. This video will show you two different techniques that use a multi-key to force a portal to reveal what you want.

The first technique uses a portal to show search results of a find. The second uses a portal to page through a large set of records. Managing large datasets within a portal can be a hazardous task in a large database, the network has to transfer the whole dataset to the FileMaker client. But thanks to Script Parameters and the new Let () function we can manage those thousands of records by showing smaller subsets. Watch this free video to learn how it's done!

Intersecting Groups - A portal filtering method 09/23/2004 - 7:00pm

There are many ways to present information. Some users are comfortable with using Find mode to look for what they want. Other users tend to be a bit more timid and look for selections they can make on screen. This week you'll find a great technique for filtering a portal. It's called Intersecting Groups and it's a great way to narrow down a larger group of records.

Using a Passwords database as an example, you'll learn how to implement and use this technique in your own solutions! You can never know too much about all the ways to filter a portal in FileMaker Pro.

Duplicating Portals 09/15/2004 - 7:00pm

To an experienced FileMaker developer, the process of duplicating a record which may have related records, such as an Invoice order, may seem trivial. The challenge is doing so without any extra fields, relationships or table occurrences. Doing this all within one script and making that script portable, so you can use it in any of your other solutions is the goal - or maybe you just want to learn how to make it happen in the first place.

Watch this video for all the information you need to successfully duplicate a given record and all of its related data.

Pages