Jump to content

John Mark Osborne

Members
  • Content Count

    1,120
  • Joined

  • Last visited

  • Days Won

    1

John Mark Osborne last won the day on February 2 2017

John Mark Osborne had the most liked content!

Community Reputation

3 Neutral

1 Follower

About John Mark Osborne

  • Rank
    FileMaker Expert
  • Birthday 03/22/1967

Profile Information

  • Title
    Owner/President
  • Industry
    FileMaker
  • Gender
    Male
  • Location
    Chino Hills, CA
  • Interests
    FileMaker

Contact Methods

  • Website URL
    www.databasepros.com

Recent Profile Visitors

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

  1. 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 "
  2. 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
  3. 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
  4. 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.
  5. 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
  6. 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 lockin
  7. 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 pr
  8. 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
  9. 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 especiall
  10. 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
  11. 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
  12. 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
  13. 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 will help you to explain it to your clients, IT department or boss. Or, you can just refer them to this article. View the full article
  14. 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 will help you to explain it to your clients, IT department or boss. Or, you can just refer them to this article. View the full article
  15. 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. While this can be completely scripted, I truly believe a human needs to oversee this process in most cases. View the full article
×
×
  • Create New...

Important Information

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