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.
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
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
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
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
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
<p><a href="/blog/developers-where-do-you-keep-your-tools"><br /><h1>Developers: Where Do You Keep Your Tools?</h1>
<p></p></a></p>
<p><a href="http://www.skeletonkey.com/images/Blog/ToolBox3.jpg" align="right"><img width="345" height="300" src="http://www.skeletonkey.com/images/Blog/ToolBox3.jpg" /></a></p>
<p>I think every developer should create their own toolbox of code snippets to reuse as needed
A Wrinkle in Timeliness Pt 2 – Perfecting FileMaker Pro Recursion & Virtualization, by Andy Persons of Excelisys
Perfecting FileMaker Pro Recursion & Virtualization Part 2 explores the use of recursion and virtualization (through global variables) in solving complex data interconnectivity challenges using FileMaker Pro 12 in a multi-user client-server environment. Using a specific case study of an Excelisys project/client in the medical manufacturing industry, Andy discusses and demons
Once you distribute offline files to your users, how do you keep making changes, fix bugs, and re-distribute the files without breaking things or ending up with duplicate files on someone’s iPad?
GoZync makes this easy, and this short video shows how. It also demonstrates that GoZync can let you recover from schema errors you might introduce when you’re defining fields. You’ll see how we capture errors (like “the field we’re trying to sync is no longer there”) and let you re-play a sync after y
“What's in a name? that which we call a rose,
By any other name would smell as sweet.”
—Juliet (Romeo and Juliet, Act II, Scene 2, William Shakespeare)—
“The beginning of wisdom is to call things by their proper name.”
—Confucius—
An entire series of recent studies[1] published by well-known and well renown international security analysis and information industry firms have all made, in slightly varying language, the following key points:
Da
Disclaimer: This article contains speculative and experimental techniques that are in the proof-of-concept stage. Use at your own risk and test thoroughly. In part 1 of this series, we defined radical separation as a separation model scenario in which the developer no longer has access to a data file once a solution had been deployed. [...]
<a href="http://www.filemakerhacks.com/?p=7682">Source</a>
One apparent limitation of using ExSQL() in the separation model is that you can’t use unrelated tables in a field definition. So you’d need to related all your tables to one another.
I just discovered that you can bypass that limitation simply by wrapping your statement in a Let() and declaring a variable that includes wrapping a field in the GetFieldName() function.
So the expression: Let( field = unrelated::table ; field ) returns an error.
However, Let( gfn = GetFieldName ( unrelated::tab
One apparent limitation of using ExSQL() in the separation model is that you can’t use unrelated tables in a field definition. So you’d need to related all your tables to one another.
I just discovered that you can bypass that limitation simply by wrapping your statement in a Let() and declaring a variable that includes wrapping a field in the GetFieldName() function.
So the expression:
Let( field = unrelated::table ; field )
returns an error.
However,
Let( gfn = GetFieldName ( unrelated::
Jason’s swapping out the results portal in our free SQL Explorer with a webviewer so he can take advantage of column resizing and other UI goodies you just don’t see in FileMaker. The second part of the video shows how he lets users easily swap out the styles used in the “portal” as their layouts change.
HTML5 in FileMaker apps. Yummy.
<a href="http://seedcodenext.wordpress.com/2013/05/01/webvier-portals-preview-of-sql-explorer-next/">Source</a>
Todd and I have been working on some changes to GoZync, and the latest build offers a substantially faster sync down from hosted files.
In one test, pulling 5,000 new contacts went from 12:52 to 2:00 minutes flat. (Times will be longer on mobile and over shaky connections.) This is a big improvement.
Add this to Your Deployment
Needless to say, we recommend this for all users: only 4 scripts were changed so updating existing deployments is easy, though you will need to distribute new copies o
Heard very good things about this program for onboarding new developers. New cohort starting in June: http://thorsenconsulting.com/filemaker-virtual-training-program-jump-start-your-career-as-a-developer/
FileMaker’s answer to: https://www.codefellows.org/#bootcamps
Molly: Thorsen Consulting
<a href="http://seedcodenext.wordpress.com/2013/04/25/filemaker-training/">Source</a>
I’ve said before, and no doubt will say again, that one of my favorite things about this blog is how much I learn from your feedback and the demo files you send me. Recently I received a file from Otmar Kramnis of the Hochschule Luzern demonstrating the fastest SQL-based method I have yet seen to [...]
<a href="http://www.filemakerhacks.com/?p=7624">Source</a>
Background: ID Lists
I have one thing (at least) to follow up with on my ExecuteSQL using the Found Set post from a little bit back. This was to see if I could get the RecordID parsing optimized (or at least faster) using some of the techniques in Todd’s Hyperlist demo. Although this is not the slow part of the process–feeding the large set of values into the SQL IN clause is the slow part–it still did seem worth pursuing for two reasons: Firs,t to get my head around Hyperlist and the underl
<p><a href="/blog/filemaker-licensing-and-conversion-have-no-fear"><br /><h1>FileMaker Licensing and Conversion: Have No Fear!</h1>
<p></p></a></p>
<p><a href="http://www.skeletonkey.com/images/Blog/FMConversionimage_open_2x%20copy.jpg" align="right"><img width="300" height="231" src="http://www.skeletonkey.com/images/Blog/FMConversionimage_open_2x%20copy.jpg" /><br /></a></p>
<p><i>Does t
A Wrinkle in Timeliness – Perfecting FileMaker Recursion & Virtualization, by Andy Persons of Excelisys
A Wrinkle in Timeliness Pt1 of 4 – Perfecting FileMaker Recursion & Virtualization, by Andrew Persons explores the use of recursion and virtualization (through global variables) in solving complex data interconnectivity challenges using FileMaker Pro 12 in a multi-user client-server environment. Using a specific case study of an Excelisys project/client in the medical manufacturing
Weave is cool little app that begins by reading the event kit data from your iPhone and showing your calendar events in a rough todo list.
You can’t do much with these existing events, but you can make new to-do items. And when you go to mark one as “done”, you see the screen at the right.
And you can see how Weave can get you to log your time and track your expenses. Pretty cool. Screenshots of weave on the app store show project income and expenses and the tasks completed by others.
Now you
Ten Frequently Encountered Practices
That Can Compromise Security of FileMaker Pro Files
April 9th 2013
In our last installment, I noted:
“In 2013, I will be focusing on promoting the goal of achieving that understanding [meaning understanding FileMaker Server] along with the parallel and related one of overcoming a similar lack of understanding and awareness about FileMaker security items.”
In this post I want to focus on ten frequently encountered practic
I spent some time this weekend doing some old fashioned FileMaker hacking that I’ve always enjoyed (viva La WorkAround Pro). Definitely inspired by Todd Geist’s very cool hyper-list stuff, but he had also reminded me of the problem of ExecuteSQL on the found set, and I’ve heard this as a common feature request. My big take away from Todd’s comments was that the found set is a uniquely powerful thing, so if it could somehow be incorporated into FMSQL, then that would certainly be a potentially
So, is this crazy or cool?
Let ( [ uid = Get ( UUID ) ] ; Substitute ( $sc_List & uid ; [ ¶ & uid ; "" ] ; [ uid ; "" ] ) )
If UUID is good enough for your primary key, is it good enough for this?
<a href="http://seedcodenext.wordpress.com/2013/04/04/trailing-carriage-return-removal-method-3412/">Source</a>
<p><a href="/blog/FM-Academy-Webinar-a-FileMaker-Ecosystem-From-Desk-To-Web-To-Mobile"><br /><h1>FM Academy Webinar - A FileMaker Ecosystem: From Desk to Web to Mobile</h1>
<p></p></a></p>
<p><a href="http://www.skeletonkey.com/images/Blog/FMAWebAprilImage.jpg" align="right"><img width="200" height="96" src="http://www.skeletonkey.com/images/Blog/FMAWebAprilImage.jpg" /><br /></a></p>
<p>Join u
<p><a href="http://www.skeletonkey.com/blog/good-to-great-stockdale-paradox-your-data-all-connected"><br /><h1>Good to Great, Stockdale Paradox, Your Data- They're All Connected</h1>
<p></p></a> </p>
<p><a href="http://www.skeletonkey.com/images/Blog/Good-to-great.jpg" align="right"><img width="150" height="251" src="http://www.skeletonkey.com/images/Blog/Good-to-great.jpg" /></a></p>
<p>As part of ou
Creating User Specific Reports Using FileMaker Pro Privilege Sets
If you’ve ever wanted to generate specific reports for different groups of users, but are intimidated by FileMaker’s, somewhat complicated security schema, this PDF shows you an alternative methodology that is very simple and easy to implement, using FileMaker Pro privilege sets.
Recently a client, a large bail bond company, wanted to be able to add reports easily, that could only be viewed by specific employees, and without h
Well, that’s what happens when you post things to the wrong blog! =)
Internally we try to publish the most effusive comments form the last week’s support cases every Friday–”fan mail friday”–just to let everyone know what their teammates have been up to.
We *usually* post this privately: sorry for the interruption. “Happy Friday” everyone.
- John
<a href="http://seedcodenext.wordpress.com/2013/03/29/fan-mail-friday/">Source</a>
Previously in this blog I have discussed the new ExecuteSQL functionality in FileMaker12 and how useful I find this. I would like to share with you one example of how I have used this. I have a client who has a sales system which has a report that shows the position of Accounts for all...
<a href="http://feedproxy.google.com/~r/LinearChat/~3/cl7M4wpq9e0/">Source</a>
