Article Tags
Click or tap one of the article tags to filter down to a smaller selection.
- Accounts
- Add-ons
- AI
- Alerts
- Analysis
- APIs
- Apple Maps
- Auto-Enter
- Barcodes
- Base64
- BaseElements Plugin
- bBox
- Breadcrumbs
- Button Bars
- Caching
- Calculations
- Calendars
- Card Windows
- Charting
- Checkboxes
- Code Editing
- Code testing
- Coding
- Color Picker
- Colors
- Conditional Formatting
- Containers
- Context Management
- Cropping
- Crypto
- CSV
- cURL
- Custom Functions
- Custom Menus
- Data API
- Data Capture
- Data processing
- Data structure
- Data Viewer
- Date Ranges
- Dates
- Debugging
- Deployment
- Developer Tools
- Dialog Boxes
- Docker
- Drag-n-Drop
- Drop-down List
- Dropbox
- Duplicates
- Duplicating records
- Encryption
- Error handling
- Events
- Excel
- ExecuteSQL
- Exporting
- External Authentication
- External Files
- Field Formatting
- Field Storage
- Fields
- File IO
- File Management
- File Sharing
- FileMaker Go
- FileMaker Server
- FileMaker Settings
- Filtering
- Find & Replace
- Find Mode
- Found Sets
- Functions
- Fundamentals
- Global Fields
- Global Variables
- Google Forms
- Google Maps
- Google Services
- Graphics
- Grid
- Grouping
- Hierarchies
- Highlighting
- Icons
- Images
- Importing
- Indicators
- Inspector palette
- iOS
- Java/Groovy
- JavaScript
- Join Tables
- JSON
- Key fields
- Layout Design
- Layout Mode
- Layout Parts
- List function
- Logging
- Looping
- Mapping
- Marking Records
- Media Storage
- Menus
- Merge fields
- Messaging
- Microsoft Surface
- Mobile design
- MonkeyBread plug-in
- Multi-key fields
- Multi-option fields
- Naming Conventions
- Navigation
- New Release
- Node-RED
- Notifications
- Oauth
- Object management
- OCR
- OnGestureTap
- OnLayoutKeystroke
- OnObjectKeystroke
- Parsing HTML
- Perform Script on Server
- Performance
- Permissions
- Photo manipulation
- Pickers
- Pivot tables
- Pop-ups
- Popovers
- Portals
- Preferences
- Printing
- Privilege sets
- Product review
- Productivity
- Progress Bars
- PSOS
- Python
- Quick Find
- Record Locking
- Regex
- Relationship Graph
- Reporting
- REST
- Sankey
- Schema
- Script Parameters
- Script Triggers
- Scripting
- ScriptMaster
- SDK
- Searching
- Security
- Separation Model
- Set Variable
- Settings
- Shortcuts
- Sliders
- Snapshot Links
- Sorting
- Spelling
- Spreadsheets
- Startup
- Summary Fields
- SVG
- Syntax
- Syntax Highlighting
- Tab Controls
- Table View
- Tagging
- Terminology
- Text Parsing
- Themes
- Time fields
- Time Savings
- Tips
- Tools
- Transactions
- Tricks
- Twilio
- UI
- Updating
- User Interface
- Validations
- Value Lists
- vCalendar
- Virtual list
- Web Forms
- Web Scraping
- Web Services
- Web Viewers
- Webhooks
- Windows
- XML
Our Library of Videos
Little by little, newer versions of FileMaker have been making it easier to accomplish tasks which typically required "workarounds" to provide certain features.
When it comes to filtering portals, the previous method was to use a dedicated relationship in order to filter out related data - which is still valid in a variety of situations. However, with the release of FileMaker 11, the new filter portal option, presented as a check box on the portal settings dialog, offers a much easier method for filtering portals.
Initially, there were some harsh critics, as the filter was a "display only" feature and did not adjust calculations which used the same relationship. Enter a few pieces of critical know-how and you get the exact feature you were expecting with all the bells and whistles.
This video showcases how to fully leverage the new filtered portal option within FileMaker 11. The example shown is one of the most common, where filtering is done on both a first and last name where either part contains a sequence of characters. If you're seeking that ultimate degree of filtered portal polish, then look no further than this video!
The other day, while recording a podcast with Matt Navarre, I mentioned that if a mobile component is part of my FileMaker solution strategy, that I would simply make a UI file specific to the mobile component.
It occurred to me that this concept, while simple, may not be the first thing you think of when creating your overall FileMaker system.
The truth is, it's much easier to isolate out the different, and distinct, components of your solution. Primary solution data, shared solution data, Mobile UI, Web UI and Desktop UI are all distinct from each other. However, many times, we tend to cram all these things together in one FileMaker file simply because it can be done.
This video introduces the concept of breaking out the different UIs and using the separation model to structure you FileMaker system.
The later part of the video highlights a wide variety of Mobile UI resources and tools. If you're heading down the path of using FileMaker Go for iPhone/iPad as part of your strategy then this video will certainly give you a comprehensive collection of resources to leverage!
It's time again for one of those articles about the "pretty" software. You know, where I talk about how people like to use things because they look good. Really, who wants to drive an ugly car when they can drive a pretty one that other people want to drive as well. Don't envy the pretty software, emulate it and join the in-crowd (no correlation to high school here).
Your database interface is no different than that car, and, while FileMaker doesn't currently have the state-of-the-art in user interface elements, there's no reason to not make your solution look as attractive as possible.
This video provides five different tips about how to approach the design of your user interface. It's one of my most favorite topics to cover, and there's always some little tidbit of knowledge which helps make your solution that much more usable!
No matter what FileMaker solution you're working on, you probably won't be leaving full admin access on the file. You don't want just anyone doing anything they want in the database - especially hacking up your beautifully crafted scripts.
So you'll be going through a process of re-logging into the database while both developing and testing. This can be accomplished using an easy or hard way. The harder way is to do what might come naturally, simply double-click the file after closing it down.
The problem is, any frequency of this activity and you'll quickly wish there was a better way. Fortunately, you can script most anything possible within FileMaker. This means you need a solid way of making this happen without making your solution insecure - which will certainly happen if you include vital credentials within the file itself.
You can always store a username/password combination in the file, while developing, and then remove them when you deploy, but this becomes an issue when you need to log in to make small fixes when the file is live - if you tend to do that type of thing.
The solution is to simply create an efficient method for switching accounts on the fly. That's exactly what this video has to offer!
After working with FileMaker's window script steps, for any length of time, you quickly start to realize there must be an easier way to center windows. Yeah, you can center the current window right within the New Window script step. But, what about making the centering optional based on either the monitor screen or the parent window.
Now, I'm sure there are thousands of different ways to approach this problem. Some of my fellow developers never want to see the window appear anywhere on the screen other than the intended final destination. Myself, I'm ok with a little resize and on-screen moving.
So, my typical approach is to use a few dedicated custom functions and a "one-stop-shop" script for managing all windowing functions.
You can find the functions I show in this video at my github repository here fmpfunctions on GitHub.com.
If you have your own method for managing windows I'd love to hear about it!
FileMaker 11 came with a fancy new feature called Snapshot Links. These small XML-based files store all the necessary information in order to recall a "last known view" of a given data set.
Imagine, if you will, a user is working on a "donor call list". They are presented with a list view of a larger subset of data - the people they must call. The user has made it half way through the list and it's quitin' time for today.
The courteous thing to do would possibly be asking "Would you like to save your place for tomorrow?" and simply doing so upon an "Ok" confirmation and closing the window.
The next day the user comes in to work, the database is opened to a dashboard layout with a portal displaying a task list. There at the top of the portal is an item titled "Finish donor call list". Clicking that portal row simply opens a new window taking the user back to the exact location they were at when they left the previous day.
Normally, this type of feature would require many different scripts and a good amount of time to implement. Now, what would you say if this could be done in two simple scripts? Well, if you're interested, then watching this video will answer your questions about Snapshot Links.
The world we live in, compared to the one I experienced growing up, is simply amazing. I'm personally looking forward to the inevitable questions of "What's a phone book Daddy?" and "How did a card catalog work?" - if only to feel like an idiot for not realizing that cell phones have always existed and I should've known that "fact".
When it comes to using a map, I'm wondering when they'll stop printing them on paper. Seriously, the ability to know where you're at using GPS and real-time digital maps, to see where you're going and enjoy street level views of other countries without having ever stepped in that country is, well, just awesome.
Which means there's no reason not to integrate these features into your FileMaker solutions.
At the most basic level, we often have the need to perform easy lookups for address verifications. This can be done manually, or at the point the address is captured. The trick with these types of wiz-bang features is that you need the data to perform the lookup against.
Having created many solutions which use geo location based data, I've created a video which highlights both a resource for comprehensive GeoLocation data, including lat/long, postal/province codes and other valuable information, along with information about using and updating this type of valuable resource. If your database adventures ever bring you to the point of needing to interact with Geo Location Data then this video will surely delight you.
If you know the right check boxes to tick, and how FileMaker behaves behind the scenes, you can create a very minimalist, yet super efficient user interface for presenting information. In this video I do this very thing.
Using the standard Person -> Addresses example, I showcase how you can really simplify the information presented and still retain all of the expected functionality.
The one thing that many database designers (those who do not consider themselves user interface designers) seem to forget is the fact that you don't have to show all the data entry options possible. You can often present only the minimalist amount of information needed for reference and simply facilitate features which allow that information to be extended or edited.
Your FileMaker portals don't have to present data entry options if they at least facilitate navigation of the very data which the user might edit. So, watch this video if you're looking to either streamline your data presentation to just to learn some new FileMaker specific tricks.
FileMaker has slowly added new features to its formerly nonexistent event model. We now have a wide variety of script triggers and this is immensely helpful for making solutions much more interactive.
What FileMaker does lack are things like 'mouse overs' and other "niceties" such as animation events.
Fortunately, we have access to anything the web browser can do. While some developers tend to shy away from using web viewers my big question is "Why?". It's there, it's stable, it's standard and you can do a lot of cool stuff with them.
If you're looking to add that attention getting dialog into your FileMaker solution then this video will certainly have what you're looking for!
FileMaker's Layout mode is pretty robust in terms of what you can design and present in your user interface (if you overlook the lack of native gradients and native OS widgets). When working with portals, in particular, all you have to do is throw your buttons and icons on the first row and magically, they all appear and function on any other row - respective of the row they are on. Very helpful indeed.
So what about those times when you REALLY need to exercise control over what will display on a given row and the times when one row needs to know what's on the next row or previous row.
Well, there are some hidden little tricks you can use to really take advantage of this powerful portal formatting. Watching this video will provide you with the insight necessary to exercise this control!