"No Holding Back FileMaker Blogging"


Navigation:


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



FileMaker 20 Video Tutorials



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.


Tips & Tricks Videos


Quick Tip:

Context Sensitive Menus
Control-Click on the Macintosh or a right mouse click on Windows will bring up a context-sensitive menu. This feature is most useful while in layout mode. For example, when a field is defined as a button, double-clicking on it will not bring up the Specify Field dialog. To get to this dialog easily, just use a control-click or a right mouse click.



Document Management Videos


Fun Stuff:

The Wedge
Claris Corporation and the FileMaker, Inc. have been housed in a building called the wedge in Santa Clara, California since they spun off from Apple, Inc. The building is nicknamed the wedge because it looks like a wedge. For some years they had an adjacent building called the interstitial but it was let go when the company downsized to focus on FileMaker products.

The Wedge



Create a Password Management solution!







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