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
In the world of software development, there are few tools you simply can't live without. A debugger is the first which comes to mind; because no one gets their code exactly perfect the first time. Plus, it's always a matter of figuring things out until they work as expected or desired.
There are also those "other" tools which you can't really live without. ESPECIALLY, if you're working with a solution file which was created by someone other than yourself! When you need to discover what the heck was done, how, (and possibly why) then you absolutely need a tool like FMPerception.
In this video I showcase the FMPerception tool from Proof+Geist and cover what I think are the essential things to know about using the tool. True, there is way more to the tool than can be covered within a single video, but I do my best to give you some solid insight into using it.
Oh the pain of a slow rendering layout! The other day I came across a painfully slow layout which was literally CRAWLING. It reminded me of one of my own situations where I needed to create a solution for some type of creative data input. This, of course, was based on FileMaker's input limitations between two types of fields.
The choice of using a Drop-down list over a Pop-up menu field style was based on the type of input being managed. I didn't want the forced interaction of having to click, as is the case with a Pop-up menu. I also didn't want the whole menu of options, which were a lot, covering the whole screen. I liked the shortened option list presented with a Drop-down list.
I didn't, however, like the fact that a Drop-down list allows the user to simply input arbitrary data. I HAD to have the user make a selection from the list and wanted the shorter Drop-down list presentation. So, I set about the task of addressing the biggest issue first.
That issue was that normalized data uses your primary and foreign keys (id values) and NOT what you typically want to display. You want to display the associated human-readable value. In FileMaker, this almost always requires the use of two layout elements. One to store the data and another to display the data. The trick was figuring out how to make the Drop-down list do this - and make it fast! Hence the solution you're going to be viewing and experiencing in this video and technique file.
Every once in a while you need to store something with an extra bit of security. Maybe it's a password or some super secret text with a winning stock market strategy. Whatever it is, you don't just want to rely on the authentication, privilege set and possible EAR (encryption at rest) on the file.
You want to store the data itself with even that much more security. By encrypting it with CryptEncryptBase64() of course! The trick is this. How do you capture that data, before it's written to the database file and then store it securely.
And, beyond that, how do you provide the user with an easy way to get the information back out? Well, in this video and technique file I present a single script which handles both directions of the encryption and decryption which is very easy to associate to any given field. The user has convenient feedback that the data is secured and can get what they need when they need it.
Need that extra bit of data protection while still providing the user with an easy-to-use interface? This video will provide you with the details and know-how.
This is Part 2 of a series about using the DataTables JavaScript library in order to simply pull data you wish to display and doing so within a Web Viewer.
While standard FileMaker Portals present one of the easiest methods for showing related data, it's now a viable option to simply use a Web Viewer to present data to the user. With the bi-directional support of JavaScript within FileMaker 19 and higher we can take advantage of what JavaScript does best - being fast!
In this video we focus specifically on the initialization and interaction between a Web Viewer using DataTables and how you can add buttons and features which make using DataTables a joy within FileMaker.
Portals and list views represent one of the biggest reasons for using a database for managing data. You can view the data in a myriad of ways and FileMaker provides the tools to modify the views quite easily.
FileMaker's list view happens to be the most powerful when compared to portals. We don't really have the same feature set presented within a portal. Using a portal it's an all or nothing approach to sorting by default and you can't really search the portal contents. You can certainly hack in some method of controlling the sort and the old standby of simply adding new copies of the same portal, just sorted in different directions, has always been a go-to workaround.
Well, has the time come to simply abandon your portals? What?!?!! Abandon portals? Is that even possible in FileMaker?
Actually, it is, with what FileMaker now offers with bi-directional support within Web Viewers, it may be more viable than you've ever considered. In this two part video series I show you exactly how easy it is to simply retrieve some data, then present that data within a web viewer. Essentially, replicating a portal - except for the constant data connection.
In many ways, this has become a prime opportunity to choose either a portal or web viewer. The days of always using a portal may have come to an end. But, I'll let the video speak for itself and you can choose if you want to leave your portals behind in favor of what can now be done within a web viewer.
What's the easiest way to format a FileMaker date, time or timestamp value? Using a custom function? Maybe...
In this video, I'll show you a unique trick for getting a formatted date, time or timestamp value without using a Custom Function or any of FileMaker's Date or Time functions. Of course, I'll also provide you with one of the better custom functions for formatting date/time/timestamp values.
The custom function in this technique file handles pretty much all possible variations of date/time formatting and this includes ordinals such as 1st, 2nd and so on. If you're dealing with any type of output which requires a date, time or timestamp then make sure to give this one a watch.
Anyone can just throw everything they need within a portal. Adding a new field? Just throw it in the portal. But WAIT! The question is "Should you?". The fine art of determining what should end up in your portal is based on how the data and/or actions are being referenced/used.
Is the frequency for editing the data high or low? If it's low, then maybe the user doesn't need field access. What is the frequency of record deletion? Low? Then, do you really need that obvious red trash can icon on every row? How about supporting common keyboard navigation such as using up and down arrows?
These are the types of things you'll find addressed within this video. A lot of really nice tidbits of inside information with regards to working with portals.
Value lists are one of the fundamental building blocks of any good UI built on top of a database system. Providing users with a preselected list of options to choose from helps the data entry process go faster and - is - just easier.
When using value lists, there are times when you need to limit the number of selections of any given value to being used just once. You may also need to enforce that one of each of all possible values is used.
In this video, we tackle both situations by enforcing mutually exclusive values. The user can pick any given value only once and they must use all possible values. While this is what's implemented in the technique file, it's not the limit of how you can use what is taught. You can, of course, modify the technique file to accomplish whatever you need regarding the selection of unique values. It's the tips and tricks you learn along the way that improve your FileMaker development skills.
Being able to develop locally, as if the data and the server was right there on your local machine provides a nice advantage. You know how the solution will work when hosted, you can develop and test PSOS scripts effectively, and you're generally protected from client crashes. Plus, you're fully mobile if need be - it's all on one machine.
This is where hosting your FileMaker solutions locally becomes a big advantage. This video showcases what I consider to be the Big 3 of local hosting. 1) You can install FileMaker Server right onto your local machine within the local OS. 2) You can run FileMaker Server within a virtual machine or 3) you can now use Docker locally to host your FileMaker data.
No matter what you choose, it's beneficial to emulate that server environment and host your data locally as you develop. This video will provide you with some of the details about making that happen and which one you might choose to go with.
In the process of creating a simple media archiving database I found I had used the same skill twice because of how FileMaker returns data from certain functions. Hence, I decided to provide you with my simple little start to a Media Archiving solution.
Simply, it asks for a folder, then pulls the paths to all files from the selected, and enclosed, folders into the database. It's really a pretty simple thing because it's managed with one simple function from the BaseElements plug-in.
However, not all simple things are that simple. There are many things you need to account for when importing something from an external file and how you go about addressing things like prompting a user for a required plug-in. Regardless of whether you're needing a media archiving solution or not, there's always something more you can learn about working with FileMaker in order to accomplish your desired goals.