FileMaker Max Advisor
Web Edition 2010 Week 07
ADVISOR ANSWERSKeep your pictures pretty.By Chris MoyerREPORTING Make FileMaker data more meaningful by presenting it graphically with PHP and Google's Chart API.
Jonathan Stark, technical editorADVISOR TIPSA calculation-based method of updating as the found set is changed, without running a script.By John Mark OsborneADVISOR TIPSA previous tip showed how to use script triggers to record field-level history in a separate table, but Windows users reported window flashing. Here's a fix.By John Mark Osborne, technical editorPROGRAMMING Here are some ways to take your scripting beyond the basics.
By Jonathan StarsPROGRAMMINGIf you feel as if you’ve been left in the dark with custom functions, this is the article to get you started — nice and easy.By Jonathan StarsUSER INTERFACE Here's how to highlight different parts of a graphic based on data stored in FileMaker Pro.
By Andy Cohen, Ph.D.ADVISOR TIPSIn complex systems, scripting errors often occur because records have been modified, causing the validation to fail. Here's how ot handle these situations.By John Mark Osborne, technical editorACCOUNTING Tour the most popular business accounting applications and see how well they work (or don’t work) with FileMaker Pro.
By Linda PittsADVISOR ANSWERSIf the user is working in a maximized window and they do something that creates a new window, the background window reverts to its non-maximized size and location. Here's how to remedy the situation.
ADVISOR TIPSIf you know the mobile phone number and the carrier, you can send SMS text messages from FileMaker Pro.By John Mark Osborne, technical editorDATA INTEGRATION.com Solutions FmPro Migrator automates Access migration to FileMaker Pro.By William Roger MoseidADVISOR TIPSUse the Self function and you’ll never have to worry about field names ever again.By John Mark Osborne, technical editorADVISOR TIPSHere's how to highlight the currently active record in list view without a script or plug-in.By John Mark Osborne, technical editorADVISOR TIPSLet users drag and drop portal rows so they can easily create custom sorts.By John Mark Osborne, technical editorADVISOR TIPSLet users choose their window size without it affecting your solution.By John Mark Osborne, technical editorADVISOR TIPSRegardless of how tempting, restist the urge to continue using a file after you've recovered it. Here's some insight on properly use the Recover feature.By John Mark Osborne, technical editorADVISOR TIPSDisplay tooltips with the contents of a field comment.By John Mark Osborne, technical editorADVISOR TIPSHere are some of the subtle changes in FileMaker Pro 10 that might have gotten lost in the shadows of script triggers, SMTP e-mail, and live subsummary reports.By John Mark Osborne, technical editorADVISOR TIPSThe order in which script triggers fire determines how your solution functions. Here's what you need to know.By John Mark Osborne, technical editorADVISOR ANSWERSHere's how to render a percentage as a simple horizontal bar graph.By Chris Moyer and Bob Bowers, technical editorsPROGRAMMINGUse these custom functions to perform complicated or frequently used calculations.By Brian Dunning, technical editorFILEMAKER PRO DATABASE DEVELOPMENTModify existing solutions for reuse.By William Roger MoseidREPORTINGExtend virtual lists for custom reporting and data manipulation.By Bruce RobertsonREPORTINGInvoices (and other reports) are like perfect gift boxes — or at least they should be. But getting the field borders to behave properly can be quite a trick when the data inside them is more than one line tall.By Jonathan StarsPROGRAMMINGLearn how to use FileMaker Server 10 to sync systems, generate reports, and send e-mails automatically.By Micah WoodsDATA INTEGRATIONEntering data into online Flash applications normally requires manual user operation, but here’s a way to use scripts to do it.By HOnza KoudelkaADVISOR ANSWERSThis example starts with a list and ends up with a list of URLs.By Chris Moyer and Bob Bowers, technical editorsWEB DEVELOPMENTLearn how to create checkboxes on HTML forms (and see how they relate to the FileMaker API for PHP).By Jonathan Stark, technical editorDATABASE DESIGNWhen it comes time to add features or debug earlier ones, do you dread working with the relationship graph? It could be time for a retrofit.By Jonathan StarsADVISOR TIPSHere's how to identify the version of FileMaker (independent of the update version).By John Mark Osborne, technical editorDATABASE DEVELOPMENT Here's your step-by-step guide to building a simple database.
By Geoff CoffeyFILEMAKER PRO 10 Tweak the FileMaker Pro 10 toolbar to customize your work environment.
By Anton AndersonUSER INTERFACEMake sense of portals.By Susan Prosser, technical editorADVISOR TIPSIt isn't something you need to do every day, but there are times when a list of your field definitions on paper comes in handy.By Stuart Gripman, technical editorADVISOR TIPSHere's how to print a relationship diagram.By Stuart Gripman, technical editorADVISOR TIPSHere's how to add Page-x-of-y-style numbering to your printed pages.ADVISOR TIPSIf you've ever written a crazy calculation to declare global variables to identify the current tab via a script, you'll be happy to know FileMaker 10 makes it a little easier and organizes all the code into just a script -- but, the process still isn't completely straightforward.By John Mark Osborne, technical editorADVISOR TIPSWhenever you change layouts, the tabs on the Tab Control object reset to the default. Here's how to change that.By John Mark Osborne, technical editorMOBILE DEVELOPMENTLearn how to set up remote, iPhone-friendly access to your databases.By Brian Dunning, technical editor |
YOUR NAME HERE
Share your FileMaker tips, tricks and techniques with the community by sending them to FileMaker Advisor. Submit at http://Contact.Advisor.com.
NOTICE: FileMaker Advisor is no longer published in print. (Print subscribers, see our email to you for details.)
To get EVERYTHING we publish about FileMaker -- our MAXIMUM FileMaker expertise -- read FILEMAKERMAX.ADVISOR.com -- the ultimate Advisor Guide to FileMaker software. You get everything new, plus essentially everything published in recent years -- articles, tips, downloads, the complete reference library -- and more! Click here to subscribe now.
ADVISOR EXPERT
Jonathan Stars
PROGRAMMINGHere are some ways to take your scripting beyond the basics.By Jonathan Stars
ADVISOR EXPERT
Brian Dunning
MOBILE DEVELOPMENTExplore new, brilliantly useful features for your FileMaker Web development for the iPhone.By Brian Dunning, FileMaker Advisor technical editor
ADVISOR TIPSLet users choose their window size without it affecting your solution.By John Mark Osborne, technical editor |
RSS Feed