http://fmcollective.com A gathering of FileMaker developers and thinkers Tue, 29 Jul 2008 20:12:49 +0000 http://backend.userland.com/rss092 en In the FileMaker Pro developer community there is a general lack of clear understanding about the need for the correct type of security in FileMaker Pro solutions. There is too much focus on passwords and not enough focus on the protection of assets and the mitigation of adverse impacts ... http://fmcollective.com/2008/06/25/assets-vulnerabilities-threats-and-risks-what-type-security-is-right-for-you/ Alright, so nobody solved this brain teaser. I'm sure this had nothing to do with people having clients and lives, and everything to do with the original post getting hosed and the challenge being too darn hard anyway :) So here, at long last, is the solution: mebeliLet ( [ NewSubSummary =( ... http://fmcollective.com/2008/04/17/brain-teaser-solution/ I was working on a crosstab report to show grade distributions and I wanted alternating highlights. I was using Mikhai Edoshin's snazzy technique (http://edoshin.skeletonkey.com/2006/12/crosstab_report.html), which meant that each row was a subsummary part, which, at least in my copy of FileMaker, doesn't support alternating fill. Like an idiot, I ... http://fmcollective.com/2008/01/29/brain-teaser/ In my first post on this topic, I showed you how to create a simple, API-driven Google Map directly within your FileMaker Pro database. Today, I’ll be taking that one step further. In the previous example, you were limited to mapping one address at a time. In ... http://fmcollective.com/2007/09/05/google-mapping-part-deux-multiple-addresses/ Among my longest-standing feature requests for FileMaker are portal rows that slide individually to accommodate their content. Although I can usually get by with constructing my layouts in the related table, that's an approach that usually leaves something to be desired. My favorite workaround, to date, has been what I call a "pseudoportal" (though ... http://fmcollective.com/2007/08/29/pseudoportals-with-alternating-fill/ Having skipped DevCon in order to afford an iPhone, I've been dealing with my DevCon envy by exploring some of the wonderful sample files that people have been putting together for FM9. The fuss over Andy's conditional formatting tricks, for example, is certainly well-deserved (though let's face it, we all would have ... http://fmcollective.com/2007/08/22/tip-of-the-hat/ Conditional Formatting is currently my favorite FileMaker 9 feature. It used to be that we had to add all these extra barnacles to our database in the form of fields, calculations or relationships to highlight a simple portal row. Conditional Formatting goes a long way towards eliminating all that ... http://fmcollective.com/2007/08/17/conditional-formatting-tips/ It is my great pleasure to welcome Ray Cologon, Molly Connolly, Don Levan and Barbara Levine as the newest contributing authors to fmCollective. Ray, Molly, Don and Barbara are among the most respected developers, consultants, entrepreneurs and business people in the FileMaker community. Their addition to fmCollective will added valuable ... http://fmcollective.com/2007/08/13/fmcollective-welcomes-ray-cologan-molly-connolly-and-don-levan-and-barbara-levine/ The 12th FileMaker Developer Conference concluded the other day. It was held in Orlando, Florida, again this year at the same venue as last year. Just as was the case last year, I learned quite a few things at this DEVCON, and I thought I’d share some of them, ... http://fmcollective.com/2007/08/12/what-i-learned-at-devcon-chapter-2-2007/ 5:30-ish PM...the room is packed and people settle in. Ryan Rosenberg MCs the session. On the stage sits Chris Crim (CC), Jon Tatcher (JT), Clay Makel (CM), Eric Jacobsen (EJ). Q & A session follows. Most of these questions were submitted ahead of time and preselected by the panel and ... http://fmcollective.com/2007/08/09/devcon-2007-closing-session/