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
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>
The developers at IT Solutions just completed a great FileMaker Go project for the Center for Disabilities Studies at the University of Delaware.
The solution facilitates in-person evaluations of 100 public schools across the state and replaces a paper system that delayed feedback and analysis of this important information.
I can’t express how much FileMaker Go and the app developed by IT Solutions has positively impacted our project. We’re now able to complete evaluations in less time, an
Beautiful screen shot sent to us by Don Blaylock of Noble Casings…
…Don says:
I appreciate all your help. The syncing is working awesome! GoZync was central to the success of this and future products!!!
Glad to hear it Don; and thanks for the sexy screen shot: love the dimmed “1″ and “2″.
<a href="http://seedcodenext.wordpress.com/2013/03/25/gozync-customer-solution-rigman/">Source</a>
Cool and provocative video by Todd Geist showing how he incorporates unit testing into a new project: Unit Testing in FileMaker. Nice stuff.
<a href="http://seedcodenext.wordpress.com/2013/03/23/unit-testing-for-filemaker/">Source</a>
HierarchyLite - FileMaker Pro® 12 Tips and Tricks Demo of a Simplified Approach to Hierarchal Portals!
Another FREE FileMaker Pro 12 Tips and Tricks Demo file showing an even more simplified approach to hierarchal portals by Doug West, Product/Project manager of Excelisys. Doug has now made this advanced technique, originally developed by our own Andy Persons, even easier! “HierarchyLite” is an EXcellent FREE FileMaker Pro 12 Tips and Tricks demo file which outlines how to create those cool h
Linear Blue are proud to announce the merger of the SyncDeK & fmDataGuard product suite to our expanding product range. As of April 1, Linear Blue welcomes the WorldSync product suite and its former CEO to join our excellent development team. As one of the foremost Platinum members of the FileMaker Business Alliance, we are...
Source
