[Forums]  [Store]  [Cart]  [Resources]  [Learning]  [About]  [Solutions]  [Consulting]  [News]  [Links]

Questions s Coffee cups indicate the complexity of a file, tip or article. One coffee cup is the easiest and three is the most advanced. To download a file, click on the green arrow icon next to the listing. If there are no coffee cups or platform icons, the listing may be an article, Quick Tip, Knowledgebase or bonus file.

Displaying 1...10 of 368 Resources found  [Another find]
Card Picker    Download   Intermediate   Tip File    Version 16
Window Card Picker to Replace Value List
databasepros.com/list.php?resource_id=DBPros001210
Window Cards in FileMaker 16 are a cross between a custom dialog, a layout and a popover. This example demonstrates how to use a Window Card as a picker. WHile a popup menu is easier to setup, a picker is easier to work with when there are long lists. The picker has been designed to work with keyboard commands only, allowing for filtering, navigation and selection via keyboard equivalents.
DevCon 2005 Presentation    Download   Intermediate   Tip File    Version 11
My FileMaker Developer Conference Presentation
databasepros.com/list.php?resource_id=DBPros000656
If you missed the 2005 Developer Conference, you can still view the slides and files I used in my Philosophy of Scripting and Philosophy of Calculations presentations. I covered creating a monthly calendar with one relationship, no scripts, and no calculations. I also showed how to color the portals in a monthly calendar without any overhead in the child file or scripts or calculations. I also demonstrate how to use GetNthRecord to accomplish tasks faster and better. There is a lot of FileMaker 8 material, but a good portion is FileMaker 7-only.
DevCon 2006 Presentation    Download   Advanced   Tip File    Version 11
My Presentation from the 2006 Developer Conference
databasepros.com/list.php?resource_id=DBPros000733
I gave two presentations at the 2006 Developer Conference but one was for a class so I can't post it. What I can post, however, is the calendar solution I created in my second session. I have included the actual file, which I created in a little over an hour from scratch, in addition to a more complete solution that I used as a guide for the session. I also include an article, an outline and the commercial version of the solution. So, if you are trying to create a calendar solution or to understand how to modify my commercial version of the calendar, this download will really help you.
No Style    Download   Intermediate   Tip File    Version 11
Remove Text Formatting with a Calculation
databasepros.com/list.php?resource_id=DBPros000613
FileMaker Pro 7 calculations preserve text formatting from referenced fields -- which can be good and bad. Unfortunately, it is not possible to remove all font characteristics using the Text Formatting functions. Here is a simple formula demonstrating how to remove text formatting including font type, size, style and size. This technique is not necessary in FileMaker 8 using the TextFormatRemove function.
Object Script Triggers    Download   Intermediate   Tip File    Version 11
A Compilation of Script Trigger Techniques
databasepros.com/list.php?resource_id=DBPros000921
This technique file is the example I used when creating FileMaker 10 videos for FileMaker, Inc. It includes object script triggers demonstrating navigation, carriage return prevention, validation, history of field level changes and filtering a list view.
Preferences    Download   Advanced   Tip File    Version 12
Create Multi-User Preferences using ExecuteSQL
databasepros.com/list.php?resource_id=DBPros001178
This file demonstrates how to create a preferences section for a multi-user scenario with a different set of preferences for each account. Prior to ExecuteSQL, multiple table occurrences were needed to access the information from each source table. This file will show how to reduce the number of table occurrences in your solution using ExecuteSQL.
Seventeen    Download   Intermediate   Tip File    Version 17
New Features in FileMaker 17
databasepros.com/list.php?resource_id=DBPros001235
This example file shows off most of the new FileMaker 17 features for the desktop including multiple email attachments, default fields, found set portal or master-detail layouts, Perform Script by Name and Get(ActiveRecordNumber). Read the blog article and watch the companion videos at the PhilosophyOfFileMaker.Com web site.
Two Column Portal    Download   Intermediate   Tip File    Version 17 New
Create an Interface for a Two Column Portal
databasepros.com/list.php?resource_id=DBPros001249
This fairly simple set of calculation using Get(RecordNumber), GetNthRecord and Case functions allows you to display two columns in a single portal. Why would you want to do this? It's really for specialized interfaces where you are trying to optimize the amount of information displayed on screen. Think of those multi-column phone lists you used to pin on your cubicle wall as a metaphor.
Web Viewer Examples    Download   Intermediate   Tip File    Version 11
Many Examples of How to Use the Web Viewer
databasepros.com/list.php?resource_id=DBPros000757
I created this web viewer example for my video training -- so there are simple, intermediate and advanced examples in this download. Examples include Google maps, web searches on Google, Wikipedia, Wikinews and more, package tracking with web scraping and PDF display from a local hard drive with the choice of PDF coming from a standard FileMaker open dialog.
Add at Top    Download   Intermediate   Tip File    Version 11
Allow Addition of Rows to Portal at the Top
databasepros.com/list.php?resource_id=DBPros000992
Uses Filtered Portal for entry into child table using a relationship with Allow creation of Record. The filter on the portal is set to 0. Which is Always false and will not display any child records. Therefore it always looks like a blank slate to enter in a new entry. Thanks to John A for submitting this technique.

Next

Philosophy of FileMaker Blog