|
|
|
Search Results for : All
|
|
|
|
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
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
Just about every serious FileMaker developer has their own personal naming standards for fields, scripts, tables, layouts and anything else that can be named. There's really no correct naming standard. It's all about what works for you and your development style. Still, you need somewhere to start. I'm not ju... |
|
Read More
|
|
|
|
|
|
|
Let me start by saying, this is the most complex technique in the series of five articles covering the restoration of found sets. The sequence started with an explanation of why it's important to save found sets, followed by simple solutions like creating new windows and collecting serial numbers. I even cove... |
|
Read More
|
|
|
|
|
|
|
According to the FileMaker online help, the Snapshot Link feature saves a found set of records. But, it saves so much more including the current record, layout, sort order and the mode. The basic idea is to save a Snapshot Link and send it to a colleague via email so they can see what you are viewing. So much... |
|
Read More
|
|
|
|
|
|
|
Don't be a one-trick pony and apply the same FileMaker feature to solve every problem. That's like wearing a tool belt and only putting one tool on it. FileMaker has many options, each with it's own unique advantages and disadvantages. Over-relying on a single tool will result in a subpar solution. Try to lea... |
|
Read More
|
|
|
|
|
|
Next 10
|
