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 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
- Windows
- XML
Our Library of Videos
When something new comes into fashion, sometimes, you just can't ignore it. Such was the case with Card Windows. They just opened up so many possibilities within the world of FileMaker development.
While Button Bars, Popovers and Sliders have changed the way many things are done within your FileMaker user interface, the way Card Windows can be used should be your first consideration for many of your standard UI tasks.
Understanding what happens when a card window comes forward allows you to take advantage of some of the various features it provides.
In this video I walk through some helpful positioning functions and how the Card Window really behaves in relation to it's parent window and what you can do to take advantage of these cool new features.
For some of us, one of the most enjoyable aspects of programming is the fact that we get to feel so "in control" over every single aspect of how something works. You are the God of your own universe and it's either as bad or as good as you make it.
Our human shortcoming, however, is that fact that we don't just know it all - we have to learn the various ways of doing things. Knowing how to use FileMaker's functions, and when they are useful, is a key aspect to creating well functioning software.
This video is a walk through of the ever critical logical functions. Without them, none of us would be making any software. So, sit back and relax for the well covered topic of FileMaker's Logical Functions.
FileMaker 16 changed the entire landscape of how many things are accomplished within FileMaker. Because of the ability to show a completely different context as a new Card Window, you can now do all kinds of wonderful things.
Need an interactive sidebar? Use a Card Window. Need greater degree of control over your custom dialog boxes? Use Card Windows. Need to present a pick list, a palette or pretty much any information you could ever want to display in a dedicated child window? Used Card Windows!
Awesome, so we now have Card Windows. But, the immediate utility may not seem as powerful as it could be when the Card Window defaults to the same size as the layout upon which it's based. Plus, if you want to position the window relative to its parent you need to be ready to do a bit of simple math. So, why do the simple math when you can make it even more simple? That's what this video is all about - Ultimate Card Window Control!
FileMaker Pro has some very simple and straight-forward validation options. For example, if you only want one field named email to only ever have a single copy of a given email, you choose the Unique option in the Validations section of the field's options.
But, what if you want to allow a given contact record to have multiple email addresses. How do you check for uniqueness across multiple fields? The same email could appear within one field and then would be perfectly valid in a second field which doesn't contain the original email.
Well, here's the solution. Watch this video and use the provided technique file to simply copy the solution into your own FileMaker database. We'll use some creative tricks in order to make the process both robust and very powerful!
Whether you're just starting out with FileMaker Pro or you've been hovering in the intermediate zone for a little while, it's always a good thing to have a solid understanding of how to structure data and use the Relationship Graph in order to accomplish the end objective.
When it comes to presenting a reducing set of available options, you have to understand how to get at what isn't being used in order to present it. The steps you need to take to show what isn't being used requires you to, first, know what IS being used.
In this example technique file and video, we take a look at breaking down the individual parts which make it easier to understand how to present a list of reducing available options. Once you know how to create dedicated filtering keys and how to construct your value list, it should be pretty easy to present the data you want to present.
So, what's the point of collecting all that data if you're not going to determine what it's telling you? Well, a lot of those burning questions are often answered with the power of the Aggregate functions.
Whether you simply need some total using the Sum() function or if you're an advanced developer writing crazy scripted loops using the List() function, you need to know how to use the Aggregate functions to achieve the desired results.
There are a few peculiarities about using the Aggregate functions, but once you've got them down you can decide how you want your database to behave. Using the Aggregate functions, you can store your aggregate data and move in the direction of better performance in favor of FileMaker figuring it out for you all the time. Or, you can just use FileMaker in the same way you've always been doing and simply take advantage of its easy power. Either way, it's all covered in this video about the Aggregate functions.
Don't get me wrong, FileMaker has a lot of cool things it can do all on its own. In fact, they keep adding more and more useful tools which makes it easy to create great working software.
There are, however, those certain things that FileMaker just can't do on it's own. For example, you can't interact with images within container fields quite like you can certain web pages. Yet, right in front of us, we have the wonderfully powerful Web Viewer which exposes access to the power of JavaScript and all those wonderfully free libraries.
Enter the common scenario where an easy-to-understand image file directly represents a nicely complex data structure. We'd like to use the image to navigate the data and we can certainly add it directly to a layout and overlay buttons over it. But, hold your horses there señor gung-ho developer. What if your image is so complex that it would be absolutely tiny if you placed it on the layout at 100%.
Well, that's when we ring up our wonderful friend Mr. SVG. He'll take care of us. He's scalable you know! So, how about a zoomable and clickable SVG which directly represents how we'd like users to navigate the data? No problem!
When first learning about database development, and how to store large files such as media, archives and documents, I was introduced to the concept of a BLOB (Binary Large OBject).
At that time, I wasn't using FileMaker Pro as of yet but a database called FoxPro. The concept of FileMaker's Container fields, as places to store BLOBs, came so much easier than having to convert a file into another format which can be stored within a SQL data store - which is what you have to do with some other database systems.
In today's modern computing world you need to be familiar with how to encrypt things and how to transfer them between various services. This video will overview the Base64 encoding functions, the Crypt functions and all the other Container related functions. If you'd like to understand how and where the container functions will help you out with working with containers then you'll likely find what you need in this video.
Knowing how FileMaker's Date and Time functions actually work is quite a big help when you're creating anything related to time based data.
When I first started learning FileMaker, I was pleased to see how easy it was to use the date and time functions. However, I didn't quite know how things worked underneath the hood. It wasn't until I tried creating my first calendar within FileMaker that I had to really get into the guts of what was going on.
Once I learned how the functions really worked, I was able to easily achieve the results desired. This video goes through the insides of how the date and time functions really work. This is what you really need to know in order to get the most out of FileMaker's date and time capabilities.
If you're the type of person who's into Math, then you probably know when you need to use Factorial() versus Exp() versus Div(). Inevitably, you're a better mathematician than I. My use of the Number functions extends to how useful they can be when you're creating your FileMaker user interface and solving workflow related problems.
When it comes to FileMaker's Number functions, there are number of tricks I've picked up over the years from those who are much smarter at the "math part" than I am. For the most part, the functions are there when you need them and are obviously useful when your required solution deals with math.
In this video, I go through the Number functions and talk about when and how I've used them. Which ones I've used the most and what you can do with them.