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 know how to merge customer information into a letter. Working with text is easy. But what about graphics? How do you integrate a graphic with printed text? The answer to this question can be found in this week's video and example files.
Learn how to integrate a graphic image (example files use a signature graphic) into a form letter that is printed. Mastering this technique will allow you to position graphics within the content of a text field in any location you wish.
Files can be converted and used in Version 7
Searching a database for information is probably the most common task performed. When it comes to searching, not everyone reads the special tips or advanced search techniques. This means when users want to search for a single piece of criteria, across many fields, they may not know about creating multiple requests. Well, now you can provide one global field for the criteria and the rest is handled by a ScriptMaker script.
This week's video show you how to use Single Field Searching in your solutions and also provides additional information about how this technique translates to FileMaker Pro 7. Learn about some of the new functions with this instructional video and files.
Following up on the previous week's video about getting started with FileMaker Pro 7, this week brings you information about the overhauled security in the new version. I also cover learning about file references and how they promote a degree of separation between data and interface. To wrap it all up you'll find information about the major changes in ScriptMaker.
If you've been wondering what's new in FileMaker Pro 7, then this video article is for you. Discover the dramatic changes in this powerful end-user database system. Not only has it moved from a structure of many files to a single file with multiple tables, but it now boasts a new relational graph that allows you to build your solution visually.
Check out this free video to find out more about this powerful upgrade.
You've worked in FileMaker for a while now, and you've figured out that managing value lists can be a hassle. Especially, if you're the one to add a new value list each time the solution needs one. What if you could create a system that would allow admin users to make as many value lists with as many values as they want? Even better! What if you could allow them to assign these user controlled value lists to whatever fields they want - and do it from within your own FileMaker interface?
Want to know more? Watch this week's video to learn one of the most powerful methods for managing value lists!
One of the common interface controls in interface design is known as a Tree View. Unfortunately, FileMaker doesn't offer this control, as there's a lot to deal with when you're talking about hierarchy. However, you can accomplish the basic principle with a Simple Portal Tree.
This technique will allow a user to select a portal row, and have associated sub items connected to that row reveal themselves. This is useful for hiding and showing information within a dynamically updating portal.
It's a fact of life. Sometimes, some users change the wrong data. Keeping track of these changes is necessary in a number of situations. While FileMaker Pro doesn't offer the familiar rollback features you find in SQL systems, it is possible to automatically track the changes made to fields.
It's all about knowing what was in the field before the change and who made it. With the addition of a few fields, calculations and one relationship you can have as much field level tracking as one could want. Watch this video for all the How-To!
There are many methods for providing access to smaller sets of possible selections. You can offer popup lists or direct manual entry. You can start with all possible options and narrow down or you can start with no options and make selections visible after initial entry.
Sometimes you want to allow multiple selections so a user can control how a portal will filter. This week's video covers a number of the possible options for filtering a portal.
Getting what you want out of a large amount of text only requires you know where to start and when to stop. It's moving it into the right field that's the problem. Fortunately, with this video and the example files you'll put a stranglehold on understanding of how to parse text into the proper target fields.
If you ever wanted to pass structured information between your database and email, html or any other structured format then this video article covers what you need to know.
Sometimes, just thinking about the best way to organize and classify your data is enough. Do you classify, organize or both? Is there a difference?
This video and example files walk though the process of learning when to classify, when to organize and when to do both. Get a better understanding of compound multi-keys and how the structure of data doesn't have to match the presentation. You don't always have to use a new file to store the information!