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.
FileMaker offers many different options for charting, but if you need a chart that is not available in FileMaker, you should consider using Google Charts. Google Charts is a free Javascript framework that can be used in conjunction with web viewers in FileMaker to extend your charting capabilities: https://dbservices.com/articles/google-charts-in-filemaker/
dbservices.com
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
Michael Layne from Gearbox Solutions presents on FileMaker’s new JSON functions. He does a deep dive into FileMaker’s new JSON functions and demos several examples of how they are using JSON for passing parameters, populating form data, validation and rollback, managing session info such as value lists as global. Michael also demos REST client and REST server with new data API.
The post FileMaker JSON, REST, and the Data API appeared first on Blue Feather - FileMaker Developer, Android, We
[ Edit: 3/16/2016 - With the help of some other people, we have been able to recover, or recreate some of the original images from original thread. ]
Security is always a big topic when it involves data, or people, or possessions. Recently, over on the FileMaker Community, there was a very beneficial discussion regarding security. Unfortunately, that discussion was the victim of a necessary action...and was deleted. It was deleted, because the discussion was tied to a video that, as was det
Hacking Your Own FileMaker Platform Solutions
Should FileMaker Platform developers mount hacking attacks on their own solutions? At first glance, this may seem an odd question. But I believe that the answer is “Yes, we should.”
Consider this. As developers we see our solutions from a totally different perspective than Threat Agents see them. Without practicing our own hacking skills, we can become blind to the vulnerabilities a Threat Agent can exploit to compromise the Confidentiality
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
We have a small subset of customers who wire their calendars up to act as dashboards on big displays. I’ve always thought this was cool and someday hope to get around to making one for SeedCode, a la the great dashboard at Panic.
One of these customers asked for something pretty cool today: they wanted to be able to cycle through the different resources on the calendar (recording studios in her system), showing each one on the week view for a few seconds, before moving to the next studio autom
FileMaker Number Functions Video Series
Last week we featured a series of five (5) videos from our Certified FileMaker Developer, Chad Adams, on our Facebook and Twitter social media profiles. He created these videos to both compliment a series of Text Function videos he did earlier this year, and to offer as a supplemental resource for other developers and/or novice FileMaker users.
Chad chose to cover these particular Number Functions because they are ones that he uses most often, and t
A Different Perspective On Recently Released
FileMaker, Inc. How To Paper
Regarding External Authentication Configuration
By
Wim Decorte
and
Steven H. Blackwell
I am pleased to have as co-author of this BLOG posting the renown and exceptionally highly regarded “developer’s developer” Wim Decorte.
FileMaker, Inc. recently published a FileMaker How To article entitled Replicating an External Authentication Environment for Develop
Sometimes the hard stuff turns out to be really easy.
It always impresses me that Jason has a way of finding the simplest ways of doing things. For example, when iCal treats a holiday as an all day event, SeedCode can pick that up as a two-day event. A customer asked about how to work around this, changing the iCal parser in SeedCode Calendar Pro.
Jason sent them this screen shot showing how you can more easily teach SeedCode to ignore the end date of the holiday calendar, after the iCal eve
West Coast FMPug Tour Guest Speaker Jason Thomas on Sales
This week, the Skeleton Key office will sacrifice the physical presence of our beloved head of sales – Jason Thomas – as he travels to the West Coast to speak to enthusiastic
Jason’s topic is Sales. His goal is to expand awareness of the need for a sales process while leveraging the expertise that already resides within both the in-house developer and consultant communities. He hopes to provide new knowledge, and improve attendees
Have you ever wished there were an easy way to summarize the contents of one portal in another portal? Perhaps something along the lines of the “Summary” portal below? I’ve touched on the possibility of using a portal to produce (or assist in the production of) an on-screen summary report a couple times in the [...]
Source
This weekend, Todd Geist and I took the train up from LA for a 33 hour code sprint and built the start of Worx, the next file for GoZync.
This is a great way to work and we got a ton done.
Todd on the Coast Starlight
Worx is a work orders system for iPad: users in the office assign orders to technicians and those techs “zync” the orders down to their iPads before completing the orders. Orders come down with contact info, maps, and a serious items database capable of browsing and selecti
This is a fresh story of me spending hours trying to fix a technical issue and accidentally revealing a gold nugget. A few days ago one of my nightly server-side scripts stopped working without any apparent reason. But when I tried to run the script in FileMaker Pro it worked just fine. I really needed a way to debug the script on the server.
Read more here
Skeleton Key - The Positive Effect
Marketing – be it 'traditional', word-of-mouth, grassroots or social media based, is not new for me.
Marketing for Skeleton Key, a service-driven, Custom Application Development/Information Technology Consulting company is relatively new for me.
My adventure began in mid-January...
In order to promote and solidify the Skeleton Key (SK) brand to the widest-reaching audience and business consumers of FileMaker software, I had to learn to understand wha
Broadly speaking, FileMaker developers fall into three categories: a) those who do all their development on local files; those who do all their development on hosted files; and c) those who sometimes develop locally, and sometimes in a hosted environment. I happen to fall into category “c”, and suspect that most of my colleagues [...]
Source
