Jump to content

John Mark Osborne

  • Posts

  • Joined

  • Last visited

  • Days Won


John Mark Osborne last won the day on February 2 2017

John Mark Osborne had the most liked content!

1 Follower

About John Mark Osborne

  • Birthday 03/22/1967

Profile Information

  • Title
  • Industry
  • Gender
  • Location
    Chino Hills, CA
  • Interests

Contact Methods

  • Website URL

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

John Mark Osborne's Achievements


Mentor (12/14)

  • First Post
  • Collaborator
  • Posting Machine Rare
  • Conversation Starter
  • Week One Done

Recent Badges



  1. Scripting a change log table has been around since script triggers were introduced in FileMaker 10. But, do you know the right way to script a field modification log? I've been programming them for years and have gone through every version of them and have settled on what I'm going to cover today. We'll start off with the wrong way to script an event log so you can get some perspective but will end up with a dynamic solution that can be copied and pasted from FileMaker file to FileMaker file.View the full article
  2. A long, long time ago, in a far away land, Bob Cusick, of Clickware, sent me a tip file that used a single field to log changes to fields in a table. Through the years I modified it and released it many times but here’s the latest version. This version is so abstracted, all you need is a single custom function with parameters that specify the fields that trigger the log and the log field itself. That means you can copy and paste the formula from table to table and make minor changes to create logs in all your files. View the full article
  3. FileMaker, Inc. and Claris have been waging a war against Manage Database clutter for over two decades. In the early days of FileMaker, let's say FileMaker 3.0, there was no need to worry about packing too much into Manage Database because people weren't designing complex solutions like they do today. These days, it's critical that you use all the tools at your disposal and don't just cram everything into Manage Database. This article will serve as a history of why features were added to FileMaker, examples of how they can be used, references to articles with more information and general commentary, so you can learn from the wisdom of time. View the full article
  4. I've talked to other developers, read articles and even attended presentations on how to create multilingual FileMaker solutions. I've always thought to myself... "I'll never have to do this myself" so I only half listened. Now I have a client who needs multilingual field labels, titles, button text, tooltips and placeholders. I'm going to walk readers through the process of determining the best solution for my particular client so you can learn the way I did. You may have to adjust your approach to your client needs but this should get you started. View the full article
  5. 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 fish when he really wants a fishing pole. The response I received was, "Why is not relevant to how." Wow! This guy couldn't be any more wrong. Such a shortsighted approach to programming is not uncommon which is why I'm writing this article. It's your job as a developer to ask your clients "why"! So... let me tell you why. View the full article
  6. 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, public speaking and even publishing in the FileMaker market. All of these subjects have come to exist or have changed drastically in the 2020 FileMaker market. So... sit back and enjoy the ride through memory lane of twenty-twenty. View the full article
  7. 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 then add the FileMaker fill tag to get the icon ready for prime time. What I'm going to do in this article is take you through my journey to learn more about finding, manipulating and implementing SVG graphics in FileMaker. View the full article
  8. 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 that's been pasted or drug from another application like a web browser. This leads to all kinds of issues with displaying field text on multiple layouts as well as output. This article will cover a variety of methods for discouraging, preventing and fixing text formatting issues in fields. View the full article
  9. 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 every release but the changes will come much faster. As promised publicly by Claris, FileMaker 19.1.2 (or 19.1) includes JavaScript Add-Ons and a few other surprises. View the full article
  10. 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 control of the record and it can be freely modified by a script. However, if your script loops through records or uses the Replace Field Contents script step, the difficulty controlling record locking is on a whole 'nother level. In this article, I'll discuss how to get around record locking when multiple records need to be modified with a script, using an example of inventory leveling. View the full article
  11. 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 that resulted in "" or blank when the pane was not available for the current contact. This resulted in a small tab at the top of the Tab Control but didn’t make it disappear. To make a long story short, with the help of a friend, I was able to discover a technique that solved all of these problems. View the full article
  12. 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 difference in how your solution performs if you have sub par equipment. There are so many factors that play into how a solution performs that it's nearly impossible to provide the right answer for everyone. Instead, what I have here is a cheat sheet that will assist you in resolving speed issues. View the full article
  13. This article was previously released for one day but was removed from the site when FileMaker 19 was unexpectedly released. Happy FileMaking! 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 covered that already in several articles on this web site. What I want to talk about today is designing an efficient form and list view. It's especially important when displaying single and multiple records on screen at the same time in a WAN environment. View the full article
  14. 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 starting point for something new that's only get better with their new agile release schedule. View the full article
  15. 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 starting point for something new that's only get better with their new agile release schedule. View the full article
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.