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

Window Locking
Window Locking

Everything Changes
Everything Changes

Subsummary Unique Count
Subsummary Unique Count

Scripted Change Log
Scripted Change Log

Abstracted Log
Abstracted Log


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 Password Management solution!


Quick Tip:

Nudge 10 Pixels/Points
One of my favorite new features in FileMaker Pro Advanced 18 is the ability to nudge objects in layout mode 10 pixels/points at a time. You've always been able to move objects one pixel/point at a time using the arrow keys on the keyboard but now you can throw in the Shift key and nudge them 10 pixels/points at a time. I use it when I want to object to move in one direction horizontally or vertically. The mouse is just not accurate enough and often ends up moving the object both horizonally and vertically.



FileMaker 20 Video Tutorials


Fun Stuff:

FileMaker, Inc.
FileMaker, Inc. or FMI is a wholly owned subsidiary of Apple, Inc. It was once named Claris when it also sold MacWrite, MacPaint, Claris Emailer, ClarisWorks, etc. but changed it's name in 1998 when it focused on FileMaker. FileMaker started out as a DOS application called Nutshell but was shaped into the powerhouse it is today by Claris and FMI.



Tips & Tricks Videos







RSS Feed
Search Results for : All
Removing Text Formatting
Level: Beginner
Category: Calculations
11/03/2020
Almost every single solution I develop requires a method for dealing with text in fields that is purposely or accidentally formatted in browse mode. For better or worse, FileMaker allows users to change text formatting in browse mode via the Format menu. FileMaker also doesn't automatically remove formatting...
Read More
Formatting text in browse mode overrides layout settings.
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!


  Previous 10 | Next 10