Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
for peer-to-peer support of the FileMaker Platform and related products and services.
Forums are a great way to get technical advice for FileMaker but for some reason, many people don't think they have to be nice in the electronic world. I was raised to say "please" and "thank you" and that has translated over to the internet for me. But, other folks think the anonymity of cyberspace is an excuse to be a jerk. Some posters are outright offensive and others will just leave snide responses like, "that wasn't much help". News flash! People on the internet are real and you should be
The FileMaker Let function is your tool to make a calculation readable, well formatted and easy to debug. Let us discuss how it can be used.
The post Like a Boss: Let us Discuss the FileMaker Let Function appeared first on Geist Interactive.
View the full article
FileMaker Kanban is the latest tool that offers familiar functionality for users and flexibility for the developer. It offers great functionality and organizes your data visually into lanes and cards.
The post FileMaker Kanban: Organize Your Data appeared first on Geist Interactive.
View the full article
The FileMaker Script Debugger is powerful. Its features are often overlooked. In this post we examine the buttons that control stepping through a script.
The post Like a Boss: Using the Script Debugger to its Full Potential appeared first on Geist Interactive.
View the full article
For the first time, DB Services has been ranked #3494 on the annual Inc. 5000 list, which ranks the country’s “fastest-growing innovators” based on overall revenue growth over a three-year period. The Inc. 5000 list has brought attention to America’s growing private businesses since 1982.
DB Services now joins the ranks of other Inc. 5000 list alumni such as Facebook, Zappos, Pandora, and others. DB Services is top ranked FileMaker Platinum Business Alliance Partner on the 2019 Inc. 5000 li
No Access? Watch the preview video here. FriendlyAlphabetFiltering_Pre.mp4
Attachment
Size
FriendlyAlphabetFiltering.zip
379.22 KB
By Matt Petrowsky
As a developer, it’s often hard to get out of a mindset where your response of “It’s simple silly, you just search for a portion of the word, not the whole word.” to the question of a particular search not providing a user’s expected results.
This type of response may come from a user when they mention they know the user “Petrow
As a developer, it’s often hard to get out of a mindset where your response of “It’s simple silly, you just search for a portion of the word, not the whole word.” to the question of a particular search not providing a user’s expected results.
This type of response may come from a user when they mention they know the user “Petrowsky” is in the database but it doesn’t come across verbally that they’re really searching for “Petrowski” - which obviously doesn’t match the version ending in a “y” ins
Welcome back for a second dip into the developer bag of tips and tricks. A few of today’s entries assume familiarity with part 1, so if you haven’t already checked it out, I invite you to do so before proceeding. We begin today with a couple ExecuteSQL tips. Tip #1: Get to know COALESCE The […]
View the full article
Attachment
Size
DefensiveLayoutNavigation.zip
295.9 KB
By Matt Petrowsky
Download Video
If it hasn’t happened to you yet, then it will at some point. Your FileMaker solution will simply grow and grow and you’ll be adding complex layers of security and access as you develop.
As you add that security, your users may report back that they can’t do what they’re supposed to do. Maybe they’re locked out of a given layout with a giant gray screen with the small words of “No Access”.
U
If it hasn’t happened to you yet, then it will at some point. Your FileMaker solution will simply grow and grow and you’ll be adding complex layers of security and access as you develop.
As you add that security, your users may report back that they can’t do what they’re supposed to do. Maybe they’re locked out of a given layout with a giant gray screen with the small words of “No Access”.
Ughhh! What does your user do now? Why should you even be dealing with this issue?
What you really need
No Access? Watch the preview video here. SimplifiedSearchQueries_Pre.mp4
Attachment
Size
SimplifiedSearchQueries.zip
380.57 KB
By Matt Petrowsky
As a software/database developer, one of your primary goals is making your solutions easy to use. This means users should be able to perform common queries by simply clicking buttons which run the queries automatically.
This is probably something you already do. But, the big question is this, “Do you make it easy on yourself for cre
As a software/database developer, one of your primary goals is making your solutions easy to use. This means users should be able to perform common queries by simply clicking buttons which run the queries automatically.
This is probably something you already do. But, the big question is this, “Do you make it easy on yourself for creating those simple queries?” Many developers will create a unique script for each of the various queries, and in some cases this is just fine. It’s when you start fe
No Access? Watch the preview video here. DeveloperTipsTricks_Pre.mp4
By Matt Petrowsky
As with all mastery of any trade, it’s a matter of familiarity with the tools, along with practiced skill, in which a craftsman can hone his or her proficiency. In development, it’s often a matter of knowing which tools are available, and how to use them, which may make the difference.
In this video, I showcase the tools I use, their most important features and how I personally use them. If becomin
As with all mastery of any trade, it’s a matter of familiarity with the tools, along with practiced skill, in which a craftsman can hone his or her proficiency. In development, it’s often a matter of knowing which tools are available, and how to use them, which may make the difference.
In this video, I showcase the tools I use, their most important features and how I personally use them. If becoming a more efficient and capable FileMaker developer is one of your goals then make sure to watch th
Our 2016 FileMaker training courses are scheduled!
Our trainers are Certified FileMaker Developers, who have been developing custom solutions at Skeleton Key for many years. Please visit each page for information, dates, and to register.
If you would like an individual invoice, please contact us. We offer a multi-person discount for companies that would like to send more than one trainee. Please contact us with interest in this discount. We offer on-site training for companies that qualify.
Have you heard of FileMaker's New Product Idea Space on the Community? Learn more about it and why we love it! Video included. https://www.dbservices.com/articles/filemaker-embraces-crowdsourcing/
dbservices.com
Over the last few years I’ve been collecting miscellaneous tips and tricks with the thought of eventually aggregating them into a blog posting, and it appears that day has finally come. Ideally there will be something new and useful here for developers of all levels, from the neophyte to the most grizzled of FileMaker veterans. […]
View the full article
No Access? Watch the preview video here. SendingEmailMerging_Pre.mp4
Attachment
Size
SendingEmailMergeFields.zip
388.62 KB
By Matt Petrowsky
What would a database solution be without the ability to send email? Well, it would be a database solution without the ability to send email - but who wants that right?
Email is obviously an integral part of our modern day communication. And, despite what the Twitters, Facebooks and Instagrams of the world would have you believe, email
What would a database solution be without the ability to send email? Well, it would be a database solution without the ability to send email - but who wants that right?
Email is obviously an integral part of our modern day communication. And, despite what the Twitters, Facebooks and Instagrams of the world would have you believe, email is here to stay.
The easiest way to add email support to a FileMaker database is to simply use the Send Mail script step. But, that’s boring, and sometimes it d
By Matt Petrowsky
As we’ve all likely heard before, a movie isn’t just great because of the cinematography, it’s the sound that counts just as much. What you hear, not just see, is what makes the difference between good and great.
So, if sound is so critical to a movie, then the analogy to a FileMaker layout is color. Sure, anyone can move and arrange fields and objects into some semblance of order. And, using FileMaker’s layout objects to furnish your layout for the best possible user
As we’ve all likely heard before, a movie isn’t just great because of the cinematography, it’s the sound that counts just as much. What you hear, not just see, is what makes the difference between good and great.
So, if sound is so critical to a movie, then the analogy to a FileMaker layout is color. Sure, anyone can move and arrange fields and objects into some semblance of order. And, using FileMaker’s layout objects to furnish your layout for the best possible user experience does take a bit
Time to look for a technology that fits your needs, but not sure where to begin? Check out our comparison of FileMaker and QuickBase. YouTube video comparison included. https://www.dbservices.com/articles/filemaker-vs-quickbase/
dbservices.com
In a recent discussion at the FileMaker Community a question was asked about why a FileMaker developer would choose NOT to use SQL-friendly field names. It's an important question that I believe many FileMaker developers often answer incorrectly. Here's a bit about how my view of naming conventions has changed over time.
For reference, a SQL-friendly field name in FileMaker would be a name that:
starts with a letter
contains only letters, numbers, and underscore characters
is not
No Access? Watch the preview video here. SavingWindowState_Pre.mp4
Attachment
Size
SavingWindowState.zip
232.71 KB
By Matt Petrowsky
When developing in FileMaker, the feature set it offers accounts for a good number of common tasks and provides easy solutions for most of these problems. There are a few issues, however, which FileMaker either hasn’t addressed or wants to leave up to the developer.
One of these is saving the current window state. This applies to tab panels, sl
When developing in FileMaker, the feature set it offers accounts for a good number of common tasks and provides easy solutions for most of these problems. There are a few issues, however, which FileMaker either hasn’t addressed or wants to leave up to the developer.
One of these is saving the current window state. This applies to tab panels, sliders and moving from layout to layout or when closing the file. The desired result, for the end user, is to simply return to where they left off when re
No Access? Watch the preview video here. ButtonBarsNavigation_Pre.mp4
Attachment
Size
ButtonBarsforNavigation.zip
301.1 KB
By Matt Petrowsky
Most of FileMaker’s layout objects allow you to easily specify settings directly on those objects. For example, using Button Bars for the purpose of navigation means you can specify which of the multiple segments should be presented as active. Of course, your can also easily target which layout a button click should take the user to with
Most of FileMaker’s layout objects allow you to easily specify settings directly on those objects. For example, using Button Bars for the purpose of navigation means you can specify which of the multiple segments should be presented as active. Of course, your can also easily target which layout a button click should take the user to without creating a dedicated script.
The problem, however, is that FileMaker systems end up growing ever larger and the evolution process means you’re constantly ma
Some Vulnerabilities Associated With Ersatz Log-On Systems
October 29th 2015
My recent post [http://fmforums.com/blogs/entry/1410-new-paradigms-in-filemaker-platform-security/] on this BLOG about New Paradigms in FileMaker Platform Security has apparently occasioned a good deal of discussion in various FileMaker-related venues. Much of this reportedly has focused on the ersatz systems that I recommended be avoided. Many persons seem to have asserted that they use such systems for
