Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
for peer-to-peer support of the FileMaker Platform and related products and services.
For the first time, DB Services has been ranked #3494 on the annual Inc. 5000 list, which ranks the country’s “fastest-growing innovators” based on overall revenue growth over a three-year period. The Inc. 5000 list has brought attention to America’s growing private businesses since 1982.
DB Services now joins the ranks of other Inc. 5000 list alumni such as Facebook, Zappos, Pandora, and others. DB Services is top ranked FileMaker Platinum Business Alliance Partner on the 2019 Inc. 5000 li
The FileMaker Let function is your tool to make a calculation readable, well formatted and easy to debug. Let us discuss how it can be used.
The post Like a Boss: Let us Discuss the FileMaker Let Function appeared first on Geist Interactive.
View the full article
The FileMaker Script Debugger is powerful. Its features are often overlooked. In this post we examine the buttons that control stepping through a script.
The post Like a Boss: Using the Script Debugger to its Full Potential appeared first on Geist Interactive.
View the full article
Part 2: What Should You Consider When Selecting a Development Partner? What Questions Might You Ask a Potential Developer?
Hiring a developer is about creating a working relationship. You want someone who gets your business and gets you. Having a good working relationship often determines the success or failure of a development project. Hire someone you are comfortable with who also has the skills necessary to make your project successful. Beyond the quality of the working relationsh
FileMaker Kanban is the latest tool that offers familiar functionality for users and flexibility for the developer. It offers great functionality and organizes your data visually into lanes and cards.
The post FileMaker Kanban: Organize Your Data appeared first on Geist Interactive.
View the full article
Sometimes someone else posts the definitive piece. Read this blog post by Lee Lukeheart, founder of Savvy Data, for the skinny on Filemaker and Gmail.
Source
Sometimes you need to add a field to an existing database that should have values for all the already existing records in the table. Say you’ve added a new field on an existing database. It’s not a calc field, but will have an auto-entered calculation field that will always be filled out. For example, in [...]
Source
or even use an old one… just HAVE a plan, and STICK to it. A few thoughts for the next time we make a brand new database: We should set some strict naming and formatting conventions so that all the names used for tables, field, layouts and scripts use the same rules, allowing us to [...]
Source
It’s funny how things I’ve studied thoroughly do not necessarily register themselves in my brain as useful knowledge until I’ve made use of them. In working with Filemaker, and learning it in a somewhat haphazard way, it’s cool to observe how I learn. First off, I started by reading many books and stuff on Filemaker [...]
Source
We’ve got a few websites based on WordPress. They’re little sites and have been hosted with GoDaddy since launch. GoDaddy is cheap, cheap, cheap, and good enough for the sites we’ve had up. But we want to drive more traffic to those sites, take hosting control of a couple other more complicated sites, and get [...]
Source
The client is running Magento 1.1.8. Magento was installed and configured a couple years ago by another company. The client wants to change the way shipping is calculated. There are three types of shipping each with a single fixed price:, Ground ($12), 2nd Day Air ($35) and 2nd Day Air Oversized ($65). Samples of the [...]
Source
We are trying to move our website to a new hosting company (godaddy is SLOW and not very easy to use – and, as we just found out, VERY RESTRICTIVE). We researched a bunch online and found that a good way to move a wordpress site safely (and with little or no downtime) is to [...]
Source
Gas, Liquid, or Solid: Drive On
--By—
Steven H. Blackwell
January 3rd 2012
Happy New Year to FileMaker developers and users around the world. We have a lot of work to do in the FileMaker World in 2012, and I am eager to get started.
A very key element and requirement for the reliable and safe deployment of FileMaker Pro files is, of course, FileMaker Server. And, of all the components of a FileMaker Server deployment, none is more important, I woul
FileMaker Academy Members Create Resources For You
In early 2011, a group of leading FileMaker Academy. The purpose of FM Academy is to further educate FileMaker users and developers to encourage best practices and foster further adoption of the software.
These companies are based in various regions of the United States. 360 Works, Atlanta; MightyData, Dallas/Austin/Houston; IT Solutions, Philadelphia/New York; Anvil Dataworks, Washington, DC/Baltimore; Fiddlehead Software, Portl
Beautiful stuff here… http://design-milk.com/2012-modern-calendars/
Especially this one from Calouette.
And if you need a shared calendar, SeedCode Calendar is on sale (and bundled with Zulu iCal Sync) though Dec 31st.
Source
There was a time, many years ago, when the maximum number of characters you could store in a FileMaker text field was 64,000. With the introduction of FileMaker 7 in 2004, that limit was expanded to approximately one billion characters (2 Gb of data divided by 2 bytes per Unicode character), i.e., more than you [...]
Source
This example demonstrates that even a single-step script can be optimized. You just have to think a little bit out of the box…
I was showing this as a surprise in my session Marvelous Optimizations at Pause On Error [x] London 2011. I used a sample file with 25 fields and 5,000 records and imported these records 5 times in a row in just 13 seconds. OK, 13 seconds is not bad but what if you need to import data into FileMaker Go over network? If you want to know how I imported the same data i
FileMaker Training or Coaching?
Training or coaching - which is right for you?
The simple answer:
Training is an overarching effort to teach you how to effectively use the FileMaker toolkit.
Coaching is a more tactical approach that focuses on learning how to apply the FileMaker toolkit to your specific application.
Here's an analogy that might make the distinction easier to grapple with:
read more
Source
Tactical Steps to Improve Your Sales Funnel
Last week, I wrote about the theory behind these sales tactics. You should review that first if you're interested.
The key is being able to identify an ideal prospect and 'know' who you are communicating with. There's a simple way to determine a qualified lead from an unqualified lead: ask the people involved.
Now let's figure out how to ask.
read more
Source
Welcome back for a second action-packed episode, as we continue exploring changes to the FileMaker 11 internal SQL parser. We ended part 1 by looking at the INSERT/SELECT construction which, as you may recall, provides the SQL equivalent of a FileMaker “add new records” import from one table to another. Actually, when you use INSERT/SELECT, [...]
Source
Invest Time On Leads That Will Become Sales
<p>I may be crazy for publishing this but we're putting our money where our mouth is. Skeleton Key advocates for transparent business practices. Have a look around our site and you'll see it everywhere. I'm going to pull the curtain back on our sales process. If that makes you uncomfortable, you have all the more reason to keep reading.
read more
Source
Skeleton Key - Angelbeat St. Louis : Apple in the Enterprise
Oliver Block, Systems Analyst and VP at Skeleton Key, joined expert speakers from industry giants such as Google, Symantec, VMware, Microsoft and Aruba Networks to speak at the Angelbeat seminar in Clayton, Missouri yesterday.
Oliver's presentation, entitled Apple In The Enterprise, covered best practices for integrating Apple Mac computers into enterprise networks. Oliver also provided tips for deploying and managing Apple mo
Most of the time when we print records in FileMaker, the output of every record appears pretty much the same, with similar formatting and design. But what if we want records to print with a completely different output design depending on the type of record? In this article we detail some of the various ways in which this can be achieved, and the pros and cons of each method…
Read the Full Article Here…
The second example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011 was the script for selecting Random Set of Records. I found this example in the FileMaker Knowledge Base and optimized it to run at least 158 times faster when selecting 10 random records out of 50,000.
This version of the example has FM Bench Detective script steps included to measure the original and the optimized script more precisely. Watch the video recorded at Pause On Error below
This is the first example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011. I already wrote about this optimization some time ago. It’s the one that led me to unveil the Marvelous Optimization Formula. You can find the original article here: FileMaker Script Execution Time Cut From 5 Hours To 6 Seconds
I simply took the example and added FM Bench Detective into it to be able to exactly measure and examine what happens in the slow and the optimized script
March 9, 2010 is a date I recall quite clearly: not only was it the release date for FileMaker 11; it was also the day a bunch of my FileMaker SQL code broke, due to changes in the FM 11 internal SQL parser. If you’re new to this subject, or perhaps a bit rusty, I [...]
Source
A lot of folks have been asking for the Virtual List example file we put together with Bruce Robertson, so here it is: VirtualList.zip
This Virtual List technique is part of what make our Calendar fast, and allows FMSearchResults to show records from different tables in the same ‘portal’. We demonstrated some applications of this at DevCon’s Year in Review in 2010 and 2011, showing how this can really speed up FileMaker displays, especially those formatted as columns, grids, or lists.
Tod
