Group Session #1
Hi. My name is Andy and I’m an API Addict.
In my defense, I have to say it’s all Brian Dunning’s fault. See, when I was first starting out with FileMaker, and discovered all that sample data on Mr. Dunning’s website, I found I couldn’t get enough. I was sorting, and parsing, and testing, and munging, and wrangling, and…and…and I just kept needing bigger and bigger datasets to “work” with. When I’d gone through the biggest one there, I realized I still needed more.
Our 2016 FileMaker training courses are scheduled!
Our trainers are Certified FileMaker Developers, who have been developing custom solutions at Skeleton Key for many years. Please visit each page for information, dates, and to register.
If you would like an individual invoice, please contact us. We offer a multi-person discount for companies that would like to send more than one trainee. Please contact us with interest in this discount. We offer on-site training for companies that qualify. Please contact us if you’d like training for your staff members at your company’s location.
In a recent discussion at the FileMaker Community a question was asked about why a FileMaker developer would choose NOT to use SQL-friendly field names. It’s an important question that I believe many FileMaker developers often answer incorrectly. Here’s a bit about how my view of naming conventions has changed over time.
For reference, a SQL-friendly field name in FileMaker would be a name that:
starts with a letter
contains only letters, numbers, and underscore characters
is not a reserved word (an evolving list of over 200 words including DATE, FIRST, FROM, VALUE, ZONE, etc.)
Developers also often adopt naming conventions that use PascalCase, camelCase, or a variety of prefixes and suffixes to indicate properties of the field or alter the sort order of fields.
I was once in the camp that thought it was a best practice to always use these kinds of naming conventions to optimize developer productivity. I come from a computer science background with experience in dozens of different languages, each with its own arcane naming rules. Some of those languages were created when every byte was precious…many computers had just a few kilobytes of memory, data transfer rates were measured in bits per second, and programs and data were stored on punched cards or magnetic tape. I started using some amalgamation of the various rules I knew when I began using FileMaker in 1986. Over the years, my naming conventions evolved modestly as the FileMaker platform changed and I was exposed to other developers’ code.
L5SimpleFM is a PHP package used to provide a simple, readable, declarative syntax for accessing data hosted on a FileMaker Server from a composer-friendly PHP project. The package also has a ServiceProvider class which allows it to be easily pulled into a Laravel 5 project.
Join us Tuesday, September 22, for a free one-hour webinar at 2pm (EST)/ 1pm (CST)/ 11am (PST), as Mark Richman presents Options for Licensing FileMaker Platform. During the webinar, he will explain the different options for connecting users to FileMaker solutions, and demystifies the various options for licensing the technology.
I ran into a situation recently where a user would not or could not remember to commit their changes before exiting their FileMaker Go solution on their iPad.
The truth is it’s easy to complain that the user isn’t using the system as it was intended. Complaining about the user doesn’t really solve the problem, and we are problem solvers. This is custom software; it should work the way the user works, not the other way around.
In this case, the user was using an iPhone or iPad Mini. He pulls it from his pocket, opens a work order, adds some photos and notes, and then sticks the device back in his pocket. Then he does some work (like replacing a window in a building) and then takes some more photos of the completed repair.
Skeleton Key will be taking our 3-day Developer Essentials, FileMaker Training class to the Nashville, Tennessee area from Tuesday September 22 to Thursday, September 24.
The course will be hosted at:
Goodall Homes, 323 Maple Street, Suite 100, Gallatin, TN 37066
Seating is limited. Register ASAP, if you are interested in attending this training class.
We are hiring!
Are you ready to make a meaningful career move? Is it time for you to step into the big leagues and make databases for professionals?
Do you want to develop more than a FileMaker database?
To be successful in this developer position you must have thick skin, be a fast study and thrive on doing the hard work to get the job done. You should be excited about working in a team environment where accountability is high and your opinion is valued.
Mark (top right), Alan (bottom middle), Greg (bottom right)
Mark Richman, President, Greg Lane, VP of Application Development, and Alan Kirtlink, Senior Developer and Trainer, are headed to Las Vegas, Nevada from July 20 – 23 to participate in FileMaker, Inc.’s annual Developer Conference aka DevCon. They’ll be staying at The Cosmopolitan, host hotel of more than 60 DevCon sessions. They will join over 1,200 FileMaker developers to network, catch up with colleagues and take advantage of the variety of session topics including design, core development, mobility, web, business, and innovation to further their knowledge with tips, best practices, and techniques to continue building powerful business solutions for our clients. Both Mark and Greg will have the honor to host four of these sessions.