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.
Author’s note: Inevitable comparisons will be drawn between the new While function and the venerable CustomList custom function, which I wrote about at length several years ago. Preliminary testing indicates that CustomList is faster under certain circumstances and While is faster under others. In my opinion, both of them belong in your developer tool kit. […]
View the full article
Hierarchical JSON Viewer / Editor
By Andy Persons & Doug West
One of the standout new features of FileMaker Pro 16 is native support for the JSON data-interchange format. In addition to providing easy integration with a host of online services, it also provides developers with the tools to create robust hierarchical structures for use entirely within FileMaker. This hierarchical JSON viewer / editor file provides some tools for visualizing, manipulating, and leveraging JSON text.
Features
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
WidgetStudio makes it easy to use, design and share powerful interface widgets, like calendars, gauges, charts, and timers. Pick from the constantly growing set of included widgets or build your own. Freely share them with your customers or friends.
The post Announcing WidgetStudio – FileMaker WebViewer Widgets appeared first on Geist Interactive.
View the full article
GoDraw3 is a FileMaker drawing tool for users. For FileMaker developers, however, it is full of customization. A developer can do with it what she wants.
The post GoDraw3: Hack the Heck Out of It appeared first on Geist Interactive.
View the full article
Join us for FM Academy's 12 Days of FileMaker 12 Web Series
So FileMaker 12 has been released....now what?
Join us for free webinars, beginning April 10th through May 17th, presented by the member's of:
FM Academy, a collaboration of leading FileMaker development and training companies, is proud to announce the 12 Days of FileMaker 12 webinar series. Each Tuesday and Thursday for the next six weeks the Academy will host a 60-minute webinar on a new feature of the FileMaker 12 produc
Simplify and Stay on Screen
FileMaker 12 lets us run SQL queries against our own FileMaker tables. This has been possible with plugins for a while and a number of serious devs like Mike Lee, Greg Lane, and Kevin Frank have been talking about what a great technique this is. I completely agree and think the new ExecuteSQL calc function is the killer feature of FileMaker 12.
Before SQL
There are a few reasons for this and I hope to get to write about more of them. But for now, consider
We’re thrilled to announce our new Free Calendar Template for FileMaker 12. We’ve rewritten the free calendar to take advantage of some of the new things in FileMaker 12, including the new look and feel, but perhaps most importantly, the new ExecuteSQL function.
This makes the new calendar simpler, less dependent on context, and easier to integrate.
Checkout this short introduction demonstrating how this new SQL stuff makes things simpler:
Now download a copy of the new calendar and d
April 27th--Update.
We were recently advised that a last minute change in the encryption level of secure storage resulted in that encryption's being 128 bit, not 256 bit as the attached document on Containers states. This is still a strong level of encryption.
April 4th 2012
Today’s release of FileMaker® Server 12, together with its companion FileMaker Pro and FileMaker GO products, marks another important milestone on the FileMaker, Inc. Product Roadmap.
FileMaker Server is at the center
Well, we’ve reached what may well be the final posting in this extended series of articles. We’ve covered a lot of ground, and this article assumes familiarity with what has come before (in parts 1, 1.1, 2, 3 and 4). Today we’re going to look at a couple “Virtual List” implementations of the User-Friendly Excel [...]
Source
We can deliver solutions either as a desktop, web or mobile application, according to your business needs. Recently, technology industry news has been dominated by the arrival of the tablet and its growing role in helping businesses reach new levels of productivity and success. We can help you utilise the new and powerful FileMaker Go...
Source
Skeleton Key Looks Forward to FileMaker Developer Conference 2012
Skeleton Key is excited to have three speakers at the 2012 FileMaker Developer Conference. The conference is the largest annual gathering of FileMaker database developers, trainers and users. This year it will be held July 16-19, 2012, at the Fontainebleau Hotel in Miami, Florida.
read more
Source
Colleagues and family members are starting to express concern at my obsessive refusal to bring this series to a close. But we’re getting close. Really. In fact, today, we’re going to look at two cool tricks (and one work around) which are utilized in this article’s demo file, excel exports, part 4, but that could [...]
Source
...the Teacher Will Appear : Path to Certification
Passing the FileMaker certification test...
Years ago, on April Fool's day, one of my teacher's gave us the world's hardest test. The questions covered a wide range of 'topics':
Sociology: Estimate the sociological problems, which might accompany the end of the world. Construct an experiment to test your theory.
Physics: Define the universe and give three examples.
Medicine: You have been provided with a razor blade, a piece of gauz
So far in this series we’ve been looking at exporting data to Excel from a single table (Contacts). Today we’re going to extend the technique to encompass a second, related table, Donations, and without too much trouble we can leverage existing work from earlier entries in this series (part 1, part 1.1 and part 2). [...]
Source
Awww, scratch that last post, as yet another thing has gone wrong with this horrific ‘easy’billing database. Now the invoice numbers aren’t updating – we had this problem before but the solution was ?? – it just fixed itself magically, as far was we could tell. I strongly dislike old databases. My advice to all: [...]
Source
Path to Certification : When the Student is Ready...
As part of my recent on-boarding process at Skeleton Key, I immediately began training for FileMaker certification. Fast forward 2 months, I am FileMaker Certified in 10 and 11.
My training consisted of four main interactive methods:
Absorbing the FileMaker Training Series book
Participating in FileMaker-specific webinars
Receiving one-on-one FileMaker Coaching
Researching 'FileMaker' to broaden my scope on topic details n
This is the third article in our series of tips and hints for FileMaker. This time we are focusing on scripts - from their creation, to editing and debugging. Take it as it is - this is just an assortment of our favorite time-savers, shortcuts, tips, hints, tricks, tools of the trade and more…
Read the Full Article Here…
Designing Faster iOS Database Apps - How To Guide Published for FileMaker Developer Community Members
Mark's most recent collaboration with FileMaker, the How To Guide – Designing Faster iOS Database Apps – describes best practices for designing FileMaker Pro database applications for optimal performance on iPhone and iPad. FileMaker Pro developers will learn to design high-performance applications by following best practices in key areas including Layout Design, Database Design and Wide A
FM Academy Free Webinar Today - Look Before You Leap - Pick the Right Deployment Model for Your FileMaker Go Application
Join us for a Free Webinar:
Date: TODAY! Wednesday, February 29, 2012
Time: 1:00 PM - 2:00 PM (CST) / 2:00 PM – 3:00 PM (EST) / 11:00 AM - 12:00 PM (PST)
read more
Source
David Knight of Angel City Data has put out a great webinar for FileMaker on performance tuning your FileMaker Go solutions.
Needless to say, for “the ultimate performance” he endorses using the solution locally and syncing to the server using GoZync. (Thanks David!)
David also has a nice shout out to Jason Young’s 2011 DevCon session on making FileMaker Server your super user.
Watch the webinar.
Learn more about GoZync.
Source
[Note: To avoid a huge amount of redundant repetition, this article assumes that you are familiar with part 1 and part 1.1 in this series.] Today we’re going to take a look at streamlining the approach introduced in part 1 by reducing clutter on the Relationships Graph, going from this… …to this, with no loss [...]
Source
Bruce Robertson emailed me off list with an improved version of my demo from part 1, excel exports, part 1.1, which I am sharing with his permission. The improvements are… a) live preview fields showing the data to be exported. an “Eval Error Tester” script to make sure the output code in the alias [...]
Source
Many end users appreciate FileMaker’s ability to export a found set of records in Excel format — it’s fast, straight-forward and empowering. One request that I have received from clients multiple times over the years is: make the exported field names in the top row of the spreadsheet “human-friendly”… For example, instead of this: …perhaps they [...]
Source
Those of you who attended DevCon 2011 in San Diego may recall meeting Andries Heylen of BH&A, who cheerfully answered questions in the FileMaker Genius Bar. Well, from the sow’s ear demo I posted in part 1, Andries has woven a silk purse (google-route-mapping-part-2), which I am sharing with his permission, and which uses Google [...]
Source
External Server Authentication and [Full Access] Privilegesâ¦
Life (or FileMaker) May Not Be What At First It Seems
-By-
Steven H. Blackwell
Someone recently advised me about a discussion on a FileMaker List that focused on the supposed ability of a user with an Account authenticated by External Server Authentication and attached to the [Full Access] Privilege Set to make changes in a hosted fileâs security schema. (Technically this is a Group, not an Acco
