By Jerry Salem
FileMaker 13 is finally here. It was worth the wait. Arguably one of the most exciting features in this release is the ability to hide objects based on a calculation. In the past we have been able to hide objects using a number of tricks. For example, using a broken portal to hide a button or using conditional formatting to insert hidden text. Now, just like a magician you can wave your wand and make an object disappear! In this post we will look at when and when not to use this new ‘hidden’ attribute.
Continue reading ‘Show and Hide Objects in FileMaker 13′
Our next meeting is December 12th from 6-8 PM at the Apple Store on Walnut Street in downtown Philadelphia!
Ronnie Rios from FileMaker Inc. will be presenting on the new features in FileMaker 13!
FileMaker 13 was released today – it is a very big release with significant platform changes and a serious focus on mobile and web delivery.
We’ll have Ronnie Rios with us again to give us an overview on FileMaker WebDirect, iOS keyboard enhancements, Popovers and Slide Controls, Custom Themes, Object Control Visibility, 256 bit EAS encryption, and more!
Catered food will be provided for this presentation, so please RSVP so we can get an accurate headcount.
This is also our 100th Philadelphia FileMaker User Group meeting! And our Year End Bonanza!
You DON’T want to miss this. RSVP HERE.
This is more of a placeholder for you over-planners:
Our next meeting is December 12th from 6-8 PM.
It may or may not be at our office, we’re still sussing that out.
The meeting will be held at the Apple Store on Walnut Street in downtown Philadelphia.
We’ll have more details about presentations as we approach December. FileMake
This will be our 9th annual party, where we perform feats of strength, air our grievances, and eat non-pizza-like food.
It will ALSO be our 100th meeting! That’s a heck of a lot of meetings.
And here they all are – what we know about them, anyway:
5/27/2004 1st Meeting: FileMaker 7 Review
6/24/2004 FileMaker 7 Basics, Script Parameters
7/22/2004 FileMaker 7 review/tips/tricks Continue reading ‘Please Join Us December 12: 9th Annual Year End Bonanza AND our 100th meeting!’
When you’re building a robust FileMaker solution, you might find yourself in a situation where you want to control additions to a portal row via a scripted process rather than by using the “Allow creation of records in this table via this relationship” option on your TOG. The problem with this is that when you return to the original layout, your user might not be able to immediately tell which record was added.
So let’s take a page from some of the slicker web interfaces and highlight a new row when it’s created.
Here’s a Job screen with a simple Task list via portal row.
As you can see, there’s already an “empty” field behind the data fields being used to highlight rows–if the task is completed, then the row is gray. If the task is started, the row is light blue. Otherwise, there aren’t any field shenanigans going on here, the interface is based on a simple three-table structure. Job, Tasks, and a join table (JobTask). The portal will always be sorted by the “Rank” field which is looked up (but editable). Continue reading ‘Auto-highlight a new portal row using conditional formatting and an onTimer script’
(editor’s note: we considered holding this post off until Spring 2014, but figure it’s now late spring somewhere. – Colin)
Jerry Salem, IT Solutions Consulting.
Spring is when a man’s fancy turns to…Cleanup.
At least once a year, I like to run a Database Design Report on each database I am working on and look for Scripts, Layouts, and Fields that aren’t being used. This step by step guide was presented at the Philly FileMaker Users Group meeting in April 2013. Continue reading ‘Spring Cleaning’
Last Thursday Ronnie Rios (Systems Engineer at FileMaker Inc) came by and presented at the Philly FileMaker User Group. The topic was charting, and Ronnie did a great job of laying out the options from a developer and end user perspective.
As promised, he passed on sample files to us, which we’re including here!
Ronnie also forwarded a link to the TechNet paper that goes into charting in some detail. You’ll need to join TechNet to download it (not a TechNet member? It’s free).
The TechNet paper is here.
Greetings FileMaker Enthusiasts,
Our next Philadelphia FileMaker Developer Group meeting has been scheduled for Thursday evening, October 24th, 2012 at 6:00 PM. The meeting will be held at the IT Solutions Fort Washington Office.
414 Commerce Dr., Suite 150, Fort Washington, PA 19034
Google Map: http://tinyurl.com/37mhhh
Please RSVP here if you are planning to attend this meeting:
With the release of FileMaker 11, we found ourselves able to create eye-catching reports and presentations using FileMaker Charts.
FileMaker 12 added enhancements that allow us to more easily visualize, interpret and share our data. We’re pleased to have Ronnie Rios from FileMaker Inc. come and discuss these improvements!
Please join us for
Adding Charts to Your FileMaker Solution
Ronnie Rios from FileMaker Inc. shares some tips, tricks and examples for implementing the Charting Tool in FileMaker 12 and adding charts to existing or new FileMaker solutions.
Pizza will be provided after the main presentation.
Continue reading ‘Please join us October 24 – Ronnie Rios: Adding Charts to Your FileMaker Solution’
Some random snippets:
We’re using Meetup now
Meetup page is here. A bunch of reasons why, but basically the environment’s a bit more collaborative for things like RSVPs, user profiles and so on.
Next meeting is September 26th
Topic’s still TBD, but you can RSVP here! Usual time of 6-8 PM; a formal announcement will come out via regular email channels in a week or so.
FTS Training October 2-4: Developer Essentials
Seats are still available for ITS’s FTS upcoming FileMaker Training Series offering – details are here.
Experience and Style Conference AND FM Product Conference October 21-22
So this double header conference is happening in Chicago in late October. Colin Keefe from ITS and PFUG will be presenting at the Experience and Style Conference on the topic of Applied Color Theory. In general this is a pretty great opportunity to pick up new skills for design or business, and the conferences are cross-pollinating – they’re happening in the same hotel, and you can cross over to the other conference’s sessions (space permitting).
Experience And Style Conference
FM Product Conference
We’ll come back and present findings from the conference at the November PFUG meeting.
That’s it for now. Happy FileMaking!
REGISTER FOR THIS TRAINING
Wednesday October 2 – Friday October 4, 2013
9:00am – 4:30pm
IT Solutions offers a three-day FileMaker Training Series course for intermediate FileMaker developers who are ready to take their solutions to the next level. We have chosen a number of great lessons from the FileMaker Training Series 4 curriculum (the official training curriculum from FileMaker, Inc.) that are appropriate for developers who already have some experience but need to dig deeper into what FileMaker Pro has to offer.
We will examine all of the different kinds of fields and field options available. We will create calculation fields and use the calculation engine in other parts of the database throughout the course. We will cover all aspects of layout design and explore the many tools that FileMaker makes available for you to design a rich user interface, such as themes, guides, conditional formatting, tooltips and tab controls. We will spend time exploring new changes in the FileMaker 12 design surface.
You will be introduced to scripts and you will create summary reports that will help convert your raw data into meaningful information. We will also discuss how relational databases work, how to plan a relational database and how to translate your planning into a FileMaker solution. This class is perfect for users who need to start adding features to an existing system or developers who are relatively new to FileMaker Pro. You should already have some exposure to FileMaker, but extensive development experience is not required.
$1485 per student. Email email@example.com or call (215) 886-9338 for more information.
** 20% discount per student if you register before September 1, 2013 – that is a $300 savings!