Welcome to the Press Room
Here you can find news from around the FileMaker world.
FMPug News
TheraQuick: A Design of Power and Splendor
Feb 22, 2012
Productive Computing, Inc. has an esteemed reputation for developing custom products for companies of various industries and over a decade of experience producing commercial solutions. Utilizing the powerful database software tool, FileMaker Pro, PCI has the ability to create customized solutions to meet the unique specifications of any organization. Dale Stuart, President and owner of [...]Creating a Fundamental FileMaker Go Layout - Zoom Lock
Feb 17, 2012
Creating a Fundamental FileMaker Go Layout - Zoom Lock
Welcome to the third post in my blog series about Creating a Fundamental FileMaker Go Layout. This entry will cover Locking the Zoom Level on Filemaker Go Layouts.
The previous posts in the series covered:
How To Hire A Consultant
Feb 15, 2012
What is a consultant and why do I care about how to hire them? Good questions! First of all, here’s the dictionary reference for the word consultant: consultant |kənˈsəltnt| noun a person who provides expert advice professionally. Now why would you want to spend time reading this article instead of just hopping on the [...]No related posts.
A ‘Local’ Way to Suppress Script Triggers
Feb 10, 2012
Script triggers are a great feature in FileMaker that allow you to initiate a script when certain actions occur such as committing a record or leaving a layout. Not only do they run when user initiated, they can also be script initiated by script steps. This can sometimes produce unexpected results and so you may wish for triggers to be disabled. This article presents a very simple and elegant method of suppressing script triggers from firing when initiated by other scripts…Creating a Fundamental FileMaker Go Layout - Layout Sizing
Feb 10, 2012
Creating a Fundamental FileMaker Go Layout - Layout Sizing
This is the second blog post in a series about Creating a Fundamental Layout for use in FileMaker Go. The goal of this series is to offer practical advice and specific instructions for creating FileMaker Go layouts that look and act the way you, and your users, expect.
Today we'll be covering Layout Sizing.
Sizing a FileMaker Go layout is based on the idea of being able to Scroll Lock your layout. I cover the explanation and importance of this concept in my previous post of this series, Understanding Scroll Lock. In short, scroll lock is when the objects in a layout are contained within vertical and/or horizontal size constraints, causing the layout to conform to the expected behavior of layouts on mobile devices. The expected behavior is:
- If all objects are shown on a layout, lock the layout so it can't be moved.
- If not all of the objects on a layout are shown, allow the user to scroll horizontally and/or vertically in order to see the additional objects.
Running Credit Cards with FileMaker Go and Plastic
Feb 10, 2012
This tutorial video describes how to run credit card transactions from FileMaker Go using the 360Works Plastic plugin. The transcript is attached below, and the video can be watched on YouTube at http://www.youtube.com/watch?v=qrOucBq6HHg.
Outlook Manipulator for Mac Now Available!
Feb 09, 2012
FOR IMMEDIATE RELEASE San Diego, CA – February 9, 2012 - Productive Computing, Inc. a Platinum member of the FileMaker Business Alliance, announces the release of the Outlook Manipulator Plug-in for Macintosh. This dynamic plug-in provides a bi-directional data exchange between FileMaker® Pro and Microsoft Outlook® 2011. Users can become more efficient through the elimination [...]FileMaker Conditional Formatting
Feb 07, 2012
When the conditional formatting feature was announced by FileMaker some of us screamed “yeehaw”. No, really. It was a long-awaited feature and right away we knew there are no limits to its usefulness. If you do not know what conditional formatting is, here’s an excerpt from FileMaker Inc.’s website. You can set Conditional Formatting for [...]Related posts:
- Create Good-Looking Progress Bars In Portals –Update: Now the demo file is multi-platform. Hopefully, I am...
- Demo of the FMTouch iPhone App with a FileMaker database agnes-riley-fmtouch-presentation Photo by Sandy Hechtman December 11, 2008: Agnes Riley...
- FileMaker Image Management – Container Field Behavior and Much More One of my clients called this week and told me...
FileMaker Conditional Formatting Examples
Feb 06, 2012
When the conditional formatting feature was announced by FileMaker some of us screamed “yeehaw”. No, really. It was a long-awaited feature and right away we knew there are no limits to its usefulness. If you do not know what conditional formatting is, here’s an excerpt from FileMaker Inc.’s website. You can set Conditional Formatting for [...]Related posts:
- Create Good-Looking Progress Bars In Portals –Update: Now the demo file is multi-platform. Hopefully, I am...
- Demo of the FMTouch iPhone App with a FileMaker database agnes-riley-fmtouch-presentation Photo by Sandy Hechtman December 11, 2008: Agnes Riley...
- FileMaker Image Management – Container Field Behavior and Much More One of my clients called this week and told me...
Pause on Error session with Zulu
Feb 03, 2012
Take a look at Jesse's Pause On Error session showing how to use Zulu to publish calendar and contacts data from Filemaker to iCal / iPhone / Google:
http://vimeo.com/23121319/
Tips & Hints - The Relationship Graph
Jan 30, 2012
In this second article in our series of tips and hints we focus on the relationship graph. Take it as it is - this is just an assortment of our favorite time-savers, shortcuts, tips, hints, tricks, tools of the trade and more…360Works DocuBin version 1.0051
Jan 27, 2012
A new version of DocuBin has been released. This version features:
Version 1.0051 (2012-01-27)
- Fixed an issue to support uploading folders with names that contain non ASCII characters
- Fixed an issue to display the correct template-value field type on the Document Info layout.
- Fixed an issue to display the correct template-value field type during advanced searches.
- Fixed an issue to display the correct parent folder icon and name during advanced searches.
Download the latest version here: http://www.360works.com/docubin
PauseOnError [x] London 2011 – Marvelous Optimisation #4
Jan 27, 2012
Watch HOnza Koudelka’s expert presentation on Marvelous Optimisation #4 at PauseOnError [x] London 2011. In this session you’ll learn how to boost performance for FileMaker solutions. Read all about his Marvelous Optimisation formula here. Further reading.Creating a PDF in Instant Web Publishing using...
Jan 27, 2012
This tutorial video describes an example of using RemoteScripter to create a PDF in Instant Web Publishing. The video can be viewed on YouTube at http://www.youtube.com/watch?v=jiNWKGSvI9o.
The transcript of the video is provided below.
Creating a Fundamental FileMaker Go Layout - Understanding...
Jan 26, 2012
Creating a Fundamental FileMaker Go Layout - Understanding Scroll Lock
This is the first blog post in a series about Creating a Fundamental Layout for use in FileMaker Go. The goal of this series is to offer practical advice and specific instructions for creating FileMaker Go layouts that look and act the way you, and your users, expect.
The first topic we'll cover in the series is 'Understanding Scroll Lock'.
Tips & Hints - Layout Mode
Jan 25, 2012
This is the first in a series of articles that will present some useful and time saving tidbits for various areas in FileMaker. In this first article we focus on layout mode. Take it as it is - this is just an assortment of our favorite time-savers, shortcuts, tips, hints, tricks, tools of the trade and more…Are FileMaker plug-ins dead?
Jan 20, 2012
The release of FileMaker Go has added a new variable to the equation we use when considering whether to use a FileMaker plug-in. We are experiencing a big shift to mobile solutions. Within less than a year ignoring the iOS platform became an unforgivable mistake for every FileMaker developer. When creating a new solution, adding [...]FileMaker Developer Tools: A Love-Hate Relationship
Jan 13, 2012
FileMaker's Developer Tools: A Love-Hate Relationship
FileMaker is a great platform for development and I owe most of my professional success to its success. There are some things about FileMaker Pro that I love and, of course, as with any passionate relationship, there are a few things I would like to see improved. This article will strive to expose my passionate feelings about certain developer features in FileMaker Pro that I both love, and hate, with equal verve.
Scribe 1.262 has been released
Jan 12, 2012
Scribe 1.262 has been released; it fixes a corruption issue on Windows when multiple documents use ScribeDocSubstitute.
Download the latest version here: http://www.360works.com/scribe
FileMaker Technical Network
Jan 11, 2012
The FileMaker Technical Network is for FileMaker developers, designers and users to share their knowledge and skills amongst one another. Joining the FileMaker community not only increases your technical knowledge and development skills but gives you access to a vast array of resources - Download hundreds of scripts, calculations and custom functions Read how-to articles Receive product news and updates Exclusive webinars [...]New Version of ScriptMaster 4.13
Jan 10, 2012
ScriptMaster version 4.13 has been released, includes GetVariable for generated plugins and update to Groovy 1.8.5.
Download the latest version here: http://www.360works.com/scriptmaster
360Works DocuBin 1.0050 released
Jan 10, 2012
A new version of DocuBin (1.0050) has been released. This version fixes an issue when inserting files/folders into a folder path with more than 100 characters. Download the latest version here: http://www.360works.com/docubin
360Works JDBC plugin 1.77
Jan 10, 2012
360Works JDBC plugin version 1.77 has been released. This version includes a fix for SELECT and UPDATE statements with PostgreSQL.
Download the latest version at http://www.360works.com/jdbc-plugin/
Skeleton Key - FileMaker Training: Wherever You Are in 2012
Jan 09, 2012
FileMaker Training: Wherever You Are
 |
| photo by OfficeNow |
Skeleton Key will kick off its 2012 FileMaker online training schedule this week with FileMaker Server 101. Take a look at the line up of trainings available for you to attend from your desk, home office, or anywhere you've got a good internet connection.
Importing Email Into A FileMaker Database
Dec 29, 2011
Email is a hairy subject. Not just because we have POP, IMAP and SMTP servers to deal with, but also ports, authentication, port restrictions by ISPs, syncing problems, etc. I generally tell users to sick to their email programs, if that’s an option. There are certainly some times when it’s worth dealing with it and [...]Related posts:
- Importing RSS Feed Into FileMaker with XSLT Update: Per popular request I am revisiting this article. I...
- Demo of the FMTouch iPhone App with a FileMaker database agnes-riley-fmtouch-presentation Photo by Sandy Hechtman December 11, 2008: Agnes Riley...
- Top 10 Suggestions If You Want To Hack At A Database Yourself – For In-house FileMaker Developers All FileMaker developers start somewhere, and that place is definitely...
New Version of SuperContainer 2.852
Dec 27, 2011
A new version of SuperContainer has been released. If you downloaded SuperContainer 2.851 (released December 22nd), there was a file missing with that version. This is fixed in 2.852, which is available now at http://360works.com/supercontainer
New Version of SuperContainer 2.851
Dec 27, 2011
A new version of SuperContainer has been released. If you downloaded SuperContainer 2.851 (released December 22nd), there was a file missing with that version. This is fixed in 2.852, which is available now at http://360works.com/supercontainer
Skeleton Key - FileMaker Academy Members Create Resources For...
Dec 23, 2011
FileMaker Academy Members Create Resources For You
In early 2011, a group of leading FileMaker development companies – all Platinum–level members of the FileMaker Business Alliance - formed FileMaker Academy. The purpose of FM Academy is to further educate FileMaker users and developers to encourage best practices and foster further adoption of the software.
These companies are based in various regions of the United States. 360 Works, Atlanta; MightyData, Dallas/Austin/Houston; IT Solutions, Philadelphia/New York; Anvil Dataworks, Washington, DC/Baltimore; Fiddlehead Software, Portland, OR; Kyo Logic, Westport, CT; Skeleton Key, St. Louis, MO.
What do all the good Filemaker girls and boys want for...
Dec 23, 2011
Tiz the season to be jolly and all that. So What is on the good Filemaker developers wish list? Layout Includes. The ability to embed one layout within another. I don’t swallow the technically too difficult line because multiple windows works Rename triggers as events and then add ‘proper’ database triggers. Triggers in the classical [...]360Works releases SuperContainer 2.851
Dec 22, 2011
SuperContainer 2.851 has been released.
Included in this update:
- Fixes a bug that displayed incorrect modification dates on the downloaded file when using either the Companion plugin or the applet
- New function SCCopy, which copies files on the server
360Works SuperContainer 2.85 released
Dec 19, 2011
SuperContainer 2.85 has been released.
- Added HTML5 drag and drop for single files on OS X.
- Fixed unnecessary log in prompts when authentication URL parameters are set.
QuickBooks integration now available in FM Work Orders!
Dec 16, 2011
FOR IMMEDIATE RELEASE San Diego, CA – December 16, 2011 – Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce the release of Version 1.1.0.0 of our FM Work Orders solution! FM Work Orders is a cross-platform solution which allows an office dispatcher to send out electronic work order [...]360Works End of Year Sale Ends Today! Last chance to save 15%...
Dec 16, 2011
Year End Sale ends Today, save 15% on all products.
Have you been thinking about how to better manage your documents and images? Wondering what it will take for you to be able to send HTML emails? Looking for ways to integrate FileMaker with other systems?
360Works has a suite of plugins and tools including our popular SuperContainer, Email, Plastic, and award winning DocuBin to help meet your business needs.
Use the code YREND2011 during checkout, to receive 15% off your order
You can order your favorite 360Works products a la carte, or you can order the 360Works Portfolio License, which bundles many of our products at one low price and includes one year of maintenance/upgrades.
| Product | Description |
| DocuBin | Cross platform tool for document and digital asset management |
| Portfolio License | All of the products listed below for one great price |
| SuperContainer | The ultimate document storage tool for FileMaker |
| Plastic | Process credit cards directly from Filemaker |
| Scribe | Read and write PDF, Word, Excel files |
| ScriptMaster Advanced | Generate custom plugins! Perform SQL, read/write clipboard data |
| Send and receive text and HTML emails in FileMaker | |
| FTPeek | FTP upload and download from your FileMaker database |
| Web Services Manager | Publish FileMaker scripts as XML Web Services |
| RemoteScripter | Trigger scripts on FileMaker Pro from the web or IWP |
| WebAssistant | Access internet resources, URLs, and fill out web forms from FileMaker |
| JDBC | SQL access with JDBC Compatibility |
| Charts | Easy-to-use charting for FileMaker |
| Admin Anywhere | Administer FileMaker Server from a browser or smartphone |
Be sure to like us on Facebook for the latest updates, news, and discussions on all things 360Works.
Thank you, and have a great New Year!
—The 360Works Staff
plugins@360works.com
www.360works.com
866-662-9185
360Works End of Year Sale Starts Today
Dec 14, 2011
Year End Sale running December 14th through 16th, save 15% on all products.
Have you been thinking about how to better manage your documents and images? Wondering what it will take for you to be able to send HTML emails? Looking for ways to integrate FileMaker with other systems?
360Works has a suite of plugins and tools including our popular SuperContainer, Email, Plastic, and award winning DocuBin to help meet your business needs.
Use the code YREND2011 during checkout, to receive 15% off your order
You can order your favorite 360Works products a la carte, or you can order the 360Works Portfolio License, which bundles many of our products at one low price and includes one year of maintenance/upgrades.
| Product | Description |
| DocuBin | Cross platform tool for document and digital asset management |
| Portfolio License | All of the products listed below for one great price |
| SuperContainer | The ultimate document storage tool for FileMaker |
| Plastic | Process credit cards directly from Filemaker |
| Scribe | Read and write PDF, Word, Excel files |
| ScriptMaster Advanced | Generate custom plugins! Perform SQL, read/write clipboard data |
| Send and receive text and HTML emails in FileMaker | |
| FTPeek | FTP upload and download from your FileMaker database |
| Web Services Manager | Publish FileMaker scripts as XML Web Services |
| RemoteScripter | Trigger scripts on FileMaker Pro from the web or IWP |
| WebAssistant | Access internet resources, URLs, and fill out web forms from FileMaker |
| JDBC | SQL access with JDBC Compatibility |
| Charts | Easy-to-use charting for FileMaker |
| Admin Anywhere | Administer FileMaker Server from a browser or smartphone |
Be sure to like us on Facebook for the latest updates, news, and discussions on all things 360Works.
Thank you, and have a great New Year!
—The 360Works Staff
plugins@360works.com
www.360works.com
866-662-9185
DocuBin 1.0047 has been released!
Dec 13, 2011
360Works is pleased to announce the release of a new version of DocuBin. It includes many new features including:
- Add a default Template to a folder. Any file added to the folder with get the template set automatically
- Rearranged sidebar with new section 'My Stuff' and new option 'Checked Out' for viewing files checked out by the user.
- Drag file to the 'Checked Out' sidebar option to check out a file.
- Renamed sidebar option 'All' to 'Files'
- Changed icons for opening files and saving files back into DocuBin
- New icon for checked out files
- New tooltip for checked out files
- Fixed icon preview icon for FileMaker Go layouts
- Double-click to open folders
- Fixed an issue when after updating DocuBin to the latest version, DocuBin would not register that it had updated.
- Developer: Checked out status migrated from Document to Content
- Developer: Template information migrated from Document to Content
Download the latest version at http://360works.com/docubin.
360Works AdminAnywhere 1.511
Dec 12, 2011
AdminAnywhere 1.511 (360works.com/adminanywhere) has been released-corrected missing install files for Windows.
Skeleton Key - FileMaker Training or Coaching?
Dec 09, 2011
FileMaker Training or Coaching?
Training or coaching - which is right for you?
The simple answer:
- Training is an overarching effort to teach you how to effectively use the FileMaker toolkit.
- Coaching is a more tactical approach that focuses on learning how to apply the FileMaker toolkit to your specific application.
Here's an analogy that might make the distinction easier to grapple with:
Year End Sale starting December 14th through 16th, save 15% on...
Dec 09, 2011
Year End Sale starting December 14th through 16th, save 15% on all products.
Have you been thinking about how to better manage your documents and images? Wondering what it will take for you to be able to send HTML emails? Looking for ways to integrate FileMaker with other systems?
360Works has a suite of plugins and tools including our popular SuperContainer, Email and Plastic and award winning DocuBin to help meet your business needs. Visit our website to evaluate the products now, before the sale begins.
Look for an email from us on Wednesday, December 14th with the discount code to use for this three-day sale.
You can order your favorite 360Works products a la carte, or you can order the 360Works Portfolio License, which bundles many of our products at one low price and includes one year of maintenance/upgrades.
| Product | Description |
| DocuBin | Cross platform tool for document and digital asset management |
| Portfolio License | All of the products listed below for one great price |
| SuperContainer | The ultimate document storage tool for FileMaker |
| Plastic | Process credit cards directly from Filemaker |
| Scribe | Read and write PDF, Word, Excel files |
| ScriptMaster Advanced | Generate custom plugins! Perform SQL, read/write clipboard data |
| Send and receive text and HTML emails in FileMaker | |
| FTPeek | FTP upload and download from your FileMaker database |
| Web Services Manager | Publish FileMaker scripts as XML Web Services |
| RemoteScripter | Trigger scripts on FileMaker Pro from the web or IWP |
| WebAssistant | Access internet resources, URLs, and fill out web forms from FileMaker |
| JDBC | SQL access with JDBC Compatibility |
| Charts | Easy-to-use charting for FileMaker |
| Admin Anywhere | Administer FileMaker Server from a browser or smartphone |
Be sure to like us on Facebook for the latest updates, news, and discussions on all things 360Works.
Thank you, and have a great New Year!
—The 360Works Staff
plugins@360works.com
www.360works.com
866-662-9185
360Works Scribe 1.26 Released Today
Dec 08, 2011
Scribe 1.26 releases today, includes bug fixes for the flatten flag, addresses formatting issues with .docx/xlsx files, and added the ability to get PDF metadata.
360Works Scribe 1.25 Released Today
Dec 08, 2011
Scribe 1.26 releases today, includes bug fixes for the flatten flag, addresses formatting issues with .docx/xlsx files, and added the ability to get PDF metadata.
360Works Web Services Manager 1.522
Dec 02, 2011
New version of Web Services Manager 1.522 released today, fixes a bug that was preventing operation caching on Windows.
RemoteScripter 1.782 adds new features
Dec 01, 2011
RemoteScripter 1.782 released today; adds new features, including:
- No longer need to detect FMP client in a start up script
- Prioritizing multiple calls to the same port number by recent
- Allows the user to set HTTPcode and Header-Value pairs.
Skeleton Key - Selling FileMaker App Dev Services - Tactical...
Nov 29, 2011
Tactical Steps to Improve Your Sales Funnel
Last week, I wrote about the theory behind these sales tactics. You should review that first if you're interested.
The key is being able to identify an ideal prospect and 'know' who you are communicating with. There's a simple way to determine a qualified lead from an unqualified lead: ask the people involved.
Now let's figure out how to ask.
360Works SuperContainer 2.832 Update
Nov 28, 2011
SuperContainer 2.832 has been released, fixes an issue that made SuperContainer Server crash when uploading a file with a semicolon.
Moving Data Within FileMaker using XML
Nov 21, 2011
This is a concept shown by Fabrice Nordmann at this years Pause on Error London. Having seen how he uses this, I have used it in a couple of solutions and found that it does make moving data around really easy and saves on creating lots of variables, so cuts down development time as well. [...]Skeleton Key - Selling FileMaker App Dev Services - Invest Time...
Nov 21, 2011
Invest Time On Leads That Will Become Sales
I may be crazy for publishing this but we're putting our money where our mouth is. Skeleton Key advocates for transparent business practices. Have a look around our site and you'll see it everywhere. I'm going to pull the curtain back on our sales process. If that makes you uncomfortable, you have all the more reason to keep reading.
Skeleton Key - Angelbeat St. Louis: Apple in the Enterprise
Nov 16, 2011
Skeleton Key - Angelbeat St. Louis : Apple in the Enterprise
Oliver Block, Systems Analyst and VP at Skeleton Key, joined expert speakers from industry giants such as Google, Symantec, VMware, Microsoft and Aruba Networks to speak at the Angelbeat seminar in Clayton, Missouri yesterday.
Oliver's presentation, entitled Apple In The Enterprise, covered best practices for integrating Apple Mac computers into enterprise networks. Oliver also provided tips for deploying and managing Apple mobile devices such as iPads and iPhones.
New Version of Email Plugin 1.962
Nov 16, 2011
360Works releases Email plugin version 1.962 today!
Changes include:
- Users can now set X-Mailer header manually
- Fix for character encoding on messages containing inline attachments
- Fix for retrieving messages via IMAP from Exchange server, which resulted in a blank message body
SuperContainer 2.831 released
Nov 14, 2011
SuperContainer 2.831 has been released. Due to problems with Java Update 6 for Snow Leopard and Java Update 1 for Lion (1.6.0.29), Java applets may crash in FileMaker. This crash occurs once a layout that contains an applet is opened. The latest version of SuperContainer works around these issues by switching to an HTML-only mode when running on Mac OS X, without a Java applet. This disables some functionality, including drag and drop. Bug reports have been filed with Apple, listed below:
- Apple bug report #9843334: 32 bit Java crashes when loading applet if JVM has already been loaded
- Apple bug report #9843400: Drag & drop broken with Java applets in Lion
360Works is currently waiting on a fix from Apple to restore this functionality.
New KeyPupil: Hospital Edition coming soon..
Nov 10, 2011
The product was created with Great Ormond Street Hospital, after many years working closely together to perfect the requirements of a hospital school for both teachers and students.Virtual List
Nov 05, 2011
A lot of folks have been asking for the Virtual List example file we put together with Bruce Robertson, so here it is: VirtualList.zip
This Virtual List technique is part of what make our Calendar fast, and allows FMSearchResults to show records from different tables in the same ‘portal’. We demonstrated some applications of this at DevCon’s Year in Review in 2010 and 2011, showing how this can really speed up FileMaker displays, especially those formatted as columns, grids, or lists.
Todd Geist speaking at SOFA, Nov 2011
Todd Geist has also been speaking about this a lot, including last week in Toronto, where he demonstrated how we’re using it in Worx.
There was a also a great session on Virtual Lists at Pause[x]London. Sample files and recorded presentations here.
Are you using Virtual Lists?
Calendar as Dashboard
Nov 04, 2011
We have a small subset of customers who wire their calendars up to act as dashboards on big displays. I’ve always thought this was cool and someday hope to get around to making one for SeedCode, a la the great dashboard at Panic.
One of these customers asked for something pretty cool today: they wanted to be able to cycle through the different resources on the calendar (recording studios in her system), showing each one on the week view for a few seconds, before moving to the next studio automatically.
Easy with a couple simple scripts and an OnTimer trigger. Feel free to add these to your own version of the calendar: AutomatedDisplayScripts.pdf
Phidgets Pt 1 The Hardware
Nov 01, 2011
We are just about to start a project to allow employees to log in and out of a FileMaker system using RFID tags. In the past we have done this by hanging a Phidget RFID reader directly off the back of a computer. In the past we have always had a computer available for the [...]Skeleton Key - FileMaker Number Functions Video Series
Oct 28, 2011
FileMaker Number Functions Video Series
Last week we featured a series of five (5) videos from our Certified FileMaker Developer, Chad Adams, on our Facebook and Twitter social media profiles. He created these videos to both compliment a series of Text Function videos he did earlier this year, and to offer as a supplemental resource for other developers and/or novice FileMaker users.
Chad chose to cover these particular Number Functions because they are ones that he uses most often, and they represent a set that is fairly easy to explain and understand.
What’s next? Chad will present a series of Date Functions in the near future.
Please subscribe to our YouTube Channel, or connect with us on Facebook, Twitter and LinkedIn to be the first to check out our other FileMaker and IT content.
FM Books Connector is Now QuickBooks 2012 Compatible!
Oct 28, 2011
San Diego, CA – October 28, 2011 – Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce the compatibility of our FM Books Connector version 4 with QuickBooks 2012 US, Canadian, UK and Australian editions! The FM Books Connector is a FileMaker Pro plug-in that is a bidirectional data [...]Email Management: Filing (part 2)
Oct 26, 2011
This is part 2 of a 2-part series. You can find part 1 here. In part 1, we discussed how managing your emails was like keeping the sink clear. In the meantime, I referred to “filing” emails for future reference. There is no right/wrong way to file emails. It all depends on your personal preferences [...]A Different Perspective On Recently Released FileMaker, Inc....
Oct 26, 2011
A Different Perspective On Recently Released
FileMaker, Inc. How To Paper
Regarding External Authentication Configuration
By
Wim Decorte
and
Steven H. Blackwell
I am pleased to have as co-author of this BLOG posting the...
Support Diaries
Oct 26, 2011
Sometimes the hard stuff turns out to be really easy.
It always impresses me that Jason has a way of finding the simplest ways of doing things. For example, when iCal treats a holiday as an all day event, SeedCode can pick that up as a two-day event. A customer asked about how to work around this, changing the iCal parser in SeedCode Calendar Pro.
Jason sent them this screen shot showing how you can more easily teach SeedCode to ignore the end date of the holiday calendar, after the iCal event is parsed. Love it.
Our customer loved it too and posted this on our support forum:
As a new user of Calendar Pro I am very impressed with the simplicity and power of the solution template. I’ve been using & developing in FMP for over a decade; I can’t believe how simple the relationship-table is for Calendar Pro. It’s an example I hope to follow more often in my other Filemaker work.
That’s what it’s all about.
Free Webinar: 5 Important Techniques for Building a Solution in...
Oct 25, 2011
Join FMAcademy and MightyData for a free webinar on November 10 at 12:00pm EST! With FileMaker Go, developers can use the power of FileMaker Pro with the flexibility of a mobile device. But with a new platform comes new methods, techniques and expectations. Leveraging the power of FileMaker Go is not just about understanding core [...]Inside A Developer’s Head -Brainstorming Your Way To The...
Oct 24, 2011
This is part 2 of a two-part series. In Part 1, I explained how I started exploring different options to meet a customer request for a specific report (not a standard subsummary report) with acceptable performance (not a resource hog or more than a minute to display). Combine the Knowns to Solve the Unknown By [...]Reading Mac Hard Drives From Windows
Oct 24, 2011
Question: I’m using Windows and I have a hard drive I got from a Mac OS user but I can’t access any of the files? Is there a way I can see this? Answer: The Mac has no problems reading PC/Windows formatted drives…but Windows will not read Mac formatted drives without additional software. The disk [...]Skeleton Key - West Coast FMPug Tour Guest Speaker Jason Thomas...
Oct 24, 2011
West Coast FMPug Tour Guest Speaker Jason Thomas on Sales
This week, the Skeleton Key office will sacrifice the physical presence of our beloved head of sales – Jason Thomas – as he travels to the West Coast to speak to enthusiastic FileMaker User Groups in Seattle, WA, Portland, OR and Santa Clara, CA.
Jason’s topic is Sales. His goal is to expand awareness of the need for a sales process while leveraging the expertise that already resides within both the in-house developer and consultant communities. He hopes to provide new knowledge, and improve attendees methods for identifying specific tactics and actions that will bring the sales process under control and make selling more predictable.
PauseOnError [x] London 2011
Oct 23, 2011
Pause on Error was a huge successes with some fantastic sessions and a really great atmosphere. Thanks to everyone involved from the Sponsors to the Speaker and Delegates. Hope to see you all at the next one.NJ FileMaker Developer Group Meeting Recap SoSIMPLE Calendar...
Oct 23, 2011
The September meeting was interesting from several prospectives. We had our core group of people, of which I’m still the youngest, probably by age, as well as time spent in the community. I brought to the meeting a box of Dunkin’ Donuts munchkins, for no particular reason. I also learned that Ginger Bread is out [...]FileMaker Feud 2011, Round 3
Oct 21, 2011
It is time for the final round of FileMaker Feud. In this last video (see Round 1 and Round 2), Laura Betz and Lee Lukehart, assisted by our MightyData coaches, go head-to-head to see who is the FileMaker Feud Champion. We had a great time hosting the event and appreciate all the positive feedback we [...]Further explorations in SQL for FileMaker
Oct 21, 2011
Once you start down the path exploring new features or technologies, often the deeper you dig the more cool stuff you expose. In my first post on SQL and FileMaker I focused simply on pulling and comparing data between tables. There are several advantages to employing SQL in FileMaker: speed and context perhaps the primary [...]Summary Report in a Filtered Portal
Oct 18, 2011
Have you ever wished there were an easy way to summarize the contents of one portal in another portal? Perhaps something along the lines of the “Summary” portal below? I’ve touched on the possibility of using a portal to produce … Continue readingWhat’s next for GoZync: Worx
Oct 17, 2011
This weekend, Todd Geist and I took the train up from LA for a 33 hour code sprint and built the start of Worx, the next file for GoZync.
This is a great way to work and we got a ton done.
Todd on the Coast Starlight
Worx is a work orders system for iPad: users in the office assign orders to technicians and those techs “zync” the orders down to their iPads before completing the orders. Orders come down with contact info, maps, and a serious items database capable of browsing and selecting from tens of thousands of items.
Here are some screen shots from the iPad side…
Contact management & maps in Worx on iPad
Item selector in Worx: please forgive the testing data
Selecting items: grid view
…and a short video of the office side showing the virtual list Todd created for our side bar. Nice stuff.
Worx will be available as a ready-to-go solution for GoZync that you can tie to your own hosted file or use on its own. More soon.
Taming the Virtual List, Part II
Oct 16, 2011
Part I provided a broad outline of the Virtual List Technique. Part II will step through a specific example of how this technique solved a MightyData customer’s request. Requirements This customer needed a sales order and invoice tracking system, and provided a sample of the current sales order in Excel. I mimicked this layout in [...]Skeleton Key - The Positive Effect
Oct 15, 2011
Skeleton Key - The Positive Effect
Marketing – be it 'traditional', word-of-mouth, grassroots or social media based, is not new for me.
Marketing for Skeleton Key, a service-driven, Custom Application Development/Information Technology Consulting company is relatively new for me.
My adventure began in mid-January...
In order to promote and solidify the Skeleton Key (SK) brand to the widest-reaching audience and business consumers of FileMaker software, I had to learn to understand what made SK 'tick'.
Jason Thomas, Business Development, using 'windows' 
Inside A Developer’s Head: Brainstorming Your Way To The...
Oct 14, 2011
This is part 1 of a two-part series. The assignment was simple: A report is not sorting correctly. Fix it. Easy, right? Little did I know that by taking this assignment I was about to pull out the pebble that would open up the dam. A deluge of trial and error later, the report was [...]FileMaker Feud 2011, Round 2 Questions
Oct 10, 2011
Here are the questions and answers from the 2nd round of FileMaker Feud at FileMaker DevCon 2011. This round was tougher because the teams were cut in half–fewer people to help guess the answers. Watch the video of Round 2 to see who makes it to the finals. 6. Name the most powerful native calculation function in [...]Make a Smart White Board for Less Than $99
Oct 09, 2011
The White Board… You can build a non-magnetic whiteboard out of a product called melamine that is commonly used for creating shower walls. Whiteboard specific melamine is more expensive but the only difference is the thickness of the board. This is great for a training room, home school, etc. What you need: A big wall [...]A Simple Backup Script
Oct 08, 2011
Broadly speaking, FileMaker developers fall into three categories: a) those who do all their development on local files; b) those who do all their development on hosted files; and c) those who sometimes develop locally, and sometimes in a hosted … Continue readingiPad – Revolutionizing the Way We Do Business
Oct 07, 2011
I am a Windows guy at heart and don’t care much for the zealotry surrounding Apple products; however, I can’t begin to tell you how much I love my iPad. Aside from all the personal entertainment value it brings; games, music, photos, video, books, it has brought an equal amount of value to my business. [...]FileMaker Feud 2011, Round 1 Questions
Oct 07, 2011
By popular request, here are the questions and answers from the 1st round of FileMaker Feud at FileMaker DevCon 2011. Watch the video of Round 1 to see who advances to the next level. 1. Name a reason to choose FileMaker Pro over another development environment. Rapid Development – 44 Ease of Use – 19 [...]The Legacy of Steve Jobs
Oct 07, 2011
On October 6, 2011 Heidi Collins of FOX 9 News KMSP in the Twin Cities Minneapolis, St. Paul MN interviewed Chief Technology Officer and Apple expert Tim Cimbura regarding the legacy left by Steve Jobs. (See video below.) Following is not a word-for-word transcription of the interview but the outline and responses prepared for the [...]Taming the Virtual List, Part I
Oct 07, 2011
Have you ever wanted to create a report in FileMaker, but found it just doesn’t work that way? Perhaps you need to combine disparate data from several tables. Or export data where several records are combined into a single row. Or show totals both “across” and “down”, with a pivot table. Or format an invoice [...]Thank you Steve Jobs
CSS Shaders
Oct 06, 2011
I think of all the things I love about being a web developer – its the constant development and evolution of the technologies available to me as a developer. Just this week we have the following (proposal only at the moment) from Adobe – CSS Shaders. Will this help me to streamline my clients interface? [...]In Memory of Steve Jobs
Oct 05, 2011
From the age of 11 back in 1980, when I got my hands on my first computer, I was kind of obsessed by them. Through school, all the way to college, my fate was sealed to be a true computer geek. It was then in ’86 that I came across my first Apple, my very [...]Back from the West Coast Tour with Sample Files
Oct 05, 2011
Last week, I had an amazing time traveling down the West Coast, speaking to enthusiastic and excited user groups in Seattle, Portland, San Francisco, Santa Clara, and Las Vegas. Topics included Snapshot Link, Quick Find, Filtered Portals, Script Triggers, and Charting. I also had the opportunity to discuss two great things MightyData is offering: MightyCoach [...]The New iPhone 4S
Oct 05, 2011
For those of you that travel extensively…and overseas…the new iPhone 4S is definitely worth looking at. It includes CDMA and GSM chips in it so it can talk on nearly any mobile phone tech system…and across Verizon, AT&T, and Sprint. In addition, the new Seri intelligent assistant will be great for those of us who [...]Mac OS X Lion & FileMaker Server 11
Oct 05, 2011
In a previous article, I discussed the compatibility of FileMaker 11 and Mac OS X Lion (10.7). When Lion was released in July, FileMaker Pro and FileMaker Server were not compatible. In August, FileMaker Inc. (FMI) released the FileMaker Pro 11.0v4 update. The update modifies the existing installation of FileMaker Pro (or FileMaker Pro Advanced) [...]Integrating Kiosk Mode into your Solution
Oct 04, 2011
Kiosk mode is a cool way to run a FileMaker database in a full screen environment where users are prevented from accessing the other functionality of the operating system. But what if you have a normal FileMaker solution and wish to use kiosk functionality in certain areas only?In this article we illustrate how a typical FileMaker solution can be enhanced with a kiosk component for carrying out certain actions. We use the article example file to help illustrate this. We also give some information on what kiosk mode is, and things to watch out for when developing for it.
FileMaker Server: Disabling Java Updates
Oct 04, 2011
A common question on the TechTalk mailing list or on FMForums is Why has the FileMaker Server Admin Console stopped working? Usually, this is because a recent Java update has been installed on the computer running the Admin Console. The fix typically involves either rolling back to an earlier version of Java (not always possible) [...]Converting Entourage Contacts to Bento or FileMaker
Oct 02, 2011
We recently received the following question: “Can I export my entourage contacts, calendar, and notes into Bento?” Answer: Entourage is the old contact and calendar application that shipped with versions of Microsoft Office for the Mac prior to version 2011 where they now include a Mac version of Microsoft Outlook. Since Entourage is no longer [...]Easy Sorting of List Views, part 3
Oct 01, 2011
Ever since I posted part 2 of this series, I’ve been torn between, on the one hand, wanting to move on to other topics; and on the other, the realization that I wasn’t quite done with this one yet. So, … Continue readingSkeleton Key - FileMaker - How To Article Published for TechNet...
Sep 30, 2011
How To Article Featured in October Newsletter for FileMaker TechNet
Mark Richman, President of Skeleton Key, was both flattered and happy to contribute his FileMaker “How To” article, Replicating an External Authentication Environment for Development, in the October, 2011 issue of the FileMaker Technical Network e-Newsletter that circulated today.
PCI Launches YourAppService.com for Affordable iPad Application...
Sep 30, 2011
FOR IMMEDIATE RELEASE: San Diego, CA - September, 30 2011 – Productive Computing, Inc. a Platinum member of the FileMaker Business Alliance, announces the launch of a new web site and service offering called YourAppService.com. This service utilizes FileMaker Pro as a rapid application development tool to create custom applications that you can run on [...]FileMaker, Inc. has released FileMaker Server 11.0v4 for Mac OS...
Sep 29, 2011
FileMaker, Inc. has released FileMaker Server 11.0v4 for Mac OS X versions 10.5, 10.6, and 10.7. This update addresses the following issues: Installer • The fmserver user is no longer displayed as a user in the Mac OS X Lion login window. Database Server • Fixed an issue where a scheduled script using the Get(FileMakerPath) [...]Exporting Contact Information From Mac OS X Address Book or...
Sep 29, 2011
Once you have entered information into the Mac OS X Address Book, there is not a straightforward and easy way to get it out. There are two built-in Export options: “Export as vCard” or “Address Book Archive”. Neither is terribly useful or easy to access like an Excel file. vCards can be read by some [...]Email Management: Keeping the Sink Clear
Sep 28, 2011
In my past blogs, I’ve discussed how to make things happen with goal setting, to-do lists and prioritization. But, how does the crazy amount of email that we receive daily fit into that? Many people receive over 200 emails per day. Here are some tips to help you stay on top of it. And watch [...]Pause on Error is coming to London!
Sep 28, 2011
London will be playing host to it’s own PauseOnError on October 20-21 at the Park Plaza Sherlock Holmes Hotel in Baker Street. It’s going to be the same format as the previous Pause events in New York and Portland, but with a few minor differences. Primarily, this boils down to using conference rooms instead of [...]360Works releases new version of Scribe 1.25
Sep 27, 2011
Scribe 1.25 (http://360works.com/scribe) released today; fixes potential bugs with highlighting and when saving a modified PDF file.
Hire Excelisys…
Sep 27, 2011
Hire Excelisys… and you get a team Of experts, neat and clean; Of gurus, young and old Innovative and bold. We reside Outside the box not inside; Adept in every field, Technology we wield As a tool Using what is right and cool And before you ask, With every task We give it serious thought [...]FileMaker Music Survey
Sep 27, 2011
Within the FileMaker community, there seem to be several subcultures. Music, photography, woodworking, and knitting just to name a few. At DevCon, we used to have a jam session that was generally packed with too many people wanting to play and sing. We had to impose limits such as only play for 3 songs, and [...]Build a Utility Shelf for Your Mac Mini, Time Capsule, or...
Sep 26, 2011
Our home wiring panel was getting overrun with equipment with no place to put them and limited space to actually mount a shelf. First, there were 2 boxes from Comcast for our phone system and internet connection. Then I added two Apple Time Capsules to create our wireless network with a total of 4 TB [...]FileMaker Feud 2011, Round 2
Sep 26, 2011
This is the second video from the first annual FileMaker Feud at the 2011 FileMaker Developer Conference. (Here is Part 1). In this video, Laura Betz and Lee Lukehart take on Perren Smith and Mark Richman to determine who advances to the final round. The crowd was warmed up so there is plenty of friendly banter [...]PCI Announces New Features and Enhancements to Core3 CRM for...
Sep 23, 2011
PCI Announces New Features and Enhancements to Core3 CRM for FileMaker Pro FOR IMMEDIATE RELEASE San Diego, CA – September 23, 2011 – Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, today announced the release of a new Core3 CRM version 3.1.0.2. This new version has been greatly enhanced with the following [...]FMPug Awards
We have been the recipients of some of the most honored awards in our industry. Details of these awards are listed below. We have to thank our members for allowing us to serve them to the best of our ability. We promise to continually push the boundaries of what we do for the benefit of each and every FMPug member world-wide.
2008
DevCon Commemorative Afghan
Each year the DevCon Commemorative Afghan is awarded to a member of the FileMaker community in recognition for their contribution to developers and users alike. This year Andy Gaunt, founder of FMPug was selected for contributions to the FileMaker community world-wide.
2007
FileMaker Excellence Award
Andy Gaunt was honored for his continued efforts to evangelize the FileMaker platform through innovative ways with his network of FileMaker user group.
2006
FileMaker Excellence Award
For Outstanding Contribution to the FileMaker User Group and Developer Community
Andy Gaunt is the founder of FMPug - Uniting FileMaker Pro Users & Groups around the world. With numerous chapters and still growing, Andy has created a more “connective” philosophy, merging pre-existing user groups with newly formed locales and assembling them under a single umbrella. By creating this syndicate and managing it centrally, each group is now inter-connected through FMPug, allowing each user group to have expanded resources within their reach. Anyone who knows Andy will tell you that “Andy works tirelessly to spread the word about worthwhile FileMaker resources, products and training. His FMPug site has aggregated listings of FileMaker products and training courses that alongside his published technical articles and product reviews are part of a resource library that's becoming more and more important to FileMaker Pro users and developers."
In addition to running one of the liveliest FileMaker Pro User Groups, he's showing other user group coordinators how to do the same all over the world. Constantly evangelizing anything positive happening in the FileMaker universe, Andy personifies "outstanding contribution to the FileMaker community". “I have personally not experienced anyone with such selfless enthusiasm for the FileMaker community. He has successfully taken a fantastic idea and from that has significantly built a stable and open community in the past year alone. In addition, his efforts are forward thinking and utilize and challenge all of the latest FileMaker Web technologies. I consider Andy to be a leader in building and strengthening the FileMaker community". On a side note, Andy is using the latest technologies and techniques to make the FMpug website truly a calling card for what and how FileMaker can be used in a real web environment.
2005
Mad Dog Public Relations Award
We are proud to announce that the recipient of one of this years 2005 Mad Dog Public Relations Award is Andy Gaunt, founder of FMPug. This award was for all the work done with and through FMPug in promoting FileMaker.
"Thanks to all those who nominated me for this award. Your nominations will lead me to do more for FMPug in the coming year"
