FileMaker Addict: November 2005

Our second FileMaker Addict interview is with Denis Somar of New York City-based Secret Weapon Labs.

How did you get started in IT?
Initially, it was helping my family's retail business transition from a paper based inventory workflow to a completely digital system. I knew nothing about computers at the time, other than how to write my term papers (I was a college sophomore). I subsequently learned networking, FileMaker development, AppleScript, Lasso, HTML, and a whole bunch of other technical stuff.

From there I landed a computer-lab management job during college and learned even more about networks, printers, installing network cards, ram, and (of course) saving senior theses from computer crashes. After college, during the dotcom boom, I landed a job working for a large consulting firm and was surprised at the bloat in the majority of their corporate intranet applications, most especially Lotus Notes.

How long have you been using FileMaker, and how did you get started with it?
I started with version 3 of FileMaker and learned through other enthusiasts' websites and most especially, the FileMaker usenet newsgroup.

How are you using FileMaker today?
I still field phone calls from my occasionally panicked mother - "How do I find this? How do I do xyz in FileMaker, etc?" - who still uses that FileMaker template I developed. She loves it and I've received a lot of commercial interest in it since I started on it so many years ago.

Beyond that, I've set up a number of small businesses with FileMaker from small retail clothing stores, to restaurants, to a car rental franchise on the West Coast and they have all been literally blown away by the power and ease of FileMaker.

Tell us about your company, Secret Weapon Labs. What was your motivation in starting the company?
After getting the family business running smoothly on FileMaker, I realized how much fun I had doing it, I was impressed by the challenge which was juxtaposed by how bored I was developing Access-based solutions for my corporate fulltime job. So I left the company to start SWL.

Initially, I only created simple websites for business looking to get a polished and economical presence on the web. Soon after, the infamous FileMaker application for my family needed to be updated as their business grew and they were buying newer and increasingly different hardware, and I was pleasantly reminded of my addiction to FileMaker.

I found myself stretching FileMaker in ways I wasn't really reading about on the FileMaker website, newsgroup, or any publications. I then saw Sal Soghoian demo (at one of the Apple WWDCs, I believe) the generation of a real estate catalog from FileMaker to InDesign, all with AppleScript in under two minutes. It crystallized that I had my fingers on the pulse of something very intuitive, very powerful, and certainly fun, so I couldn't say no to pursuing it further!

What do you like best about your job?
The day to day dealings with clients and seeing a solution I produced take flight is all incredibly gratifying. The ability to take risks with technology is certainly easier to do with the kinds of clients and projects I deal with than with larger multi-million dollar contracts.

Let's talk a little about FileMaker 8. What are your favorite new features?
Customizable menus, tab controls, and tooltips (in that order) have almost completely changed the way I develop in FM. The menus have enabled me to really minimize and simplify the GUI, not including menus, to be simple and unobtrusive and bely the power of the FM environment.

If you could add a feature to FileMaker, what would it be?
Certainly, I would add the ability to have direct and specific control over printers, the print dialog box, the ability to switch printers, etc. I find this to be a ubiquitous necessity for nearly all of my clients who print from everything to clothing tag printers, dot-impact printers, standard laser printers, or huge multi-million dollar printing presses.

What's your favorite tool, plugin, or technique for developing FileMaker databases?
The version 7 features of script parameters and the "ElseIf" script statement have also COMPLETELY changed the way develop solutions. I've been able to consolidate almost all of my navigation scripting into 3 or 4 scripts versus one script for each button which usually resulted in 20-40 navigation scripts.

Another important feature has been the ability to enter and modify fields in the header and footer part of a layout. It helped me build a kind of FM search engine, that bares an intended verisimilitude to Apple's Spotlight, so my novice users don't have to figure out find requests and grep symbols.

You mentioned on your blog that, "Nearly as long as FileMaker developers have been adamant on establishing and using naming conventions, I've been equally as adamant on NOT using them." This really struck a chord with me, because I have not yet found a proposed naming convention that I feel comfortable with...

I know that I've got my own method for naming things. What's your method?
My method has been simple: if my user were prompted with a sort dialog or some other field management dialog e.g. import records, exports records, etc., they should be able to recognize what field(s) they're dealing with and not have to place support calls or emails because of seemingly ambiguous naming.

I understand why developers are particular about their own conventions, but ultimately as His Job-ness put it: "We could build the best program in the world, but if no one can figure out how to use it, or manage their data, then it's worthless." I completely agree with that design philosophy, and given that FM gives us limited control as to what extent we can protect users from themselves, developers have to consider the possible impact of their naming conventions on lost users.

You've got an interesting product that you've developed called iCanary. Tell us a little about what the product does, and how you came to develop it.
The Sal Soghoian demo made me realize the true power of FM's implementation of Apple's AppleScript language. I explored many of the included examples and started exploring the wealth of resources on the web that discuss FM & AppleScript.

But alas, as the cliché goes, with great power comes great responsibility and I realized that many users and developers weren't truly aware of some of the security concerns AppleScript could pose. FM 5 was no lead-walled data silo and was certainly hackable. But why worry about hacking if the front door is open to anyone via AppleScript? I realized this as I was writing an Automator-like application in REALbasic, for AppleScript.

That app never saw the light of day and the codebase became the foundation for iCanary.

Secret Weapon Labs also provides Web design services. As a Web designer, what challenges are you facing today?
Great question! I'm still fascinated by CSS and the power that it grants when used effectively. That being said, I learned the slice-and-dice approach to HTML tables so well and so thoroughly that it became a hard way to re-learn the changing rules of the web. But you can sink with the ship or bend with the wind, and the "wind" of the web has certainly been favoring more open, solid, and robust architectures based with everything from databases, to programming languages, to browsers.

Striking a balance between effective and elegant web designs that scale well, are accessible, and as standards-compliant as one can produce is the ultimate challenge these days. I think it's easy to throw a lot of high-bandwidth content into a Flash-based site and have it deliver, but nobody wants to wait 20 minutes to see a presentation just because it has audio and some nifty graphics.

You seem to focus quite a bit on Web standards. Do you feel that the Web standards that exist today make your job easier?
It is incontestable that web standards have made certain functions of web design easier (others, not as much yet). I think this applies most especially to highly-frequented sites like ESPN or the NY Times. Effectively separating content from presentation makes loads of differences in designing and managing websites (FileMaker 7+ for that matter) and it has certainly made life easier.

What advice do you have for those that are interested in FileMaker development?
First off, try and learn from another human rather than just a book, or website, or instruction manual. For most casual users, the initial cost of a class may be prohibitive to learning FileMaker, so then the next option would certainly be to maybe join a FileMaker User Group or see a Wednesday presentation at any nearby Apple Store, and if that fails than try to glean as much as possible from the example databases that FM comes preloaded with. These are great resources that just beg to be tinkered with and explored.

DatabasePros.com is a great resource as is the FileMaker Advisor magazine (which I believe has just launched a FileMaker Basics magazine for new users).

My learning path was the initial dissection of a preloaded FM inventory database template and then voracious reading and discussion in the FileMaker usenet newsgroup which has been beautifully archived by Google Groups.

In your many years of FileMaker experience, what's the most important thing you've learned?
Without question, there is never enough planning when it comes to preparing for a project. The more planning you do BEFORE you ever touch FileMaker pays off in spades as you develop and program as smoothly as possible. We should strive to produce FM solutions, as Einstein would put it "as simple as possible, but not any simpler". I once read on the FM newsgroup that if we build the best idiot-proof system, someone will always build a better idiot. Thus, the "as simple as possible..." mantra!

What technology has most changed your life?
The recorded sound -- whether it be in the form of a vinyl record, audio tape, CD, or bits of an MP3 -- has had the most poignant effect in my life. The computer has played a large part as well, but that should go without saying.

What are your favorite things to do that don't involve work?
I went to art school and studied studio art for more years than I can count. I've recently purchased some blank canvases, new paints, pencils, and a sketchpad. I'm itching beyond belief to put pencil on paper and brush on canvas again. There's a great organic feeling of serenity when you compose art with your hands that I have yet to experience with a computer.

I also noticed on your blog that you're an "always-thirsty-for-new-inspiration guitarist." Have you had a chance to use GarageBand?
My goodness, I ADORE GARAGEBAND!! If there were ever any toy I wish I had when I was in high school and had slow weekends or summers to tinker with, it would be Apple's Garageband. The simplistic UI belies an unbelievable amount of recording power. I've used Garageband for a bunch of things from recording and mastering some of my own fiddling to a friend's band to just messing around with a mix of loops. (That latter mix is available on iCompositions at http://www.icompositions.com/music/song.php?sid=6574)

On a similar note (no pun intended!), what's in heavy rotation on your iPod these days?
Santana's latest album "All That I Am" is in play as is Buddy Guy's "Bring 'Em In". The John Mayer Trio has been producing some great stuff ("Come When I Call" and "Who DId You Think I Was" both come to mind) the rest of their recordings aren't on iTunes unfortunately. John Scofield also recorded an album of Ray Charles covers entitled "That's What I Say" that has some interesting renditions of songs with a slew of guest artists. The Cafe Del Mar 20th Anniversary discs are there in addition to Ottmar Liebert's Nouveau Flamenco which is AWESOME!

Thanks for having me on your blog Tim. I look forward to some great things from fellow FileMaker addicts and from your blog. Keep up the great work!

Thank you, Denis!

For more information about Denis and Secret Weapon Labs, visit his Web site: http://www.secretweaponlabs.com/ And be sure to visit Denis's blog: http://www.secretweaponlabs.com/words/

Janet was kind enough to be our first FileMaker Addict, and I don't think I could have found a more interesting person to interview.

How did you get started in IT?
I took my first computer course in high school and liked it. Took one course in college. While in graduate school in Sociology, I started looking for computer jobs and was directed to the best computer program among the local JCs which was at Contra Costa Junior College. There, I found that time just flew while doing my computer homework and made a mental note that this could be a fun way of making a living. Kind of like being paid to do crossword puzzles. Later, when graduating from UC Berkeley's MBA program, I interviewed for systems analyst kinds of jobs and got one at Control Data's Business Information Services division. It was a trainee situation that didn't require previous work experience. That was my start.

How long have you been using FileMaker, and how did you get started with it?
I started my own business in 1986 and checked out all the databases for the Mac. FileMaker Plus was released that year, and even though it wasn't relational which I already had been doing in my previous work, it was still the most elegantly designed database software out there. I felt it would allow me to create the most value per hour for my clients, so went with it over other options. In my first couple of years of business, I also did some projects with Omnis, Reflex Plus and 4th Dimension. FileMaker was better than those so those experiments just reinforced my choice.

I felt Reflex Plus didn't allow me to make my solutions *sturdy* enough. My clients could break the solution - thus more support for me, the one thing you want to avoid as a computer professional.

I sought out the top Omnis expert in the SF Bay Area and he pointed out how the only way to get Omnis to work well was to use all sorts of arcane tricks and work-arounds that weren't documented anywhere. That sounded unappealing to say the least.

When 4th Dimension came out, I jumped on it. But I found that I would spend way too many hours on getting one single feature optimized. In the same time I could implement about five to ten 80%-as-good features in FileMaker. Since my clients were small businesses and work groups, they couldn't afford the fancy stuff that 4D enticed you to put in. So back to FileMaker where the value per hour to the customer was much better.

How do you use FileMaker today?
I use it to automate my business. Billing is the main function, but I track all sorts of things, like prospects and customers, estimate projects, track customer communications and lots more. My own business system is the place where I try out ideas and learn what would have value and what would not for my customers. And I've developed a FileMaker-based software product for the creative services industry called Studio Manager that's now the main source of income in my company. And the rest of my work time is spent customizing Studio Manager for my customers or doing the occasional custom project for my long-time FileMaker customers in the Bay Area.

What do you like best about your job?
It's hard to choose just one, but getting to play with the latest, cutting edge features of FileMaker is up there. Every release of FileMaker is like Christmas to me - a whole new set of toys -- er, I mean tools! But I also enjoy talking with customers about their needs and what's possible and teaching them how to take advantage of FileMaker and Studio Manager. And, of course, the high point of my day is when I get a new order for Studio Manager!

One more thing, getting to know people all around the world is great. I've created a mapping system in my software so that I see a map of the person's area while I'm talking to them on the phone. I can chat with them about where they live while looking at the map. I've actually read up on lots of these different areas out of curiosity. I hope to eventually hold Studio Manager conferences around the world and have these customers and local FileMaker consultants in attendance.

Tell us about your favorite new features in FileMaker 8.
I'm really glad to get clairvoyance for me and my customers. Now we can compete with Quicken if we want to. Copying and pasting fields and scripts steps is a FileMaker Advanced feature that is fabulous. Importing tables is great because it makes it easy to take a set of individual files and consolidate them into one powerful single file. I like the concentration of value that is possible there.

If you could add a feature to FileMaker, what would it be?
OK. Give me the ability to make the UI of a FileMaker database look like a Macintosh application. I want a tool that lets me make transparent glossy buttons for one. My Studio Manager customers are mostly designers and they care about that stuff. And, by making this kind of thing a tool in FileMaker, my customers can customize the standard product and keep the same look without having to create less efficient bitmapped buttons.

What's your favorite tool, plugin, or technique for developing FileMaker databases?
I try to avoid plug-ins just so that I'm guaranteed that my customer has everything they need to make the app work right. But right now I have to say FileMaker Pro 8 Advanced. Being able to copy and paste fields, script steps, scripts and duplicate and import *template* tables gives me incredible power to efficiently deliver value to my customers. The release of FileMaker Pro 8 Advanced instantly increased my value per hour to my customers.

What advice do you have for those that are interested in FileMaker development?
Get yourself certified in FileMaker 8 as soon as that certification is available. Meet with local FileMaker consultants and take them to lunch or whatever to get to know them. You might want to start a local FileMaker developers group and meet at least once a month. You'll be able to help each other, share new discoveries and learnings and eventually share business. You may find your next business partner there. If you have any writing ability at all, start a FileMaker-oriented blog as your *company* website to promote yourself by providing value and interest to others who are interested in FileMaker. If you don't have enough work, just make yourself available at a rate that the local FileMaker consultants' are comfortable with for some overflow that will sooner or later come up. FileMaker 8 is hot and there's a shortage of FileMaker talent as far as I can tell.

In your many years of FileMaker experience, what's the most important thing you've learned?
Stay close to the client with prototyping starting in the initial interview stage. Human beings can't tell you what they do when they do knowledge work. Over 95% of it is done unconsciously. The only way to develop successful systems is to show the customer what you think they are saying they want and need immediately and then keep showing them all along the way as you develop iteratively. Same goes for things I do myself. I need to play with something right away to see if it is going to do what I think it will do.

What technology has most changed your life?
The Mac.

What are your favorite things to do that don't involve work?
When you run your own business and it's a business that you love, it is hard to separate work from pleasure. So, surfing the Net and blogging are major things I do that often have payoffs in my work. The surfing keeps me well-informed and blogging makes me visible to and knowable by my current and potential customers and colleagues. I also enjoy listening to music and hiking. I love travel. I love personal technology and just got a video iPod of late so I'm reading all the best books I can find about iPodding and podcasting. I read pretty voraciously too both online and books.

Thanks, Janet!

For more information on Janet, her consulting company (Tokerud Consulting Group), or Studio Manager (a FileMaker-based system for creative services firms that track time, expenses and deadlines by the job), visit her blogs: