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 first learning about file operations, while working with PHP, I remember having to learn about the concept of buffers and buffer streams. Fortunately, we're not quite there yet within FileMaker. But, we have arrived at the point of learning about the nitty-gritty details of understanding all the details of files and how they factor into the FileMaker universe. FileMaker 18 released support for file IO and we're certainly going to be taking advantage of it in this new world of APIs and inter-connected applications.
If you've been using various FileMaker plugins which support the input and output of file data, then this video and its lessons may not be necessary. However, if you've rarely or never dealt with file IO (input & output), then you will certainly gain a lot of knowledge when watching this video and using the included file.
If your solution has the need to either output or input data from external systems or files, then understanding line endings and encodings is the key to working with files. Beyond the basics, we have FileMaker specific implementation of file IO. And, that's exactly what this video covers!
As the number of web sites hosting icon collections has grown over the years, it makes little sense to have your own collection of icons custom created at a costly premium. Typically, you can find pretty much any icon you could ever want to use and in many cases, you can even modify the icon to fit your specific needs if you need a slight variation.
With the release of Creative Commons licensing, a wide array of freely available collections and the easy ability to modify icons, you can quickly create exactly what you need for most any FileMaker app.
In this video, I go over the recently released Elemental FM Icon database and I cover all the details and specifics about my own personal icon workflow. From finding the right icon to getting it into FileMaker quickly, you'll learn all kinds of information about working with SVG icons.
Within every industry there's a certain terminology used to express how things work and how to accomplish things. FileMaker is obviously no different.
So, with this video, we start discussing some of the FileMaker specific terms and terminology.
You may be familiar with the routine when you have multiple duplicate records in your database. You end up having to reference multiple sources. Which can be a real pain. Ultimately, you end up needing to decide which record is the master and then merging as much of the data as possible from any of the duplicates.
This is a common scenario with any multi-user database system. Where, anytime you have more than one person working on the same data, you can inevitably end up with duplicates.
There are a few ways to deal with duplicates. The first is to try to prevent them in the first place. While this is certainly possible, there are other times where routine imports come from external sources or you've simply allowed duplicates to be entered into the database.
The question now is, "How do you identify duplicates?" and how do you address the fact that our eyes can trick us when we're looking at data which appears exactly the same - yet it's not. This video will show you how to truly approach duplicates and how to deal with them by giving you full control over defining what determines a duplicate or not.
It's just like when you see someone who is well-dressed, clean and sharp looking, your FileMaker user interface is no different. You're more impressed by that sharp, clean look. In this regard, not having something on your user interface is quite possibly one of the very things which makes your user interface look that much cleaner.
Portals and list views, pretty much anything which repeats itself many times, can be very overwhelming when there are a lot of options. Quite simply, if there are too many buttons, it's too cluttered.
In this video, we talk about getting those buttons off your user interface and making them available only when needed. It's a great way to start to clean up your user interface and make sure that certain option are only available after the user has made the selection of where they want to go next.
It's a simple concept, but one which is often ignored by newer developers because the examples they are shown do not take advantage of the opportunities to hide these types of buttons. So, we end up with FileMaker solutions which are littered with buttons on every list view row and every portal row. So, let's get rid of them until they are needed!
FileMaker 18 was released on Wed. May 22nd 2019. This video walks through all the new features implemented within the latest version of FileMaker Pro Advanced. Here's a short list of all the new features.
01) Security: Revised Manage Security Area
02) Security: Unsigned Plug-ins
03) Security: File References by Default
04) Data: New Import Dialog
05) Develop: Recursion & While
06) Develop: Script Error Logging
07) Develop: Insert From URL Protocols
08) Develop: FMP urls version specific
09) Design: Shift+Arrow 10x movement
10) Integrate: New Barcode Types
11) Develop: XML File Representations
12) Develop: File IO operations
Web browsers and their primary language, Javascript, have a very robust ecosystem. In fact, there's few solutions you can't find out in the world of Javascript.
So, in FileMaker, when it comes to our data and its presentation within a user friendly fashion, we can easily create a layout, set it to list view and allow users to simply start using FileMaker.
But, wait, using FileMaker itself isn't always super user-friendly. In fact, you have to learn how to sort by multiple columns by actually heading into a dialog box. Which, admittedly, becomes easier to use, but it's not immediately UI friendly in that you can't just click on the column you want to sort. Let alone select a second or third column and have those sorts apply too.
Enter the world of the Web Viewer and Javascript and it's quite refreshing what you can do and in such a short time. This video walks you through the process of setting up a Javascript library called Datatables. It's a very powerful, and immediately usable UI for working with tabular data. While you can implement the same features within FileMaker itself, it takes quite a bit longer to do so.
Is there really any question the PDF file format will be going away any time soon? Personally, I don't think so. And, neither should you. Adobe released their license to the technology in 2008 and it became an open standard for the world to use. Airlines use it for tickets, ticket companies use it for concerts and basically it's the digital equivalent of good old real-world paper for the digital world.
So what does this mean to you and your FileMaker database? Well, if you've got data within your database or you're capturing data in something like Web Direct, then knowing you can merge that data into a form fillable PDF can be invaluable. Especially if you need to put that data into a fixed format - like a PDF!
By running a server side script, and running some freely available software which is super fast an efficient, you can send out contracts, invoices, notices or even event tickets with merged in data from your FileMaker database.
Yes, you can certainly generate a PDF right from within FileMaker using your own data, but there are those situations where replicating an existing PDF just takes too much time. So just merge the data into a form fillable PDF. Plus, it just might be faster than generating it from within FileMaker!
Keeping things private, so only those who need access can access them, has been a desirable situation for as long as people have wanted to keep things private.
The only difference between the invention of invisible ink and today is trying to keep ahead of those who have the knowledge on how to access what you're trying to keep private. It's the eternal game of cat and mouse between those who seek to access what they shouldn't and those who want to keep those people out.
Within FileMaker, we now have the option of using the FileMaker 16 added Crypt* functions. This functionality, formerly only accessible through plug-ins, can now be used to securely encrypt your data within regular text fields. There's some terminology and understanding that needs to be paired with using the provided functions in order to make sure you're staying truly as secure as you possibly can when using them.
This video provides the information needed to understand what that terminology is and how to securely encrypt private data within you own FileMaker solutions.
While FileMaker may promote the low-code/no code aspects of FileMaker Pro, there's a lot to be said about knowing how to design a great system as opposed to thinking you'll end up with one by default. Especially, one which will perform under load and scale to the degree which FileMaker can.
This type of knowledge is learned and simply won't come out of the box when you just start adding fields to your database. If you need to store images, or any type of heavy media, then it may not be a good idea to carelessly start throwing container fields into your tables. In fact, there's a whole bunch of details to know about FileMaker and how it transfers data on a record level basis. As well as knowing what can be done to optimize your storage of container based data.
While you'll want things to be easy for your users for adding media, and you'll also want to build a system which will be easy to maintain and update. That's what this video is all about. An optimized approach to container storage and making it easy on yourself when you're going to be working with these types of solutions in the future.