Jump to content
  • entries
    168
  • comments
    2
  • views
    5,327

Entries in this blog

Removing Text Formatting

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

Nineteen Point One

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

Transactional Processing

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 recor

Conditional Tab Control

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 st

Server Optimization

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

Designing for Efficiency

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 we

Hey Nineteen

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

Hey Nineteen

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

Designing for Efficiency

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 mult

Why FileMaker

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

Why FileMaker

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

Merging Duplicates

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

Merging Duplicates

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

Twenty Nineteen in Review

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 FileMak

Twenty Nineteen in Review

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 FileMak

Preventing Duplicates

Preventing duplicates from ever being entered in the first place is my personal preference. Sometimes we don't have a choice and have to remove them after the fact. But, if you can stop them from ever being entered, it's going to make your life much easier. In this article, we'll discuss a variety of techniques for stopping duplicates in their tracks including validation, script triggers and plain old vanilla scripting. View the full article

Preventing Duplicates

Preventing duplicates from ever being entered in the first place is my personal preference. Sometimes we don't have a choice and have to remove them after the fact. But, if you can stop them from ever being entered, it's going to make your life much easier. In this article, we'll discuss a variety of techniques for stopping duplicates in their tracks including validation, script triggers and plain old vanilla scripting. View the full article

Deleting Duplicates

Database administrators have nightmares about duplicate data entry. There are tons of solutions out there. Which direction do you go? Do you try to prevent duplicate record entry with validation or scripting? Do you let the duplicates get entered and delete the periodically? And, what about merging two records? Maybe it's not a nightmare but at least it's an issue you have to address before allowing users to enter data. This article will discuss the ins and outs of the various methods for deleti

John Mark Osborne

John Mark Osborne

Deleting Duplicates

Database administrators have nightmares about duplicate data entry. There are tons of solutions out there. Which direction do you go? Do you try to prevent duplicate record entry with validation or scripting? Do you let the duplicates get entered and delete the periodically? And, what about merging two records? Maybe it's not a nightmare but at least it's an issue you have to address before allowing users to enter data. This article will discuss the ins and outs of the various methods for deleti

John Mark Osborne

John Mark Osborne

The Downside of Indexing

Most people don't think about indexing when designing a solution. FileMaker automatically turns on indexing when needed so why should they? Indexing can only be good, right? I mean, it makes finds faster. Well, in most situations, indexing is nothing to worry about. But, under certain circumstances, indexing can have an adverse effect on your FileMaker file. Let's talk about how indexing works, where it is used and how it can slow down your solution when unchecked. View the full article

John Mark Osborne

John Mark Osborne

The Downside of Indexing

Most people don't think about indexing when designing a solution. FileMaker automatically turns on indexing when needed so why should they? Indexing can only be good, right? I mean, it makes finds faster. Well, in most situations, indexing is nothing to worry about. But, under certain circumstances, indexing can have an adverse effect on your FileMaker file. Let's talk about how indexing works, where it is used and how it can slow down your solution when unchecked. View the full article

John Mark Osborne

John Mark Osborne

Loss of Focus

I hear it over and over on the forums, "my Tab Control changes to the default tab when I run a script". What initially seems like an innocent little script that adds a new related record by setting a variable to a primary key, switching layouts, creating a record, setting the foreign key and returning to the original layout, becomes a nightmare of fixes to restore focus to the correct tab panel. In fact, loss of focus can happen with a variety of different objects including Portals, Slide Contro

John Mark Osborne

John Mark Osborne

Loss of Focus

I hear it over and over on the forums, "my Tab Control changes to the default tab when I run a script". What initially seems like an innocent little script that adds a new related record by setting a variable to a primary key, switching layouts, creating a record, setting the foreign key and returning to the original layout, becomes a nightmare of fixes to restore focus to the correct tab panel. In fact, loss of focus can happen with a variety of different objects including Portals, Slide Contro

John Mark Osborne

John Mark Osborne

Naming Standards

Just about every serious FileMaker developer has their own personal naming standards for fields, scripts, tables, layouts and anything else that can be named. There's really no correct naming standard. It's all about what works for you and your development style. Still, you need somewhere to start. I'm not just going to provide some specific ideas but the reasoning behind the choices I've made so you can better decide what works well for you. View the full article

John Mark Osborne

John Mark Osborne

Naming Standards

Just about every serious FileMaker developer has their own personal naming standards for fields, scripts, tables, layouts and anything else that can be named. There's really no correct naming standard. It's all about what works for you and your development style. Still, you need somewhere to start. I'm not just going to provide some specific ideas but the reasoning behind the choices I've made so you can better decide what works well for you. View the full article

John Mark Osborne

John Mark Osborne

×
×
  • Create New...

Important Information

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