Filemaker Success Tips 306
Mid Design steps, Raspberry Pi, The value of decoupled scripts Filemaker Success Tips : 306_FM_Success_Tips.
Like
0
Liked
Liked
Development Theory
Self Clearing Process Locks in FileMaker
A SELF CLEARING PROCESS LOCK? Not the sexiest of topics, but exciting to those who have had to deal with clearing locked processes manually. Thanks to Kevin Franks for posting this solution, although credit for the work belongs to Bob Gossam of Absolute Advantage for developing this technique: Occasionally we need to program a process […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
FileMaker Variables – Local vs Global Explained
A NICELY WRITTEN post on variables from Dwayne Wright. Some topics don’t change much over the years, and this one stands the test of time: A local variable is defined by adding a single dollar sign in its name such as $InvoiceNumber, $ClientID or $Counter. A local variable will store it’s information within the script […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
FileMaker Relationships – How They Compare
OK, I’M TALKING ABOUT TABLE OCCURRENCE relationships here, not the other kind. Although those might get more hits… Dwayne Wright explores the basic different types of relationships that are possible between two tables: …there is a feature in the FileMaker define relationship dialog box, you can define what is a compatible relationship. For example, say we have […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
Ditch those Flush Caches, Use Cartesian Join Instead!
REFRESHING RESULTS through a relationship in FileMaker can sometimes be frustrating. You will need to find a way to nudge the related records in order to get the updated results you need to show. Daniel Wood tackles this issues and developed a way to fix it: Cartesion Joins! The refresh problem arises because the relationship […]
Like
0
Liked
Liked
-
James Bardwell: Donald, doesn't FM 13's "Refresh Object" script step help to address the need to refresh a named portal?
-
Don Clark: Hi James- Yes, it does: If the specified object is in a portal, Refresh Object updates the object in every…
-
Contact FM Pro Gurus for help
How to Organize FileMaker Layouts
SMALL ORGANIZATIONAL TIPS are often overlooked in the overall picture. Meaning the new or intermediate developer doesn’t get up to speed quickly on tricks that would help organize his efforts. This video from Dwayne Wright shows a simple concept for organizing layouts into folders–simple yet powerful for keeping a handle on where things are in a larger […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
10 tips for designing great looking layouts in FileMaker Pro
DESIGNING USER INTERFACES in FileMaker Pro is a challenge for most, if not all, developers. We all strive for the interface that is great looking, intuitive, and easy to use. This is even more critical given the trends in the industry now towards oversimplification–many times functions and tasks are so well hidden and non-intuitive that experienced […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
Remembering What FileMaker Portal Data Is ( GTRR )
ONCE YOU GET YOUR MIND AROUND THE CONCEPT that records in a portal are just related records in another table, report generation becomes so much easier: It might help you to understand the options you have in printing your portals, if you take a moment to think about what portal data really is … related records […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
Unique Records in FileMaker Revisited… again, part 2 | FileMakerHacks
KEVIN FRANKS continues his series on finding unique records, this time applying the techniques to a more normally designed set of tables: The demo in part 1 was based on a single “flat table” of data. Today we’re going to unflatten that table, and see how the technique can be applied to a properly normalized system, […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
FileMaker Pro 13 – Stylin’ Part 2 – The Scarpetta Group, Inc.
DIG A LITTLE DEEPER into FileMaker 13 themes with James Scarpetta (Part 1 here). In this demo file click on one of the Text styles, make some adjustments like text color and then save the new style by clicking on the Styles Tab in the Inspector and the Icon that is now red next to […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
Visual Design Basics for FileMaker: Line
A NEW FILEMAKER BLOG focused on design–a welcome addition, in my view. Mostly because I struggle with design issues on every project. I’m all in for anything that makes it easier. Quoting Alexis Allen of designingfilemaker.com: Lines are one of the most basic elements we work with in layouts. Our minds only need the merest […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
Make Use of FileMaker Database Transactions
DID YOU KNOW FileMaker supports database transactions? Do you realize the importance of database transactions to rolling back changes, making like easier for multi-user databases, and providing data integrity when something bad-system crash, network problems, etc-happens? Todd Geist has the answers to these questions along with a very in-depth explanation of how and when to […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
Should FileMaker Kill The Lookup Feature?
LOOKUPS VS CALCULATIONS. Which do you use and why? Would you kill off lookups? Any time you can introduce the calculation engine in a place you wouldn’t expect it, your design options extend radically. The auto enter via a calculated result is no exception. For traditional lookup duties, consider using an auto enter via calculation […]
Like
0
Liked
Liked
Contact FM Pro Gurus for help
Easily Create a Progress Status Bar in FileMaker 13
ANDY PERSONS built a portable progress bar using the new FileMaker 13 Base64Decode() function and some creative thinking: This technique makes use of FileMaker Pro 13’s new Base64Decode() function to convert text into an image. The ProgressBar() custom function includes a pre-built 1 x 100-pixel bmp base image and inserts the foreground or background pixels […]
Like
0
Liked
Liked
-
Progress Bars, HTML, Base64 and FileMaker - FileMakerProGurus: [...] THIS LINKEDIN POST FROM LAST WEEK on using Base64 to make progress bars led to others in the LinkedIn…
EfficientBizz: I've been told (and actually believe) that cartesian [x] and comparable [≥≤] operators are speedkillers. To avoid cartesian, i have…