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
Interested in Learning More About Open-Book Management?
Next week marks the 20th annual conference on Open-Book Management, the Gathering of Games. The conference will be held at the Hyatt Regency St. Louis at the Arch from May 9th through 11th.
Conference participants will celebrate and kick off the 20th Anniversary of the Gathering of Games on May 9th, 6pm, at Busch Stadium, home of the 2011 World Series Champions. This networking reception will be an all-inclusive event: dinner,
Server File Management - Day 8 of 12 Days of FileMaker 12 Web Series
Thursday, May 3rd, marked Day Eight of FM Academy's 12 Days of FileMaker 12 Web Series.
Server File Management, hosted by IT Solutions Consulting summary:
Changes in FileMaker Server 12’s Backup scheme, and the new ability to store Container data externally, offer significant improvements in data protection, performance and delivery to the user.
In this session we explored how Progressive Backups work. We also di
Design Surface Behavior Changes - Day 7 of 12 Days of FileMaker 12 Web Series
Tuesday, May 1st, marked Day Seven of FM Academy's 12 Days of FileMaker 12 Web Series.
Design Surface Behavior Changes, hosted by Anvil Dataworks summary:
As files are converted to the new version of FileMaker, we will notice changes to the layout appearance. Objects will use the default themes of a layout, or that rounded or gradient themes options are already applied. In the webinar we will look at the
I have a confession: when I first read about dynamic parameters in the Help entry for ExecuteSQL, my initial reaction was, “Why do they have to make it so darn complicated?” I have another confession: I am now singing a very different tune indeed. I’ll get to the reason for this in a minute, but [...]
Source
It’s been a fun week experimenting with the ExecuteSQL function, and also seeing what others are doing with it. In some cases the experience has been eye opening, and I strongly recommend that anyone interested in ExecuteSQL grab the SQL Builder file from Eden Morris, available at http://fmforums.com/forum/files/file/25-sql-builder/ This attractive and powerful tool provides a [...]
Source
Container Field Enhancements - Day 6 of 12 Days of FileMaker 12 Web Series
<p>Thursday, April 26th, marked Day Six of FM Academy's 12 Days of FileMaker 12 Web Series.
Source
Quick Table View - Day 5 of 12 Days of FileMaker 12 Web Series
Tuesday, April 24th, marked Day Five of FM Academy's 12 Days of FileMaker 12 Web Series.
Source
One of the fun things about a new FileMaker release is figuring out how new features work, including subtle behavioral nuances. Today’s demo file, FM12 ExecuteSQL Help Example from CW, is based on Corn Walker’s re-working of one of the demos from part 1, and helps demonstrate how ExecuteSQL fits in with the FileMaker security [...]
Source
The problem.
SQL, including the new ExecuteSQL calc function in FileMaker 12, returns dates in this format: YYYY-MM-DD. This can be a bit of a pain if you have a string of text like this and just want to transform the date part:1170 - 2012-03-09 - - Keep: Beta Presentation @ BRN Co1171 - 2012-03-15 - 08:30:00 - Call Arthur Murray to finalize data1172 - 2012-03-16 - 12:30:00 - Conference call with Melinda1173 - 2012-03-20 - 11:15:00 - @ Breakfast
The calc for the results above looks like this
FileMaker Go Enhancements - Day 4 of 12 Days of FileMaker 12 Web Series
<p>Thursday, April 19th, marked Day Four of FM Academy's 12 Days of FileMaker 12 Web Series.
Source
Layout Mode Enhancements - Day 3 of 12 Days of FileMaker 12 Web Series
Tuesday, April 17th, marked Day Three of FM Academy's 12 Days of FileMaker 12 Web Series.
Layout Mode Enhancements, hosted by Kyo Logic, summary:
FileMaker 12 houses powerful new features to align, position and manage objects on your layouts. In this webinar, we explored how these powerful new features will help you design a more consistent and graphically pleasing application. The presenter, John Mathewson, took us
FileMaker 12 offers many intriguing new features, including new windowing capabilities, significant charting and container field improvements, and a brand new design surface. But to my way of thinking, all of these pale in comparison to the exciting possibilities offered by the new ExecuteSQL function. What’s so great about ExecuteSQL? In a nutshell, it allows [...]
Source
FileMaker 12 and SuperContainer: A comparison
Of all of the new features in the recently released FileMaker 12, one of the most significant is the inclusion of enhanced container fields with managed storage. These enhanced container fields offer users a simple solution to store container assets outside of the database file in order to avoid increasing the size of the database file itself.
Solving this issue was the driving force behind the development of 360Works' SuperCont
If you wanted to use a tab control on your layout but hide it from your users, you used to have to cover it with another tab and/or make the tab text very small. This is because you both have to visually hide the tab AND prevent users who actually click on it’s tab controls from activating it. While this worked, the layouts were kind of hard to use in layout mode: it was often hard to find the tabs at all.
Fortunately this is a lot easier in 12. And not only because tab controls work in layout
Richard Carlton Consulting is pleased to announce the immediate availability of their FileMaker Go Training Tool.
The FileMaker Go Training Tool is designed to help both new and seasoned FileMaker Developers learn the functional differences between FileMaker Pro (for the desktop) and FileMaker Go (for the iPhone and iPad). While FileMaker Go is fundamentally FileMaker, it does have certain limitations and new capabilities that are specific to iOS – the iPhone and iPad operating systems – as we
FileMaker 12 is here, and with it comes many new cool new features, a lot of which are a result of the new css-based layout engine. In this article we are focusing on one small change borne out of the new layout engine which has massive potential for building new interface controls.
Click to read the full article…
Charting Enhancements - Day 2 of 12 Days of FileMaker 12 Web Series
Thursday, April 12th, marked Day Two of FM Academy's 12 Days of FileMaker 12 Web Series.
<p>
Source
We’ve just taken the covers off a completely redesigned website of our own. The new Linear Blue site is based on a design by prestigious branding and design company, CaB Studios. We hope you like our new logo and website design (take a look here) and we’d love to hear your feedback.
Source
New Layout Design Surface - Day 1 of 12 Days of FileMaker 12 Web Series
Tuesday, April 10th, marked Day One of FM Academy's 12 Days of FileMaker 12 Web Series.
New Layout Design Surface, hosted by Anvil Dataworks summary:
When designing new modules or systems, one bottleneck to the turnaround time involves the development of Interfaces. The layout design surface of FileMaker Pro 12 has given us tools to streamline interface development, revamped layout themes, and give the Inspector
RCC is pleased to announce the immediate availability of FileMaker Starting Point 3, tuned specifically for FileMaker 12.
FM Starting Point 3 contains all of the great features and capabilities of previous versions, but also features an improved user interface with the upgraded capabilities of FileMaker 12. FM Starting Point 3 has full support for the iPad, in that all layouts created for the desktop have also been optimized for the iPad. Because the iPad version of FileMaker is now comple
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
