"No Holding Back FileMaker Blogging"
|
Navigation:
|
Support this site by clicking on a sponsor below or becoming a patron!
Document Management Videos
Become a patron of this FREE web site!
|
|
Recent Blogs:
|
Currency Formatting
 |
Gathering Portals
 |
Multiple Choice Picker
 |
Popups and Pickers
 |
Window Locking
 |
|
Meta-Consulting
Meta-consulting is a service Database Pros offers to help other developers
over programming hurdles via GoToMeeting. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service.
|
FileMaker 20 Video Tutorials
|
Quick Tip:
|
Record Locking
In FileMaker 6 and earlier versions, record locking occurred when a guest on the network clicked into a field. That's was all that was required to prevent others from changing the record. Unfortunately, this also prevented other guests from copying data from a locked record and other basic features. FileMaker 7 has changed how record locking works. In order for a guest on the network to lock a record, he must actually modify a field, allowing user to work with a record without locking it. However, the most important change is when scripting for record locking. You don't want to test if the record is locked by setting a field to a value. FileMaker 7 introduces the Open Record/Request script step which attempts to lock a record without modifying it. If the record is locked, an error of 301 will be returned. If the record is not locked, this script will lock it until the Guest exits the record manually or the Commit Record/Request script step is intiated. |
|
|
FileMaker 20 Video Tutorials
|
Fun Stuff:
|
DevCon History
Here's a list of the FileMaker Developer Conferences* through 2020:
| # | | Year | | Location |
| 23 | | 2020 | | Nashville, Tennessee** |
| 23 | | 2019 | | Orlando, Florida |
| 23 | | 2018 | | Grapevine, Texas |
| 22 | | 2017 | | Phoenix, Arizona |
| 21 | | 2016 | | Las Vegas, Nevada |
| 20 | | 2015 | | Las Vegas, Nevada |
| 19 | | 2014 | | San Antonio, Texas |
| 18 | | 2013 | | San Diego, California |
| 17 | | 2012 | | Miami Beach, Florida |
| 16 | | 2011 | | San Diego, California |
| 15 | | 2010 | | San Diego, California |
| 14 | | 2009 | | San Francisco, California |
| 13 | | 2008 | | Phoenix, Arizona |
| 12 | | 2007 | | Orlando, Florida |
| 11 | | 2006 | | Orlando, Florida |
| 10 | | 2005 | | Phoenix, Arizona |
| 9 | | 2004 | | Phoenix, Arizona |
| 8 | | 2003 | | Phoenix, Arizona |
| 7 | | 2002 | | Palm Desert, California |
| 6 | | 2001 | | Orlando, Florida |
| 5 | | 2000 | | Palm Desert, California |
| 4 | | 1999 | | San Diego, California |
| 3 | | 1998 | | Monterey, California |
| 2 | | 1997 | | San Jose, California |
| 1 | | 1996 | | Santa Clara, California |
* Name changed to Claris Engage in 2020 to match renaming of FileMaker, Inc. to Claris.
**Due to the COVID-19 virus, this conference was changed to a virtual conference. |
|
|
Document Management Videos
|
RSS Feed
|
|
|
|
|
Search Results for : All
|
|
|
|
It's pretty easy to format a number field as currency, especially if it's a standard field. Once you enter the realm of merge fields, formatting a number can sometimes become difficult when multiple merge values need to display in a different format. For example, you might need a single text block to display... |
|
Read More
|
|
|
|
|
|
|
In a relationally sound FileMaker database solution, you will definitely need portals. When you have a one-to-many relationship, the most common way to display the many related records from a layout based on the parent is to employ a portal. But portals don't always do what we want. Sometimes you need to enha... |
|
Read More
|
|
|
|
|
|
|
I've been using pickers in customer solutions for years but always as a single choice interface. It dawned on me, after reading a post in a forum, that it's often advantageous to make multiple selections, instead of having to keep clicking the picker buttons for multiple single choices. In this article, I'll... |
|
Read More
|
|
|
|
|
|
|
Consistent data entry is one of the hallmarks of a well-designed FileMaker database. It allows a user to run accurate reports and perform reliable sorts and finds, just to name a few important features. Popups and Pickers can assist in the integrity of your data, allowing you to control how users enter data... |
|
Read More
|
|
|
|
|
|
|
Window locking is akin to record locking and is considered the same error when it comes to the Script Debugger (301). Essentially they are the same except that window locking doesn't require the FileMaker solution to be hosted on a server to reek havoc with scripting and manual editing of records. In other wo... |
|
Read More
|
|
|
|
|
|
|
Michael Rocharde and I started the Fireside FileMaker podcast way back in 2019. We've recorded 45 episodes along with our good friend Marc Larochelle. But, all things come to an end... at some point. I'm proud of the work I've done on the Podcast so I want to share some of my favorite episodes. There will als... |
|
Read More
|
|
|
|
|
|
|
Over the years, clients have asked me for a variety of reporting features that aren't easily created with standard subsummary and summary tools. A lot of them, including this technique, use the GetSummary function. I remember having such a hard time wrapping my head around the GetSummary logic when I was work... |
|
Read More
|
|
|
|
|
|
|
Scripting a change log (Audit Log) table has been around since script triggers were introduced in FileMaker 10. But, do you know the right way to script a field modification log? I've been programming them for years and have gone through every version of them and have settled on what I'm going to cover today... |
|
Read More
|
|
|
|
|
|
|
A long, long time ago, in a far away land, Bob Cusick, of Clickware, sent me a tip file that used a single field to log changes to fields in a table. Through the years I modified it and released it many times but here’s the latest version. This version is so abstracted, all you need is a single custom functio... |
|
Read More
|
|
|
|
|
|
|
FileMaker, Inc. and Claris have been waging a war against Manage Database clutter for over two decades. In the early days of FileMaker, let's say FileMaker 3.0, there was no need to worry about packing too much into Manage Database because people weren't designing complex solutions like they do today. These d... |
|
Read More
|
|
|
|
|
|
Next 10
|
|
|
