"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Anatomy of a Calculation
Anatomy of a Calculation

Seven for Seventeen
Seven for Seventeen

Seventeen is Prime
Seventeen is Prime

Interface Ease
Interface Ease

File Freedom
File Freedom




$10.00 Beginner Video Training


Quick Tip:

Creeping Labels
Does the information on your labels creep up or down such that the last labels on the page are at the top of the label? The most-likely reason the labels are creeping is due to the Body part being too big or too small. However, let's start with the first row of labels. Does the first row of labels hit exactly where you want it to? If the labels are too low, decrease the size of the Header part. If they are too high, increase the size of the Header part. Once you have your first row printing correctly, move on to the rest of the rows. If they are creeping up, you need to make the Body part bigger. If they are creeping down, you need to make the Body part smaller. When you change the size of the Body part, any change is multiplied over the number of rows of labels you have. Change the Body size as much as the difference in position between the first and second rows of labels and all the labels should adjust correctly. It may take a few tries.



Tips & Tricks Videos


Fun Stuff:

Jaymo
David Knight (aka Speedy) started calling me JoMo years ago, because of my initials, and it kinda stuck. Over the years, it's evolved to the current Jaymo but you can call me anything as long as you are friendly. Other nicknames include Hoss, n2 and Wiz.



FREE FileMaker 17 Videos



Document Management Videos



Create a Complete Contact Manager







RSS Feed
Search Results for : All
Preserving Found Sets
Level: Intermediate
Category: Scripting
01/30/2018
Imagining a database without found sets is like picturing a bird without feathers. It just doesn't make sense. Found sets are the essence of a database. If there were no found sets, you would need to sort your entire list of records and scroll to find a record. To say the least, this would be an inefficient p.
Read More
The Status Toolbar in FileMaker always displays the current record, found set and total records for the current table.
Multi-User Contradistinction
Level: Intermediate
Category: General
01/16/2018
How you design a FileMaker solution often depends on how it will be accessed. Is it a single-user solution running off the local hard drive? Is it a multi-user database with all users accessing from the LAN? Maybe there is a occasional remote access from someone at home? What if the company is distributed acr.
Read More
FileMaker can share to a variety of platforms including Windows, Macintosh, iOS and Web.
Reconciling Record Locking
Level: Intermediate
Category: Scripting
01/02/2018
One of the most important concepts to grasp hold of tightly, when moving from the design of single-user to multi-user FileMaker solutions, is record locking. It's a fairly simple concept to understand. It just prevents two people from editing the same record at the same time. The complex part of record lockin.
Read More
A padlock representing record locking in FileMaker.
Eating Your Own Dog Food
Level: Intermediate
Category: Web Enabling
12/05/2017
I took a different technology approach than every other person out in cyber land writing FileMaker blogs. I actually created my own FileMaker database to manage my content. Go figure! I could have taken the easy way out and used canned blog software but FileMaker is perfect for this job. Besides, I'm a firm b.
Read More
The three online databases running on the Database Pros web server.
Wrangling Relationships
Level: Intermediate
Category: Relationships
11/07/2017
The relationship tab in Manage Database is not an ERD (Entity-Relationship Diagram). Sometimes it looks a lot like an ERD but it is so much more. An ERD represents the structure of your solution while the relationship graph contains structure as well as what I like to call techniques. Techniques are relations.
Read More
Wrangling relationships!
Preferences and Options
Level: Advanced
Category: Calculations
10/24/2017
I'm no SQL expert but I know when, and when NOT, to use the ExcecuteSQL function. ExecuteSQL is not for creating replicas of portals, despite the numerous examples floating around the internet. It's also not designed to replace the built-in FileMaker find feature, even though it seems to replicate the search.
Read More
If you aren't familiar with SQL, it's an acronym for "structured query language". Many database applications use SQL to perform finds, analyze relationships and create, edit and delete records.
Becoming Certified
Level: Intermediate
Category: General
10/10/2017
The most common non-technical question I get is, "how do I become certified" or "how do I study for the certification test"? It's a good question. If you're taking the test seriously then you need to study, right? Not only does it cost a few hundred bucks to sign up but it's an important milestone in your Fil.
Read More
The official FileMaker 16 certification logo I display proudly on my web site.
Logically Speaking
Level: Beginner
Category: Calculations
09/26/2017
Logical functions are some of the most important and widely used functions. Think of decision making when considering logical functions. They enable you to decide if a formula will return one result or another. Which fork in the road will the formula take? Testing for true or false is often referred to as boo.
Read More
Spock is a logical guy, just like logical functions in FileMaker.
Efficiency
Level: Intermediate
Category: General
09/12/2017
The old saying that time is money is more than just a saying. The faster you can develop a project, the more money you can make as a commercial developer or, the more time you can devote to other projects as an in-house developer. Being as efficient as possible is the key to success. That's the primary differ.
Read More
Efficiency is the key to making money for a commercial developer and crucial for in-house developers to make time to do their "real" job.
Keeping the Faith
Level: N/A
Category: General
08/29/2017
Steven Blackwell almost always starts a phone call with "greetings and salutations" and often ends with another famous quote, "keep the faith". I've never asked what he means but I'm pretty sure it's not religious. Steven Blackwell loves the FileMaker platform and he likes other people who feel the same as he.
Read More
The illustrious Steven H. Blackwell.


  Previous 10 | Next 10