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.
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
Free webinar introducing Karbon our free application framework for building ambitious custom business applications. If you are interested in using the FileMaker Workplace Innovation Platform at a high level you'll probably want to see what we have cooked up.
The post Karbon Webinar – Getting Started appeared first on Geist Interactive.
View the full article
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
Hi all,
Today I'm happy to announce the release of Elemental for FileMaker. This is a free fully unlocked solution containing some cool user interface and design stuff that I hope you find useful and can incorporate into your own solutions.
You can grab a copy now at https://www.elemental-fm.com
In Elementals first version you'll find the following:
Avatars
Over 20 API integrations with avatar generators. These are uniquely generated based on a name y
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
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
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
