"No Holding Back FileMaker Blogging"


Navigation:


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



Holiday Video Training Promotion



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




$10.00 Beginner Video Training


Quick Tip:

Semi-Sorted
A database can either be sorted, unsorted or semi-sorted. The first two are pretty obvious, but it is less clear how a database becomes semi-sorted. A database becomes semi-sorted when a new record is added to a currently sorted database and the option to keep records sorted is unchecked. It can also become semi-sorted if a record is edited -- but only if one of the fields used in the sort is edited. Deleting a record will not make a database semi-sorted.



Create a Complete Contact Manager


Fun Stuff:

Jaymo
David Knight (aka Speedy) started calling me JoMo years ago, because of my initials, and it kinda stuck. Over the years, it's evolved to the current Jaymo but you can call me anything as long as you are friendly. Other nicknames include Hoss, n2 and Wiz.



The Philosophy of FileMaker recommends PCI!







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