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
Place a field in the Header area of a list layout and use Preview mode. You'll see the first record from the list view. Place the field in the footer and you'll see the last record. So you have the first value (text or number) in the header and last value in the footer. What happens when you want both?
It's just like a phone book, it's Beauty thru Burglar or 90210 thru 92556. Showing the range isn't as easy as you'd think. First you need to know the Mod() function. This video teaches you how to make it happen. Plus, you get to learn how to make alternating rows in list views different colors. Watch now!
It's one of the most annoying aspects of using a portal for navigation. It's called Portal Pop by developers, and it's what happens when you click outside of a portal row. The portal pops right back to the first row of all its displayed records. Would you like to solve this problem? With FileMaker Pro 7 you now can!
In this video, I cover a number of features found in FileMaker Pro 7. Learn how to use the Let function. Learn how to pass multiple parameters to a script. Learn how to stop the portal pop from messing up your user interface. It's all inside this one video! Note: If you're still using FileMaker Pro 6 there is also an included Version 6 technique file!
You may have seen this problem before. You want to provide a popup list and you also want to normalize your data. You make the jump to using a join file and numerical ID key values. Then you run across the big disappointment where your value list displays as
3 Cat
1 Dog
2 Lizard
Users don't make choices based on the numbers, but FileMaker insists on using them with normalized data. You just want to show Cat, Dog and Lizard without the numbers in the value list. Well, fix what FileMaker should have done properly in the first place. With this powerful FileMaker 7 technique you'll quickly know how!
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!