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.
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
Forums are a great way to get technical advice for FileMaker but for some reason, many people don't think they have to be nice in the electronic world. I was raised to say "please" and "thank you" and that has translated over to the internet for me. But, other folks think the anonymity of cyberspace is an excuse to be a jerk. Some posters are outright offensive and others will just leave snide responses like, "that wasn't much help". News flash! People on the internet are real and you should be
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
Part 2: What Should You Consider When Selecting a Development Partner? What Questions Might You Ask a Potential Developer?
Hiring a developer is about creating a working relationship. You want someone who gets your business and gets you. Having a good working relationship often determines the success or failure of a development project. Hire someone you are comfortable with who also has the skills necessary to make your project successful. Beyond the quality of the working relationsh
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
Using iPads, FileMaker 12, and GoZyc
Just posted a great case study from the GoZync experts at FullCity Consulting. They’re taking water quality inspections offline on their iPads, the syncing the data–along with signatures and photos–back to the hosted solution as soon as they have cell signal.
Check out the case study.
Source
Server Performance - Bonus Topic 2 of 12 Days of FileMaker 12 Web Series
Thursday, May 24th, marked Bonus Topic #2 of FM Academy's 12 Days of FileMaker 12 Web Series.
read more
Source
Window Styles - Bonus Topic 1 of 12 Days of FileMaker 12 Web Series
Great news! By popular demand, FM Academy added 3 sessions to the 12 Days of FileMaker 12 Series.
Tuesday, May 22nd, marked Bonus Topic #1.
Enhancements to the New Window script step will give developers much more control over new windows and their behavior. This webinar presented techniques for utilizing the new “Specify Advanced Styles” option to configure modeless document windows and modal dialog windows. We expl
In part 1, I listed six scenarios that could potentially cause ExecuteSQL code to break: …and managed to get through the first five before running out of steam. This time, we’re going to look at #6 on the list, as well as some other observations, and I invite you to download and follow along in [...]
Source
Moving to FileMaker 12 - Day 12 of 12 Days of FileMaker 12 Web Series
<p>Thursday, May 17th, marked Day Twelve of FM Academy's 12 Days of FileMaker 12 Web Series.
Source
Script Trigger Enhancements - Day 11 of 12 Days of FileMaker 12 Web Series
<p>Tuesday, May 15th, marked Day Eleven of FM Academy's 12 Days of FileMaker 12 Web Series.
Source
Just got this from John Weinshel and had to share…
“I love SQL, love that it’s as old as relational databases, sort of Codd’s afterthought. It’s like Freud, after describing his entirely new model of the universe, added a coda, psychoanalysis, for putting it to use. Except SQL is free and it works.”
Priceless.
Source
ExecuteSQL - Day 10 of 12 Days of FileMaker 12 Web Series
<p>Thursday, May 10th, marked Day Ten of FM Academy's 12 Days of FileMaker 12 Web Series.
Source
Portal scrolling has always been a bit of a struggle in FileMaker Go up until the release of version 12. This article outlines some of the changes to portal scrolling in FileMaker Go 12 and we give a couple of examples how it can be set-up to give a very nice native-application look and feel. We also cover field scrolling.
Click to read the full article!
[Note: Some of the material in this article, and in today's demo file ExecuteSQL Sandbox, previously appeared in my March 2011 article, Custom Functions for Internal SQL.] The other day a colleague remarked, “You know, it’s going to be interesting to see if you SQL guys are still so excited about ExecuteSQL when something gets [...]
Source
Very proud to have shipped SQL Explorer, a tool for learning SQL (so you can use ExecuteSQL in FileMaker 12) using FileMaker metaphors you already know. You can learn more about the Explorer and download a copy here: SQLexplorer But I wanted to take a moment and point out three things that make this a new kind of product for us…
1. This is the first product we built using a FileMaker 12 theme. All the layouts in the solution are based on the Onyx theme, though we did add some of our ow
New Calculation Functions - Day 9 of 12 Days of FileMaker 12 Web Series
<p>Tuesday, May 8th, marked Day Nine of FM Academy's 12 Days of FileMaker 12 Web Series.
Source
This is a quick follow-up to part 1, with a couple more observations about dynamic parameters. a) I can’t believe I forgot to mention this the other day: A major ExecuteSQL headache that dynamic parameters can alleviate is the dreaded “embedded apostrophe” problem. In case you aren’t familiar with it, if your text string has an [...]
Source
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
