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
- Solution Architecture
- Sorting
- Spelling
- Spreadsheets
- Startup
- State Management
- 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
When FileMaker 7 was released, there was a new thought in town. That thought was "Ahhh, great, now we can separate the interface from the data." While this angle of attack was perfectly doable, it wasn't as ideal as some first thought.
It wasn't until FileMaker 8 came out with its support of variables that a lot of the "cruft" in a FileMaker solution was starting to be cut out. For the adventurous few, who used the separation model, sometimes shortened to SM, the advantages of reduced corruption potential and much easier updates were a big boon to using this approach.
Even I, was hesitant to use this approach because I knew of many "techniques" which were accomplished within just a single file. There is a very "filemaker way" of doing things when you've done them that way in the past. Letting go of this mindset, is something that requires a leap of faith when you've not used a separation model before. That's where this video will help resolve (hopefully) a lot of your [fears||doubts||concerns||questions] (pick a word) about this approach. This video will provide you with information about how to make things work.
As always, feedback is welcomed!
In continuing with what should be a popular series, I talk about how I go about creating some of the graphics used in the FileMaker Invoicer template. Taking network transfer time into consideration and learning how to get the most optimized graphics is always a valuable skill.
Even if you're not a Photoshop pro, there are many applications which allow you to create flexible graphics for your FileMaker layouts.
If you're the type who's color challenged, then have no fear, there are both commercial and free tools that make this part of the process very easy. While I'll likely cover other aspects of graphics throughout the series, this is a great place to start if you've not worked with the graphics end of the process.
The title of this series may be a bit misleading. In these videos, I don't really start at Zero. In fact, I make a number of assumptions about what you may already know. You know what a field is, don't you? How about a Layout? Of course you do! What you need to know how to go about building a solution, not how you open ScriptMaker and place steps within a script. So here's the approach. Build a fully usable solution and give the viewer every single tip and trick you can think of as you build it.
Even an experienced developer never knows it all. There's always something more to know. It's how you tackle the problem, not how you use an If() statement. It's an amazing thing really. You think you're good, maybe even great, and then you find out what you know is only a portion of what's possible.
This is the first video of a proposed series of videos that walk through the whole process of building a FileMaker solution from zero to awesome. No stone, or layout, is unturned.
Whenever a new version of FileMaker is released, we always see a flood of great techniques. Going back to FileMaker 8 and combining a new feature from FileMaker 9, gives us the opportunity to create the best looking and fastest sorting portals possible.
The sorting portals portion of the video is free for anyone to watch in the Preview edition. If you're a paid subscriber then I have a very powerful addition to this technique that can be used in other areas of your FileMaker solution as well. It's my Universal Sort Arrow.
The implementation, while a bit complex underneath, is very flexible and allows you to use one single field for all of your directional sort indicators on any field being sorted.
The technique file showcases just use on sorted portals, but can be extended to accommodate list views as well. Just imagine, one single calculated field for all of your sort indicators. No more graphics (unless you want them) and no more extra time spent on implementation. Once you have this technique integrated it's a matter of seconds to support a new sort arrow for any of your sorted columns!
In 2007 we saw a lot of changes with FileMaker. With the release of FileMaker 9 we gained the very powerful conditional formatting feature and the ability to resize windows with graphics in tow. With each release, FileMaker becomes more and more powerful.
In this video you'll find a quick (well, I tried to make it quick) rundown of many of the major articles covered throughout the year.
There were a number of very powerful techniques which showed up and should be core "know-how" for many of your database solutions.
With the release of this video I'd like to wish everyone a Happy New Year and much luck with their FileMaker development.
While it may seem like a little overkill, it really is possible to save all of the active tabs in FileMaker for each record for each layout for each user. Wow, that's a lot of 'each'es'.
In this video you'll learn how to capitalize on the technique recently shown which reveals how to trigger a script based on record changes. By using the default option of an If() statement, you can save all of the current Layout Data - including all of the active tabs.
The only thing not covered in this video is how to take this technique one step further and storing the viewed state for each layout for each record for each user for each session. How's that for one more 'each'. Enjoy the video and making your tabs stick on a layout by layout and record by record basis!
Triggering scripts, based on user events, wasn't a planned FileMaker feature. It's a side effect of calculation evaluations and the plug-in API. With script triggering plug-ins it became possible to trigger a script based on record opening (editing), record viewing, record deletion, field exit, field entry, field changes, specific times and record commit (validation).
Using these opportunities has created some unique situations for all kinds of new techniques. In this video I use the examples provided by a free plug-in named DoScript to show you many of the above mentioned options. The few that aren't covered can be found as other videos on the web site.
If you too have creative uses of script triggering then leave your comments on the article!
A support question came in recently, in which it was asked, "What is the best way is to generate reports from data in multiple related tables?".
While there are a number of ways to accomplish this, the best way (I believe) is to use a dedicated Reports table.
Here's my video reply to the question.
If you have other suggestions then leave them in the comments area!
Triggering a script, when switching to another record, may be the feature you need when your users should see the right data in the right format. Then again, maybe there's a specific value within a certain field and the user needs to pay attention to it.
Ultimately, there are countless times when you might want to trigger a script based on certain criteria when a record is first shown to the user.
In this video, I walk you through a technique file that shows you exactly how to accomplish this and what to watch for. The implementation might even give you a creative boost for what you can do with this technique.
While FileMaker formally lacks an event model (causing actions based on user events - mouse over, mouse down, etc.), it doesn't mean you can't figure out how make this type of functionality happen. A lot of articles on this site talk about using a script triggering plug-in to accomplish this.
Using a script triggering plug-in, I show you how to fire scripts when selections are made from a Pop-up menu or Drop-down list. Beyond that, the important thing to note is that it's based on any field change. Yes, you're right, it's based on an auto-enter calculation.
The unique feature that's shown in this video however, is how you can use any number of scripts tied to any of the possible options. Meaning a status field can be set to "PAID" and Script X will fire. Change that value to "DELINQUENT" and it fires Script Z. Unlimited scripts to match an unlimited number of options.
Think about all the cool things you can make happen when a field value is changed to a matched target value.