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
Folder Trees, as they are commonly known in an interface designer's vocabulary, are one of the more complex techniques to add to a database. You need to have a solid understanding of the Parent > Child relationship between records and understand how one series of inter-related records is different from any other series - all within one table. Oh, and there's that new aspect of FileMaker Pro 7 that allows for recursion within calculations.
This video presents a very powerful technique which teaches you how to create and use an infinite hierarchy of records - well, maybe not infinitely, but a whole bunch!
Search FileMaker help for the word "multi-key" and you'll find one page that includes it. Yet, showing what you want within a portal hinges on knowing about multi-keys. This video will show you two different techniques that use a multi-key to force a portal to reveal what you want.
The first technique uses a portal to show search results of a find. The second uses a portal to page through a large set of records. Managing large datasets within a portal can be a hazardous task in a large database, the network has to transfer the whole dataset to the FileMaker client. But thanks to Script Parameters and the new Let () function we can manage those thousands of records by showing smaller subsets. Watch this free video to learn how it's done!
There are many ways to present information. Some users are comfortable with using Find mode to look for what they want. Other users tend to be a bit more timid and look for selections they can make on screen. This week you'll find a great technique for filtering a portal. It's called Intersecting Groups and it's a great way to narrow down a larger group of records.
Using a Passwords database as an example, you'll learn how to implement and use this technique in your own solutions! You can never know too much about all the ways to filter a portal in FileMaker Pro.
To an experienced FileMaker developer, the process of duplicating a record which may have related records, such as an Invoice order, may seem trivial. The challenge is doing so without any extra fields, relationships or table occurrences. Doing this all within one script and making that script portable, so you can use it in any of your other solutions is the goal - or maybe you just want to learn how to make it happen in the first place.
Watch this video for all the information you need to successfully duplicate a given record and all of its related data.
It's all a matter of who can do what to which records. Field access can be controlled completely with FileMaker 7's new Accounts and Privileges area. But learning how to limit what users can do is only one part to the puzzle. If you really want to know how to control what users can, and cannot do, then it's validation that you need to become familiar with.
This video article, and example file, cover the concept of locking a notes field so only the creator can determine when the field can be modified by other users of the database. If you want a better understanding of accounts and privileges and how to limit who can make changes to which fields then this video has what you need.
We all think we know FileMaker pretty well - well, some of us know there is always more to learn. There's always that little trick that makes developing that much easier. In this video I take a look at my Top 10 tips for doings things better while working in FileMaker Pro.
You'll also have access to a great new tool. My FileMaker Pro calculation tester. The file is a run-time solution so you can run it at the same time as FileMaker Pro. This makes testing your calculations a breeze. Check it out right now, the video is free ready to be watched!
Some FileMaker developers never even touch the instant web publishing feature of FileMaker Pro - I know, I used to be one of them. In the past, IWP wasn't known for its stellar performance and awesome visual translation to the web, but FileMaker 7 is a different story.
If you're one of those developers I speak of, or you've always wanted just the right amount of information to get started with IWP then this video has what you're looking for.
This may not be your power developer technique but the simplicity in IWP is exactly what fits many a situation. Get all the details necessary to start web publishing today!
Yes, you're right! FileMaker can save a predefined search - it does this right inside ScriptMaker. You can even specify the search criteria. But answer this one Smarty Pants. How can your average user perform a search, then save that search for later execution? Do they have access to ScriptMaker? Probably not. Well, they could use this technique to save their search!
This is a power user's technique which allows any user of the database to create a custom search, complex or not, and then re-run that search as many times as they want - all at the click of a button. Watch this video to learn how to store user search values then rebuild the search on demand. This is the power your users are begging for!
There comes a time, when every young database must provide a feature or two. If one of those features is allowing users to save their results, then this video was made for you. When saving a found set, it's something the developer must do, to allow the system's users to remember their own views.
Watch this week's video for information and insight about many powerful techniques useful for saving a found set for later retrieval.
Try explaining this search request to your average user of a FileMaker Pro database. Find every person who's last name starts with "mac", contains "cle" in either the first name or last name, lives in one of these nine zip codes, 93015, 93430, 95966, 95230, 91030, 93410, 91383, 95212, 91405, and has a particular type of pet.
Ok, so the request seems odd, but it's an all too common problem when it comes to a complex search. Do you know how to automate a multiple request based find? Do your users? Probably not. That's why you need to learn and use this technique to make FileMaker's Query by Form method of searching much more powerful!