"No Holding Back FileMaker Blogging"


Navigation:


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



Tips & Tricks Videos



Become a patron of this FREE web site!


Recent Blogs:

Everything Changes
Everything Changes

Subsummary Unique Count
Subsummary Unique Count

Scripted Change Log
Scripted Change Log

Abstracted Log
Abstracted Log

Decluttering
Decluttering


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.


The Philosophy of FileMaker recommends PCI!


Quick Tip:

Type Ahead
When you are in a dialog trying to locate a field in a long list, don't forget about type ahead. Just click on any field so the field area is active and then type the first few characters of the field name. When in Manage Database, make sure you are viewing fields by field name so they are alphabetically arranged.



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.



Tips & Tricks Videos







RSS Feed
Search Results for : All
Nineteen Point One
Level: Intermediate
Category: General
10/06/2020
You've all heard it's going to happen! Releases every quarter rather than every year. Even yearly releases were a shock given the multiple years between release in the previous decade. It may be uncomfortable but it's necessary with the way technology moves in the current day and age. You'll get less with eve...
Read More
JavaScript Add-Ons are probably the most impressive new feature in FileMaker 19.1.2!
Transactional Processing
Level: Advanced
Category: Scripting
09/08/2020
Record locking in a multi-user scenario is easy to control on a single record. Just use the Open Record/Request script step and test for an error 301. If the error occurs, stop the script and present a dialog telling the user they can't run that script right now. If no error occurs, the current user now has c...
Read More
Transactional processing is one of many methods for reacting to record locking when multiple records are in question.
Conditional Tab Control
Level: Intermediate
Category: Scripting
08/11/2020
The story to this solution begins with a client of mine who has complicated contact management needs. Each contact falls into a particular category and not all panes in the Tab Control object need to be shown for each contact. I started off by offering a conditional formula on a standard Tab Control object th...
Read More
Conditional Tab Controls using Buttons Bars and Slide Controls.
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.


  Previous 10 | Next 10