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
One of the more confusing aspects of developing a database is how to best structure the data. Over time, this part becomes easier and easier. Once you work on enough projects, you get a "sense" of how data should be structured without having to think too hard.
However, if you're new to FileMaker, or even if you been working in the software for a number of years, you may need those additional insights to help make the solution work. In this video, I cover a very common question about the difference between data structure and data display. They seem like they're inherently tied to each, yet, nothing could be further from the truth. The fact is, how you display your data, is completely up to you. There are so many options possible, that it's hard to choose. Fortunately, watching this video will help you with that decision!
While growing up, you were either bullied or you were the bully. Sometimes you were both. Fortunately, later in life, we grow out of these stages and we get to push something else around - text. Ok, enough of the childhood memories and on to what this video is really about.
In this video I walk through some of the more powerful aspects of manipulating text to achieve the output you truly desire. If you've got the need to parse, merge or otherwise wrangle any amount of text into something that suits the requirements, then you'll find that you have multiple options. You can use a 100% FileMaker method or you can employ the use of a powerful plug-in. Regardless of what you choose, it's important to know what's possible and how to accomplish it. Watch this video today and start to bully some text somewhere!
As I've said in the past, "If you've got the time and inclination, learn how to use regular expressions. It's one of the most empowering tools you'll use for any text processing." Of course, you may not have the time or immediate need to learn this age-old programmer's technology. Maybe you don't see yourself as a programmer but rather a database developer.
No matter how you see yourself when working with FileMaker Pro, there's one thing for sure. You WILL have the need to process text. This includes appending, extracting and all kinds of 'ing' words! In this video I present a very powerful set of custom functions which can extract text based on using regular 'ole FileMaker functions. The concept is very powerful and can be used in a variety of ways. Hold on to your hat as we take a look at this powerful custom function from Fabrice Nordmann!
Every once in a while, you come across a technique so useful, it's simply too hard not to include it within every one of your solutions. This may be one of those techniques. Ultimate Styled Text Merging applies to any situation where you wish to provide the user with the maximum level of text styling control - of any field data.
This applies to information viewed on-screen, when printing on labels, envelopes or within a form letter - or even if you want to pass the styled text through an HTML email. This video and technique file will provide you with all the information needed to offer both the easiest and most flexible method a user can use when determining how field data should be presented.
Using plug-ins within FileMaker has always been a tricky proposition - especially if you ask enough developers. The biggest downfall is the price of licensing, when you consider the number of copies of FileMaker you need to license for.
The upshot is undoubtedly the increase in functionality; which allows you to solve the problem. In my personal use of plug-ins, I opt for the path of which plug-in(s) offer the most functionality. My favorites have been zippScript, for script triggering, and the shell plug-in for everything else.
With the release of this video, I'm pleased to introduce the one plug-in I'll almost always have installed. SmartPill PHP Edition from SCODIGO is likely the one solution to most all of your FileMaker wishes. Grab a copy today and start solving the problems you never thought possible in FileMaker!
It seems so simple, when all you want is to show the data in a particular fashion. Such as showing a sub-summary amount when your data is sorted in a list view. All you really want to know is how many blue items there are versus all the other colors. To accomplish this with a portal, you need multiple relationships with multiple table occurrences. To accomplish this in a list view, all you need is a GetSummary() function right?
Well, there's a bit more to it than that, and fortunately, you'll have this video to help guide you through the process. If making things look great in your database is something you enjoy, then I'm happy to provide you with one more technique to make that happen!
While working on a personal project to create a poster of the various FileMaker functions, I stumbled upon a great new trick for use with FileMaker 8.5. While this particular little trick did require 8.5, the whole solution presented in this video does not.
If you've ever had the need to automate the publishing of data from within your FileMaker database, then watching this video will move you one step closer to accomplishing your goals. With the information covered here, you can start to realize your publishing goals, within a short period of time!
This video tutorial provides a great solution for any calendar or scheduling application. I found this technique while reading Mikhail Edoshin's excellent blog about his FileMaker solutions. This technique is about leveraging the auto-enter fields more than you may have in the past.
So, while standing on the shoulders of giants, (Mikhail and Alexander) I was able to implement an enhanced version for creating an excellent date-based start/duration/end type of technique. If you have the need for any given field to exert control over any others, when changed, then watching this video will teach you what you need to know!
Shortly after FileMaker, Inc. released the new FileMaker 8.5, I "rushed out" and purchased, (if you consider buying a copy online "rushing") my copy of the new version. The next thing I did was use one of my template files to start going through the new features. While the list isn't a big one, the few features they add each time, especially those geared towards developers, makes the environment that much easier to create solutions.
Without having spent too much development time with each feature, I wanted to bring my findings to the web so you'll feel more informed. There were a few features which weren't immediately clear, such as extracting HTML from a Web Viewer, and others with immediate benefits and possible pitfalls! Take about 50 minutes (yes, I know that's a long time) and watch this video to see my first impressions of FileMaker 8.5.