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
You don't always have the screen real estate necessary to show all the data you might otherwise pack into a portal. But that's ok, you can always use a dynamic portal display to show only the data a user chooses to view.
This powerful technique optimizes how you show information within a portal and allows you to maximize your screen real estate. You'll also learn a very easy method for sorting portals.
You're not always in the correct file, within a list view that allows for easy searching. Even beyond that, not all users of FileMaker Pro are familiar with creating multiple request searches.
The easiest solution in this situation is to provide Universal Portal Searching. It's like Google for your portals. The user enters search criteria into one field and results are provided based on searching many fields. Use this video article to learn a powerful technique for searching portals.
Figuring out the sum total of hours an employee has worked for a specific range of dates seems like an easy thing to do. You know how to use the Sum() function but you're finding it hard to break down the dates according to pay periods.
It sounds easy, but it's actually a bit harder than it sounds. A few companies have released plug-ins that generate ranges of dates. But then there's that limitation that FileMaker has with text fields only able to support 64,000 characters. Wouldn't it be nice if you could span across a date range as wide as 1/1/0001 through 12/31/3000? Well, watch the video and you'll learn how to support a range of over 3,000 years!
You've wondered what the Halt, Exit, Resume and Pause options are when assigned to a button with Perform Script. You also need basic password access to lock off certain areas of your user interface. What do you do?
You watch this video and use the associated file to learn about the easiest solution to add secured access to your files. You can lock off areas of your interface, such as configuration and controls or you can limit access to layouts with sensitive data. By forcing the user through a locked process you can exercise the control you know you need.
How do you make calculation code more clean? Have you ever seen the CodeCleaner 3000 for FileMaker Pro? Probably not. This means it's up to you to both write and format clean code.
In this video article I walk through a cleanup process where I take some original code and make it more clean. I remove some redundancy and also tighten things up. Making your code more readable is what this article is about and along the way you'll learn how to work with time values that calculate past 12:00 midnight.
In this video article you'll find information about one of the most fundamental aspects of linking records together to create a hierarchical chain of associated records. Ever wonder how you can keep track of a part that has many subparts in which those subparts may have many subparts themselves? This is the article to teach you.
Watch this video and comb through the associated file to gain a solid understanding of working with hierarchies in databases.
Working with dates can seem like a confusing endeavor at first. But after you know which pieces to go after, you can easily put together your own calendar application or any other solution that requires date based calculations.
This video article covers the essential parts to working with dates and making the calculations work within the realm of user-friendly features. Learn how to date-shift a work week and how to turn a popup day value into a number needed by date calculations.
This video article is a short walk through of a useful technique that shows you how to use key combinations to quickly increment and decrement the values in a date field.
The technique also exposes you to a universal approach to scripting, where one script will function in multiple situations. Learn the power of creating a universal script.
Because a database typically contains information about a wide variety of elements, it's not uncommon to need to interact with other files, and sometimes applications, outside of FileMaker Pro. Prior to Version 6 this required the use of a third party plug-in.
If you're using FileMaker Pro 6 then you have access to a new function called Status(CurrentFilePath). In this video I take a look at maximizing this feature and providing the whole range of services that can be used. You can launch a local file, a file from a shared file server, another FileMaker Pro file on a FileMaker Server, a URL or even open another application or folder. This powerful solution is extremely useful if you need to interact with any other files stored outside of FileMaker Pro.
It's the age old question most commonly asked about a database that manages data from multiple sources. "How do I remove duplicates?"
As always, there's more than one road into Rome, and you can tag duplicates using a script or by disallowing them into the database upon import. But when you need to visually see the duplicates and compare records based on the most recent then you need the easiest and best way possible. That's where this article solves the problem. Watch this video and use the technique file to see how it's done.