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
Buried within the layers of complexity inside any technical system are the simple settings of multiple parameters and/or settings. You simply need to get the right pieces into the right places. You know - like a jigsaw puzzle.
And, once the puzzle starts to reveal itself, the understanding of what the picture is becomes so much more clear. That's the goal of this particular video when it comes to connecting to the myriad of possible Google services.
FileMaker Pro, in the last few years, had improved by leaps and bounds with regards to working with external systems and services. With everything you need now built in the the native client, you can easily connect to Google's services and make the most of them right within your own FileMaker solution. You may just need a head start on the understanding in order to see the whole picture. Fortunate, that's exactly what this video will do for you. If you need to connect to Google services for any reason then look no further!
FileMaker Pro provides us with a wonderfully blank canvas in order to present data however we wish. It's called Layout Mode. When you combine that feature with the recently added Card Windows the power to solve presentation problems goes up quite significantly.
Such is the case when it comes to providing users with a date picker, or a calendar widget if you will. In previous videos, I've provided instruction on how to make a very simple calendar widget. When you combine that widget with a Card Window you simply gain full control about how a user makes selections for date values.
So, what's the best method of implementation? Well, like all things, there are many ways to approach the problem. In this video I discuss the use of global variables and the differences in context when working with Card Windows. I present some of the better ways to approach the solution and how to clean up after yourself when considering the use of global variables.
If you're in need of expanding your FileMaker knowledge and you happen to also need a simple, yet powerful date picker, then I'm sure you'll enjoy watching this video about a Universal Date Picker.
Recently, while providing intermediate training at the annual FileMaker Devcon, I had an attendee approach me and ask a very simple question. "How do you turn off the grid in FileMaker?"
Like all questions, it was asked within the context of innocent ignorance. This was simply because this person had not yet used, nor explored this area of FileMaker. This is totally understandable with the increasing number of options found across the increasing number of palettes within FileMaker.
However, if you think this video is simply about how you turn on/off the grid, then you'll be missing out on a whole host of features and options which can both benefit your layout designs and make things much faster for you within the area of your designs.
This video is about taking full advantage of the grid and making decisions about how to use it and how to choose the right width for your designs. Plus, you'll get all kinds of tips about how to make your layouts feel "visually comfortable" so they appeal to users. Think you know about using FileMaker's Grids? Double-check by watching this video!
The age old question commonly arises on FileMaker forums around the world. "How can I duplicate the whole record?" In other words, how can I duplicate the parent record and all related children records which make it seem like it's one whole entity.
Well, at least, that's how a newer user/developer sees it. They may visually see the one record with all of its related records presented within the portal, but making the distinction that you're actually looking at 1 record plus N related records isn't super obvious from a UI standpoint.
However, as a FileMaker developer, you need to know how to duplicate the whole collection of records so the user can conveniently click that one single button which reads "Duplicate". There are many methods you can use to accomplish this task, but there are a few tricks to making to work successfully and reliably depending on your specific requirements.
In this video I present one of the most efficient methods for duplicating whole related record sets. No matter how many sets of related records you have, you can always take advantage of the inside knowledge on how to accomplish this type of task in FileMaker Pro.
Card windows will continue to impact our FileMaker solutions for years to come. Released in FileMaker 16, who would have thought that simply creating a new way to draw windows would be so empowering. We've long been able to create modal windows which force user interaction - but taking off the title bar and dimming the background window was all it took to make things much more powerful.
So, what is the most common thing you can do with a card window? Well, create a reusable dialog box of course. In previous videos I've covered card windows for progress bars, menu navigation systems and ultimate card window positioning. In this video, I show you how to take advantage of the new FileMaker 17 feature of being able to target a script based on the name of the script. By doing this, we can create a reusable dialog box system which provides us with full visual control and styling of the content.
If you're interested in taking full advantage of the latest features and you'd like to standardize your own custom dialog boxes then this video will have the information you need.
While FileMaker's calculation engine is super powerful for managing all kinds of unique calculations, the one thing it lacks is a feature for running a repetitive function across a range of data. This is certainly possible within the Scripting engine with the use of the ever wonderful Loop script step.
However, as stated, there's no way to really process a range of data using just a function. Unless... you create your own or use one which has already been created.
As it happens, there is just such a function which has long been one of the most powerful custom functions of all possible FileMaker custom functions. It was created over a decade ago and is still, too this day, one of the most powerful custom functions you could ever learn to use. The function is called CustomList and it's a must-know function for any FileMaker developer.
Using multiple files for developing a robust FileMaker solution can be pretty normal when you plan out the distribution of your data and servers. Some solutions benefit from breaking out part of the solution into one or more separate files.
So, whether taking the load off a given server or simply planning for quicker data access across multiple time zones, one of the bigger problems which pops up with your standard FileMaker accounts is password management. This is where it becomes much easier to use external authentication.
In earlier days, we only had access to Active/Open Directory or system accounts hosted on the same machine as FileMaker server. But, since FileMaker Server 16, we now have the ability to use external authentication through Oauth. This means we can use a third party like Amazon, Google or Microsoft in order to allow users to access solutions and manage their own passwords.
If you're looking for an easier way to manage the users of your solution, then you'll find out how it works and how to make it happen within this video about Oauth External Authentication.
The Layout Objects palette was an absolutely WONDERFUL addition to working in FileMaker's Layout Mode. If you've not given yourself the time to fully explore what's possible with it then this video will give you a great reason to do so.
In this video, I walk through a re-work I needed to do on a database project which had a ton of extra layout objects. I show you how I used the Layout Objects palette in the most effective way possible. The tips and tricks provided may very well save you a ton of time too.
Think there might be some hidden tricks waiting within the Layout Objects palette? Then this video is certainly for you!
One of the challenges I love the most within FileMaker is creating something which requires less time and effort than the "older way" of doing the same thing.
Such is the case with a tabbed list view. I recently came upon a sample file showcasing how to do something in multiple list views. It was using an older method of "simulated" tabs by simply placing clickable buttons in a horizontal row and making one of the buttons look different on each respective layout.
So I thought to myself, "Why isn't he just using a normal tab panel?". You can certainly do it. You just need a few key pieces of info in order to create a very powerful navigational tool for a tabbed based list view. And, that's what this video is all about Tabbed List Views.
Every craftsman should know how to use his or her set of tools effectively. When you know all the various uses and features of a given tool you then become more efficient at your trade.
In FileMaker Pro Advanced, now available to pretty much everyone in version 17, there's one tool which helps you both understand what's happening and figure out what's not happening. The Script Debugger is an absolutely essential tool.
Creating a well functioning script is a lot like Michelangelo creating David. It didn't just appear because he held the tools in his hands. It was because of the constant refinement with the tools until the beauty within was finally present. Writing a script is no different. You won't get it right the first time and you with almost always be able to refine and make it better.
So, it goes without saying that knowing how to use the Script Debugger is one of the number one things you should know how to do when coding in FileMaker Pro.