Article Tags

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

Our Library of Videos

839 videos found.
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.

Tagging Duplicates with a Calculation 08/02/2003 - 7:00pm

It's the age old question most commonly asked about a database that manages data from multiple sources. "How do I remove duplicates?"

As always, there's more than one road into Rome, and you can tag duplicates using a script or by disallowing them into the database upon import. But when you need to visually see the duplicates and compare records based on the most recent then you need the easiest and best way possible. That's where this article solves the problem. Watch this video and use the technique file to see how it's done.

Interface Plugins with a Powerful Punch 08/01/2003 - 7:00pm
No preview video available.

FileMaker Pro can only go so far when pushing the limits of creating that true "custom software" look and feel. The Replace menu option is the bane of every developer who forgets to disable it.

In this video and text article I take a look at two powerful plugins that allow you to customize your FileMaker Pro user interface to the level of professional applications. You can create your own menus with MenuControl and associate them to your own scripts and you can use SimpleHelp to add the equivalent functionality of Tool Tips.

Pages