"No Holding Back FileMaker Blogging"


Navigation:


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



$10.00 Beginner Video Training



Become a patron of this FREE web site!


Recent Blogs:

Why then How
Why then How

Twenty-Twenty in Review
Twenty-Twenty in Review

SVG Ready
SVG Ready

Removing Text Formatting
Removing Text Formatting

Nineteen Point One
Nineteen Point One


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.


Beginner, Intermediate and Advanced Video Training


Quick Tip:

Marrying Comments and Tooltips
Here's a cute trick that you'll either love or hate. With FileMaker 10 and the GetFieldName function, you can display Tooltips with the contents of a field comment. Not only does this allow you to store your Tooltips with the field definition, it's completely dynamic such that you can select all the fields on your current layout and apply the Tooltip formula one time. Here's the dynamic formula: FieldComment(Get(FileName); GetFieldName(Self))



Document Management Videos


Fun Stuff:

Claris Commercial
Few people know that Claris produced a commercial and it aired on national television. It was one of those favor things so it only played once. I'm not saying it's anywhere close to the impact of the Apple Super Bowl commercial but it's fun to have a look. Download the Claris commercial



Create a Password Management solution!







RSS Feed
Search Results for : All
Why then How
Level: Intermediate
Category: General
02/16/2021
I once asked someone on the forums why they wanted a particular solution. I did this because they were asking for a technique that seemed like a lot of unnecessary work. I was attempting to provide a better answer that met their true needs within the abilities of FileMaker. In other words, why give a man a fi...
Read More
Don't be shortsighted or blinded to other emthods for programming.
Twenty-Twenty in Review
Level: Intermediate
Category: General
01/05/2021
A lot has happened in 2020 but I'm not hear to preach about the pandemic, the presidential race or George Floyd. A ton has transpired in the FileMaker market too! Probably the biggest news is JavaScript and FileMaker living in perfect harmony. But, I'll also pontificate about quarterly releases, Claris Engage...
Read More
2020 in Review!
SVG Ready
Level: Advanced
Category: User Interface
12/08/2020
The SVG button icons that come included with FileMaker are great but there are so many holes in the library. Lately, I've been scouring the internet for free icons to meet the needs of some more complicated client interfaces. When I find a good one, it usually isn't in SVG format so I have to convert it and t...
Read More
SVG
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.


  Next 10