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.
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
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
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
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
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
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
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
