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
With the release of FileMaker Pro 7, a number of new functions were added to the growing roster. One of those functions was the Evaluate function. This one function allows us to dynamically generate any type of FileMaker function and then evaluate this on-the-fly.
Using the example of merge fields for either a merge letter or email, we can showcase how this technique works and why it's so powerful. In this video you'll also view an entertaining, if not useful, solution which will dynamically color the various parts of the English language.
It was just the other day when I was scripting loops for processing a range of records - you remember writing those loops, don't you? But then it occurred to me, (without talking to my mathematician friends) if I knew about the Mod function what would Div do for me and my range of records? As is usually the case, math was the solution and I finally realized what it meant to my files.
Math may not be my strongest subject, but having that "Ah ha" moment sure does feel triumphant. This video may help you with understanding the math around the records in your found set!
FileMaker's new auto-enter enhancement makes all kinds of things possible. One such task is that of making the note taking process that much easier. Building on the success of the previous method of auto building notes, this new approach will work within one field.
Database users can simply select into the notes field, start typing and never worry about lost notes. Each new note is added to the growing list and making changes to those notes can be controlled as desired. The added feature of supporting console-like commands makes this note taking solution that much sweeter!
This video tutorial will walk you through the concepts and process of using sessions to facilitate the user environment in your FileMaker solution. In this particular segment of the Scheduling Application series, I streamline the week view and alter the database to present colorful representations of calendar events.
When dealing with events in sequence, such as those filling specific time slots, the big question is whether the record you are on can see the other records around it. For example, if the record for 1:00 PM knows it has the event of "Take kids to school" - how does it know what's happening at 12:30 PM and 1:30 PM? Fortunately, you don't have to wonder - I show you exactly how to do this!
This video covers the details of using a default ("fake relationship") in order to extract the values you need for a value list. While working on our Scheduling Application we've added the great feature of being able to Quick Add an appointment based on the open time slots. What we need now is the ability to filter all the time slots, within in a 24 hour period, down to those that apply to the work period and eliminate those events which have already been scheduled.
Learn how to manage user preferences and also make things easier for development. I show you some of my best tips for a better development environment. Watch this video and you will learn more about FileMaker Pro!
When presenting information within a portal, you'll find your basic options of showing related fields and filtering based on simple relationships - or you can customize your portal, and present information in much more selective method. Using a custom filtering technique, you can filter out any information based on selections made from one or more popup menus. There's also some other tricks you can use to show more information than you have space for!
Watch this week's video to learn more about some powerful portal presentation techniques. You may also find some value in using the provided file which helps manage your collection of credit cards.
Email is obviously so popular because it provides one of those basic needs by humanity - communication. So the question is, "How do I send email directly from within FileMaker Pro?". Well, there are a number of options available. One of the most common is to use a FileMaker email plugin such as those from CNS, Dacons or ACME Tech. However, there are free alternatives as well. The trick is getting down and dirty with all the geeky know-how. Using a free plugin named shell, we can send email from within FileMaker Pro. This special report will teach you all about the details you need to know when considering email as part of your FileMaker solution!
Because FileMaker is so flexible with how a file can be developed, it's not always easy to know where - or how - to start the process. On top of this, you have the numerous features which can be added. Which features fit your situation is all about knowing what can be done.
This video article walks through the process of starting a Companies, Contacts & Details database - but doing this in the most efficient method possible. The benefit to what is taught in this video is learning how to optimize your data storage. Acquiring the "optimized data mentality" and applying this to your set of skills is something that comes with practice and time - but getting a jump start on the process is always a great way to go! Watch this free video to learn how.
It's a FileMaker developer's dream to trigger a script based on any user action. This includes menus, moving in and out of fields, selecting popup menus and lists, or trigger based on the results of a calculation and more.
Well, FileMaker isn't quite there with providing an event model for controlling user interaction. However, it is possible to cause most of these types of events to happen. Using a free and stable plugin, you can trigger a script based on a popup menu selection or the results of a calculation. This makes it possible for our Scheduling Application to load the details of an event when selecting from month view. Even better, I've added a new feature called QuickAdd. This presents all of the available appointment time slots so an appointment can be quickly added. This is great for a Dr.'s office or similar profession where appointments are based on time blocks.
Learn more today by watching the video! Not a subscriber? Watch the preview to learn what we're talking about.
FileMaker, like most software applications, requires a certain level of knowledge to master. When it comes to creating the month view of a scheduling application, how can you get away from creating 42 unique relationships? One for each of the possible days in any given month of a year. Can it even be done? Of course it can!
Creating the month view in our scheduling application is simply a matter of using a variable portal. The variable portal technique is used to force a portal to show information in the format you desire. Beyond that, it will vary based on where you are at in the interface or based any other piece of criteria. Watch this video as we fix some of the loose ends and implement the last of our three critical views!