"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below or becoming a patron!



The Philosophy of FileMaker recommends PCI!



Become a patron of this FREE web site!


Recent Blogs:

The Downside of Indexing
The Downside of Indexing

Loss of Focus
Loss of Focus

Naming Standards
Naming Standards

Restoring Find Criteria
Restoring Find Criteria

Snapshot Saves
Snapshot Saves




Create a Password Management solution!


Quick Tip:

Open Script Disabled
If you have a multiple file solution, it is possible for open scripts, specified via File Options, to not run on opening of the file. This can happen when a file is opened hidden by a related field or via a Perform Script step. Only when the hidden file is selected from the Window menu and displayed will the open script perform. The reasoning behind this behavior is efficiency. If you have to wait for an open script to run just to see data in a related field, you will have unhappy users. Also, imagine if the open script shows a dialog and interrupts what the user is looking at on the original file. The only way to guarantee an open script runs is to use the Open script step or launch the file manually.



$10.00 Beginner Video Training


Fun Stuff:

Linux
FileMaker Server briefly ran on the Linux platform but was abandoned when FileMaker 7 was released. People still request Linux support to this day.



Document Management Videos







RSS Feed
Search Results for : All
Custom Menu Creativity
Level: Intermediate
Category: General
04/09/2019
Back in college, when I was working in the computer lab on campus, it was a requirement to know Microsoft Word backwards and forwards. That's because half the students in there were creating resumes. The biggest issue was using spaces to line up columns so I spent a lot of time fixing resumes, for which I got...
Read More
Custom menus to the rescue!
Google Calendar
Level: Advanced
Category: Plug-Ins
03/19/2019
As integrators and developers, we have had many requests to integrate a client’s FileMaker solution with Google Calendar. The partnership of a customized database with the flexibility and easy accessibility of an online calendar system is ideal; events can be composed in the CRM of one’s choice, and pushed to...
Read More
Integrating Google apps with FileMaker and the gManipulator plug-in.
Noteworthy
Level: Intermediate
Category: General
02/19/2019
Ahhh... the ubiquitous notes field. Seems simple, right? In a way it is. Just slap down a field and resize it to show more data. Add a scroll bar and you're done. The problems occur when you are trying to locate an important note, print a report or perform a find. Data can be strewn all about a text field tha...
Read More
Adding notes to a record is one of the most client requested features I get!
The Beginning
Level: Intermediate
Category: Scripting
02/05/2019
Scripts that run on the opening of a FileMaker file allow you to accomplish so many different tasks. Open scripts can initialize global fields, setup variables, determine which layout to display based on security or platform, perform sub-scripts, install menu sets and so much more. This article will cover som...
Read More
Scripts that run on open of a FileMaker database is one of the most important triggers available.
Back and Forward
Level: Advanced
Category: Scripting
01/22/2019
I've always been intrigued with how to mimic a web browser's back and forward buttons... as have many other developers. While I don't usually include them in a professional solution, I do find the exercise of creating an airtight historical navigation solution challenging. I prefer well designed navigation ov...
Read More
Mimicking the back and forward buttons of a web browser is no easy feat.
Maybe You Missed These
Level: Intermediate
Category: General
01/08/2019
It was almost two years ago that the Philosophy of FileMaker released it's first article. I write new articles almost every two weeks so there's a lot of information to filter at the Philosophy of FileMaker web site. That's why I thought it would be a good idea to talk about my favorite articles from the firs...
Read More
In case you missed some of these articles from 2017.
Duplicating a Portal
Level: Intermediate
Category: Scripting
12/11/2018
Clients are always asking me why the contents of portals do not duplicate along with a record. It makes sense. Portal data looks like it's part of the parent record so it should duplicate just like the local fields, right? After explaining how relationships work, the client still wants the related data to dup...
Read More
Duplicating a record can be scripted to duplicated related data.
Triggers I Can't Live Without
Level: Advanced
Category: Scripting
11/28/2018
Script triggers often solve problems that otherwise couldn't be overcome. While script triggers are incredibly useful, don't abuse this feature or you may encounter script conflicts. Alternatives to script triggers are auto-enter calculations, manually run scripts and many other FileMaker features. Become fam...
Read More
Quick Draw McGraw!
Point in Time
Level: Beginner
Category: Calculations
11/13/2018
Just about every database contains at least one date, time and timestamp field. Just think about the housekeeping fields for starters. Every table should contain a date and time when a record was created and modified to track record maintenance. I also add manually entered and scripted date fields to almost e...
Read More
An image of a calendar and a clock.
Conditional Subsummaries
Level: Intermediate
Category: Calculations
10/30/2018
A tremendous amount of reporting power has been packed into FileMaker Pro with an incredibly easy-to-use and flexible interface. The power and simplicity behind adding and deleting parts to organize your pages almost makes it too easy to create a sophisticated printed report. However, when a subsummary group...
Read More
Conditional headers and footers can be created using a combination of calculation and summary fields.


  Previous 10 | Next 10