en-us Copyright 2009 Advisor Media, Inc. All Rights Reserved. rss@advisormedia.biz (Advisor RSS Editor) rss@advisormedia.biz (Advisor RSS Tech) http://FileMaker.Advisor.com The Advisor Guide to FileMaker Pro database software for advanced users and solution developers, covering FileMaker Pro, FileMaker Advanced, FileMaker Server, FileMaker Mobile, and more, for Windows and MacOS. Fri, 15 May 2009 00:00:00 GMT 60 http://blogs.law.harvard.edu/tech/rss FileMaker Development http://img.advisor.com/wimage.nsf/vCatID/logo.mfflogo10/$file/mfflogo10.gif 100 33 http://FileMaker.Advisor.com http://my.advisor.com/doc/19598Master the use of portals in your databases.Mon, 29 Jun 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19598 http://my.advisor.com/doc/19627Here's how to compute sales commission when salespeople earn a higher percentage on bigger sales.Mon, 29 Jun 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19627 http://my.advisor.com/doc/19619Making changes to the data model of an existing application can be tricky, which is why it's important to think things through before you build your system. But, from time to time, business rules change and so must data models.Mon, 08 Jun 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19619 http://my.advisor.com/doc/19596Use script triggers to build a testing toolkit to make QA easier.Mon, 01 Jun 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19596 http://my.advisor.com/doc/19615Out of the box, the only visual cue FileMaker Pro gives users to indicate the current record is a three-pixel black line. Here's how to improve on that.Mon, 01 Jun 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19615 http://my.advisor.com/doc/19602Create ad-hoc lists from FileMaker Pro variables.Mon, 25 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19602 http://my.advisor.com/doc/19614Make it easy on users when they try to start typing before selecting a field.Mon, 25 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19614 http://my.advisor.com/doc/19586Save time, save money, and avoid embarrassing errors by deleting duplicate records.Mon, 18 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19586 http://my.advisor.com/doc/19617Here's how use the Web Viewer to move a progress bar.Mon, 18 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19617 http://my.advisor.com/doc/19616Let users save or cancel a record -- without requiring a gloal field for every field the user will enter and a script to set the global field to the regular fields.Mon, 11 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19616 http://my.advisor.com/doc/19618Put data at your users’ fingertips.Mon, 11 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19618 http://my.advisor.com/doc/19603This tool lets you quickly upload, view, and download files to and from any FileMaker Pro database.Mon, 04 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19603 http://my.advisor.com/doc/19613Knowing when scripts fire can make a gigantic difference in how your application behaves.Mon, 04 May 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19613 http://my.advisor.com/doc/19582Use script trigers to help users navigate your application.Thu, 23 Apr 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19582 http://my.advisor.com/doc/19593When using ESS to push data from FileMaker Pro to a MySQL database, number values will push for some records, but not others. Here's the solution.Thu, 23 Apr 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19593 http://my.advisor.com/doc/19594Once you start down a particular path toward solving a problem, you can lose site of other possible paths.Thu, 23 Apr 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19594 http://my.advisor.com/doc/19579If you’ve ever wanted to learn PHP to publish your FileMaker Pro data to the Web, but were intimidated by the PHP learning curve, fear no more. Here’s how to get started.Tue, 21 Apr 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19579 http://my.advisor.com/doc/19585Field validation has been available in FileMaker Pro for a long time, but you've had very little control over the message and the buttons in the validation dialog. Script triggers change all that.Tue, 21 Apr 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19585 http://my.advisor.com/doc/19575See how FileMaker Pro's organizational and reporting features help fight crime.Mon, 30 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19575 http://my.advisor.com/doc/19584Users accostomed to working with spreadsheets often forget to hit the Tab key and instead type the Return key to go to the next field. Here's how to prevent the mess this creates.Mon, 30 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19584 http://my.advisor.com/doc/19605The first thing you notice in FileMaker Pro’s new version is the updated and customizable status bar, but there are also a host of new and improved features that benefit users and developers alike.Mon, 30 Mar 2009 00:00:00 GMTFileMakerBasics.Advisor.comhttp://my.advisor.com/doc/19605 http://my.advisor.com/doc/19606Kick your databases up a notch with the most powerful new feature in FileMaker Pro 10.Mon, 30 Mar 2009 00:00:00 GMTFileMakerBasics.Advisor.comhttp://my.advisor.com/doc/19606 http://my.advisor.com/doc/19608You Can Get There from HereMon, 30 Mar 2009 00:00:00 GMTFileMakerBasics.Advisor.comhttp://my.advisor.com/doc/19608 http://my.advisor.com/doc/19580FileMaker Pro 10 puts finds at your fingertips.Mon, 23 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19580 http://my.advisor.com/doc/19583We've always been able to filter a portal, but FileMaker Pro 10 makes it easy to filter a standard List View. Here's how to do it.Mon, 23 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19583 http://my.advisor.com/doc/19576Navigation that gets out of your way.Mon, 16 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19576 http://my.advisor.com/doc/19597Create your own audit trail.Mon, 16 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19597 http://my.advisor.com/doc/19577Web services have moved beyond the trend stage and are now part of most organizations’ long-term IT strategy. Here’s how to get started.Mon, 09 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19577 http://my.advisor.com/doc/19466Learn how and when to use the Set Error Capture script step, and how to script comprehensive error testing and handling.Fri, 06 Mar 2009 00:00:00 GMTAdvisor Basics of FileMaker Prohttp://my.advisor.com/doc/19466 http://my.advisor.com/doc/19578Take a tour of this new release, which offers cool, useful new features for the user, developer, and database administrator.Mon, 02 Mar 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19578 http://my.advisor.com/doc/19549Harness PHP and PDF for slick-looking Web reorts.Thu, 29 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19549 http://my.advisor.com/doc/19570Don’t reinvent the wheel. Here’s how to create a single layout for all your reports.Thu, 29 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19570 http://my.advisor.com/doc/19550If you need to present chronological information so it’s understandable at a glance, timelines are better than lists any old day!Thu, 29 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19550 http://my.advisor.com/doc/19569Use this technique to make it easy to rename database elements.Thu, 29 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19569 http://my.advisor.com/doc/19566Mon, 26 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19566 http://my.advisor.com/doc/19567Sometimes the screen refreshes; sometimes it doesn't. Here's a fix.Mon, 19 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19567 http://my.advisor.com/doc/19568You can build on your knowledge of basic FileMaker Pro finds to run complex finds via the Web -- and here’s the PHP code to help you do it!Mon, 12 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19568 http://my.advisor.com/doc/19565Values that have carriage returns in them get broken into separate values for the purposes of a value list. Here's a workaround that lets you use text blocks containing carriage returns as values in a value list.Mon, 05 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19565 http://my.advisor.com/doc/19572Here's a formula that tests to see if a record belongs to the currently logged-on account, but also allows the full-access password to see all records.Mon, 05 Jan 2009 00:00:00 GMTFileMaker.Advisor.comhttp://my.advisor.com/doc/19572