Jump to content

John Mark Osborne

Members
  • Content Count

    1,117
  • 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. 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.
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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 Claris and to the Claris product line. I'll enhance this discussion with blog postings, YouTube videos and example files from the Database Pros, Philosophy of FileMaker and Fireside FileMaker web sites. Happy FileMaking! View the full article
  15. 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 Claris and to the Claris product line. I'll enhance this discussion with blog postings, YouTube videos and example files from the Database Pros, Philosophy of FileMaker and Fireside FileMaker web sites. Happy FileMaking! View the full article
×
×
  • Create New...

Important Information

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