"No Holding Back FileMaker Blogging"


Navigation:


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



Create a Password Management solution!



Become a patron of this FREE web site!


Recent Blogs:

Abstracted Log
Abstracted Log

Decluttering
Decluttering

Multilingual Solutions
Multilingual Solutions

Why then How
Why then How

Twenty-Twenty in Review
Twenty-Twenty in Review


Meta-Consulting
Meta-consulting is a service Database Pros offers to help other developers over programming hurdles via GoToMeeting. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service.


Create a Complete Contact Manager


Quick Tip:

Indexing
FileMaker Pro indexes every word in a text field so that finds can be performed quickly. Think of the analogy of a book. Rather than trying to locate something by thumbing through each page, you look in the index and find all the pages numbers at once. FileMaker works in the same way. In order to make finds as fast as possible, the first 100 characters of every word is indexed. If you click into a field and type Command-I (Macintosh) or Ctrl-I (Windows), you can view the index of a field. Most characters are indexed but you may be surprised what characters designate a new word other than a space. The index does take up space, so if a field is not going to be searched on or used as a match field in a relationship, set the Storage Options in Manage Database to never index that field.



Create a FileMaker Calendar


Fun Stuff:

Dull Boy
FileMaker files were stored in clear text prior to FileMaker 7 so, if you opened a FileMaker file in a text editor, you could see the phrase "All work and no play makes Jack a dull boy" in the header repeated over and over. No, it's not a virus! My understanding is the developers just needed to take up some space in the header and that's what they came up with. Today, modern FileMaker files are stored in Unicode so I'm not sure if the phrase is still there.



The Philosophy of FileMaker recommends PCI!







RSS Feed
Search Results for : All
Server Optimization
Level: Intermediate
Category: FileMaker Server
07/14/2020
Just because you streamlined your solution during the design phase doesn't mean it's going to react efficiently across a LAN or WAN. You also need to optimize your hardware and network on your FileMaker Server machine. Hardware and networking are usually secondary to proper design but it can make a big differ...
Read More
An efficient network is key to serving up FileMaker databases to remote users.
Designing for Efficiency
Level: Intermediate
Category: Layouts
06/17/2020
Designing a single-user FileMaker solution for efficient display is pretty easy. If it works on your computer, it's likely to perform the same on any other computer. The trouble starts when you share a FileMaker solution with multiple people. The rules change. There's record locking for starters but I've cove...
Read More
Designing an efficient form and list view for remote users is fairly easy if you omit the bells and whistles.
Hey Nineteen
Level: Intermediate
Category: General
05/20/2020
FileMaker 19 contains some features that are going to revolutionize development. With complete Web Viewer JavaScript integration, the ability to create FileMaker apps in the Cloud and a new developer tools for copying schema from one file to another, FileMaker 19 is poised for a massive change. It's the start...
Read More
FileMaker 19 with the fancy new Pac-Man logo.
Why FileMaker
Level: Intermediate
Category: General
04/21/2020
Development platforms have come and gone but not FileMaker. Why has it been around for over three decades and why will it be around for more decades to come? If you develop using FileMaker, you probably know the answer already. Even if you do know why FileMaker is so great, I'm going to make some points that...
Read More
Why choose FileMaker for your development needs?
Merging Duplicates
Level: Intermediate
Category: Scripting
02/25/2020
A script that identifies duplicates and deletes them isn't always the best choice. Sure, it works great when you are importing new contacts from a marketing campaign but what if the duplicate comes from an overzealous or lazy employee? Sometimes you need a system for merging a new record with an old one. Whil...
Read More
Merging duplicates is often the best way to preserve all information about customer.
Twenty Nineteen in Review
Level: Intermediate
Category: General
02/04/2020
I just looked over what happened in the FileMaker world in 2019 and I'm stunned! Doesn't seem like much happened till you consider everything at once. Truly, this has been an eventful and pivotal year for the FileMaker industry. In this article, I'm going to review what happened and what is going to happen at...
Read More
2019 was a eventful and pivotal year for Claris!
Preventing Duplicates
Level: Intermediate
Category: General
01/14/2020
Preventing duplicates from ever being entered in the first place is my personal preference. Sometimes we don't have a choice and have to remove them after the fact. But, if you can stop them from ever being entered, it's going to make your life much easier. In this article, we'll discuss a variety of techniqu...
Read More
Preventing the entry of duplicate records is often the best solution.
Deleting Duplicates
Level: Beginner
Category: Calculations
12/10/2019
Database administrators have nightmares about duplicate data entry. There are tons of solutions out there. Which direction do you go? Do you try to prevent duplicate record entry with validation or scripting? Do you let the duplicates get entered and delete the periodically? And, what about merging two record...
Read More
Duplicates are a nightmare for any database adminstrator.
The Downside of Indexing
Level: Intermediate
Category: General
11/05/2019
Most people don't think about indexing when designing a solution. FileMaker automatically turns on indexing when needed so why should they? Indexing can only be good, right? I mean, it makes finds faster. Well, in most situations, indexing is nothing to worry about. But, under certain circumstances, indexing...
Read More
Indexing makes searches fast but what are the hidden downsides? BTW, this is the first page of the index from the book I co-authored, "Scriptology - FileMaker Pro Demystified".
Loss of Focus
Level: Intermediate
Category: Scripting
10/15/2019
I hear it over and over on the forums, "my Tab Control changes to the default tab when I run a script". What initially seems like an innocent little script that adds a new related record by setting a variable to a primary key, switching layouts, creating a record, setting the foreign key and returning to the...
Read More
FileMaker Tab Control objects lose focus when switching layouts. This article discusses methods for overcoming this problem.


  Previous 10 | Next 10