Article Tags

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

Our Library of Videos

842 videos found.
Interface Tips: A Better Look & Feel 10/31/2003 - 6:00pm
No preview video available.

Giving your interface a bit more depth is what creates an attractive look and feel. There are more than a few tips to making things look great in a FileMaker Pro layout - this video covers a few of them.

Watch this video to learn how to break down your interface and improve its usability. Learn how to make quick and easy divider lines and how to give your fields that extra "breathing room" they so often desire.

Video Data Rate = 18.5 K bytes/sec

Dynamic Portal Display 10/23/2003 - 7:00pm

You don't always have the screen real estate necessary to show all the data you might otherwise pack into a portal. But that's ok, you can always use a dynamic portal display to show only the data a user chooses to view.

This powerful technique optimizes how you show information within a portal and allows you to maximize your screen real estate. You'll also learn a very easy method for sorting portals.

A Universal Portal Search 09/25/2003 - 7:00pm
No preview video available.

You're not always in the correct file, within a list view that allows for easy searching. Even beyond that, not all users of FileMaker Pro are familiar with creating multiple request searches.

The easiest solution in this situation is to provide Universal Portal Searching. It's like Google for your portals. The user enters search criteria into one field and results are provided based on searching many fields. Use this video article to learn a powerful technique for searching portals.

Date Ranges: The Best Solution 09/18/2003 - 7:00pm

Figuring out the sum total of hours an employee has worked for a specific range of dates seems like an easy thing to do. You know how to use the Sum() function but you're finding it hard to break down the dates according to pay periods.

It sounds easy, but it's actually a bit harder than it sounds. A few companies have released plug-ins that generate ranges of dates. But then there's that limitation that FileMaker has with text fields only able to support 64,000 characters. Wouldn't it be nice if you could span across a date range as wide as 1/1/0001 through 12/31/3000? Well, watch the video and you'll learn how to support a range of over 3,000 years!

Secured Access: The Simple Way 09/11/2003 - 7:00pm

You've wondered what the Halt, Exit, Resume and Pause options are when assigned to a button with Perform Script. You also need basic password access to lock off certain areas of your user interface. What do you do?

You watch this video and use the associated file to learn about the easiest solution to add secured access to your files. You can lock off areas of your interface, such as configuration and controls or you can limit access to layouts with sensitive data. By forcing the user through a locked process you can exercise the control you know you need.

Operation Code Cleanup 09/04/2003 - 7:00pm
No preview video available.

How do you make calculation code more clean? Have you ever seen the CodeCleaner 3000 for FileMaker Pro? Probably not. This means it's up to you to both write and format clean code.

In this video article I walk through a cleanup process where I take some original code and make it more clean. I remove some redundancy and also tighten things up. Making your code more readable is what this article is about and along the way you'll learn how to work with time values that calculate past 12:00 midnight.

The Other Parent/Child Relationship of Databases 08/22/2003 - 7:00pm

In this video article you'll find information about one of the most fundamental aspects of linking records together to create a hierarchical chain of associated records. Ever wonder how you can keep track of a part that has many subparts in which those subparts may have many subparts themselves? This is the article to teach you.

Watch this video and comb through the associated file to gain a solid understanding of working with hierarchies in databases.

Date Math Calculations 08/16/2003 - 7:00pm

Working with dates can seem like a confusing endeavor at first. But after you know which pieces to go after, you can easily put together your own calendar application or any other solution that requires date based calculations.

This video article covers the essential parts to working with dates and making the calculations work within the realm of user-friendly features. Learn how to date-shift a work week and how to turn a popup day value into a number needed by date calculations.

Changing Date Fields with Key Combinations 08/10/2003 - 7:00pm
No preview video available.

This video article is a short walk through of a useful technique that shows you how to use key combinations to quickly increment and decrement the values in a date field.

The technique also exposes you to a universal approach to scripting, where one script will function in multiple situations. Learn the power of creating a universal script.

Using File Paths to Launch External Files 08/08/2003 - 7:00pm

Because a database typically contains information about a wide variety of elements, it's not uncommon to need to interact with other files, and sometimes applications, outside of FileMaker Pro. Prior to Version 6 this required the use of a third party plug-in.

If you're using FileMaker Pro 6 then you have access to a new function called Status(CurrentFilePath). In this video I take a look at maximizing this feature and providing the whole range of services that can be used. You can launch a local file, a file from a shared file server, another FileMaker Pro file on a FileMaker Server, a URL or even open another application or folder. This powerful solution is extremely useful if you need to interact with any other files stored outside of FileMaker Pro.

Pages