John Mark Osborne

Members
  • Content count

    961
  • Joined

  • Last visited

  • Days Won

    1

John Mark Osborne last won the day on February 2

John Mark Osborne had the most liked content!

Community Reputation

1 Neutral

About John Mark Osborne

  • Rank
    FileMaker Expert
  • Birthday 03/22/1967

Profile Information

  • Gender
    Male
  • Location
    Chino Hills, CA
  • Interests
    FileMaker

Contact Methods

  • Website URL
    www.databasepros.com

FIleMaker Profile

  • Profile Updated
    02/01/2017
  • FM Application
    15 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level
    Expert
  • Certification
    7
    8
    9
    10
    11
    12
    13
    14
    15
  • Membership
    TechNet
    FileMaker Business Alliance
  • Title
    Owner/President
  • Industry
    FileMaker
  1. When I first started teaching FileMaker scripting, I went through the entire list of script steps and provided a simple example of each one. By the end of the third day, we had covered every script step but with no depth. More questions remained than were answered. That’s when I decided to focus on the most important steps. Instead of spending valuable time teaching scripts steps most people would never use in real life scenarios, I decided to concentrate on steps that are used over and over and have tons of depth. That’s how I developed my "Ultimate Find" script. It’s a great way to start your journey into advanced scripting, demonstrating important concepts and sophisticated techniques with key script steps, all in one little script. Besides, every good solution needs a well designed find script. View the full article
  2. Have you ever inherited a system built by someone else, changed a field’s name and everything stopped working? The issue, hardcoded names used in indirection, makes the system fragile. FileMaker provides developers many methods to add flexibility using indirection. However when these instances of indirection are not treated properly they will raise all sorts of problems. In this article we will discuss good practices regarding indirection that will help you build a dynamic and robust FileMaker system. View the full article
  3. This is part 2 of the phone filtering solution. If you haven't read then it's a good idea to start there. Even if you are familiar with filtering phone numbers already and just want to read about the recursive version, it's still best to read part 1 to familiarize yourself with the approach. And, you never know, you might find a nugget of truth! View the full article
  4. After I published the article, I realized I couldn't have a number in the URL. I've updated the RSS Feed which this entry on FMForums is based upon. Until then, here's the correct link: http://www.philosophyoffilemaker.com/phone-filter-part-one-72 Thanks so much for your help, Lee!
  5. Phone formatting is one of my favorite techniques because it teaches so many important concepts. The interaction between a complex formula, auto-entry and validation is fascinating to me. There are so many possibilities, as well as potential hazards, when combining different components. When you get the hang of it, there is nothing like the feeling of weaving a new ability through the union of multiple features. View the full article
  6. Phone formatting is one of my favorite techniques because it teaches so many important concepts. The interaction between a complex formula, auto-entry and validation is fascinating to me. There are so many possibilities, as well as potential hazards, when combining different components. When you get the hang of it, there is nothing like the feeling of weaving a new ability through the union of multiple features. View the full article
  7. View the full article
  8. View the full article
  9. Professional developers pay attention to the number of files in their FileMaker solutions because it’s a crucial factor in good database design. Most developers utilize the standard single file structure because it makes development easier. On larger multifaceted projects, a developer might use several files for separate areas of the company. A smaller set of developers like to use the separation model to avoid issues with updates to their solutions and other benefits that will be explored. It’s very important to choose the file structure the best suits your style as well as the project at hand. View the full article
  10. View the full article
  11. I would create a table of sales people or, if you already have a table of employees, use that table. Load the sales people into a global variable and use the top email address each time you send out your lead. Move the top email address to the bottom after the email is sent. This formula will grab the first email from a return-separated list: GetValue($$Emails; 1) This formula will move the first email to the bottom: RightWords($$Emails; ValueCount($$Emails) - 1) & & ¶ & GetValue($$Emails; 1) You can run this as a Script Schedule on Server if you have an SMTP Server.
  12. I graduated Liberal Studies.
  13. Is the calculation storage option to "do not store calculation results -- recalculate when needed" checked? Making the calculation unstored should allow it to update automatically.
  14. FOR IMMEDIATE RELEASENew FREE videos on YoutubeChino Hills, Calif., February 1st, 2017 -- Well known FileMaker author John Mark Osborne has released two new free videos for FileMaker Pro 15 on his YouTube channel. The videos are created in FileMaker Pro 15 Advanced but can be used with FileMaker Pro or Advanced 12, 13 and 14 with the exception of a few exercises. The videos cover one advanced topic on Reminder Systems using the Install OnTimer Script step and one intermediate technique showing how to avoid window locking issues (not to be confused with record locking).https://www.youtube.com/c/johnmarkosborneJohn Mark Osborne has been working with FileMaker Pro for over two decades and has become one of the leading industry experts. John Mark is co-author of the wildly popular Scriptology book and CD ROM which has become the standard for FileMaker Pro developers. Recently, he received a prestigious award from FileMaker, Inc. for developing outstanding technical resources for his popular FileMaker Pro web site, Database Pros <www.databasepros.com>. John Mark is also a regular speaker and trainer at MacWorld Expos and the FileMaker Developer Conference. Database Pros works closely with FileMaker, Inc. as one of 50 Platinum level FBA (FileMaker Business Alliance) members and 1 of 16 trainers authorized to teach the FileMaker Training Series from FileMaker, Inc. John Mark is a certified FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15 developer having passed all nine certification tests.# # #
  15. View the full article