"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:

Duplicating a Portal
Duplicating a Portal

Triggers I Can't Live Without
Triggers I Can't Live Without

Point in Time
Point in Time

Conditional Subsummaries
Conditional Subsummaries

Calendar Conundrum
Calendar Conundrum




Tips & Tricks Videos


Quick Tip:

Dangers Of The Find/Replace Feature
The Find And Replace feature has a serious a downside. I don’t want to be dramatic but I remember when I had seen it introduced at a FileMaker developer meeting in Seattle, I was shocked more by the dangers than the benefits. Imagine users being able to find and replace across all the fields on a layout in the found set without being able to to undo. Yikes!



Create a Complete Contact Manager


Fun Stuff:

The Wedge
Claris Corporation and the FileMaker, Inc. have been housed in a building called the wedge in Santa Clara, California since they spun off from Apple, Inc. The building is nicknamed the wedge because it looks like a wedge. For some years they had an adjacent building called the interstitial but it was let go when the company downsized to focus on FileMaker products.

The Wedge



Create a Password Management solution!







RSS Feed
Search Results for : All
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.
Calendar Conundrum
Level: Intermediate
Category: General
10/16/2018
Everyone wants a calendar in their FileMaker solution these days. There's tons of web viewer solutions out there for purchase that will integrate well with your FileMaker solution. There's even plug-ins to integrate with iCal or Google Calendar. What I'm going to give you today is a taste of how to build a ca.
Read More
An image of a calendar.
Themes Rule
Level: Beginner
Category: Layouts
10/02/2018
Before you create any layouts, you need to decide on a theme. Choosing a theme is one of the most important decisions you will make for a project. Themes define the user experience more than any other feature in FileMaker. Buttons, backgrounds, Fields, Tab Controls, Portals, Popover Buttons, Slide Controls an.
Read More
The themes dialog in FileMaker.
Weight Lifting
Level: Advanced
Category: Calculations
09/18/2018
This technique has no real use in the real world. Say what? Yes, you read that correctly! Think of the technique I'm about to cover as weight lifting for your FileMaker mind. It's about solving a complex problem, learning new scripts steps and functions, and generally getting smarter so the next time you tack.
Read More
A weight lifter building muscle.
Form Letters in Browse
Level: Intermediate
Category: Calculations
09/04/2018
Empowering users of your solution to create their own form letters is life-changing. No longer do they have to contact the developer, explain their needs and go through a back-and-forth testing stage. The developer just designs a single interface that allows the user to create, save, edit and delete their own.
Read More
The earliest form letter via the Gutenberg press.
Context and Relationships
Level: Beginner
Category: Relationships
08/07/2018
Context is everything! Haven’t you ever had something you said taken out of context and then tried, desperately, to figure out how to get yourself out of the hole you just, inadvertently, dug for yourself? The same goes with relationships. In life, as in FileMaker, they can be tricky and, if you don’t know.
Read More
Parsing for Features
Level: Advanced
Category: Calculations
07/24/2018
Data parsing isn't just for manipulating data into a preferred format. You can also create features that weren't otherwise possible with standard FileMaker tools. That's one of the things I love about FileMaker. Instead of giving you a one-dimensional menu item to support a specific need, like Microsoft, FMI.
Read More
Data parsing with FileMaker text functions can create features that weren't otherwise possible.


  Next 10