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 Forms
- 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
- Webhooks
- Windows
- XML
Our Library of Videos
Within FileMaker, the methods for presenting related information extend to calculated fields, web viewers and portals. The most obvious of these is portals.
Portals allow you integrate icons, graphics, buttons, fields (of course) and work in all kinds of user interface tricks. One of those tricks, from earlier versions, was creating a fixed sized portal and then paging through related data a group at a time.
Show ten rows and you can page through easily because you know how many rows there are. What happens, however, when you have a variable number of rows? You need another mechanism in order to determine the row count and be able to page through the data.
So what if we add the fact that FileMaker 12 actually allows you to turn off the scrollbars on a still scrollable portal? Wouldn't that be cool?
Well, give this video a view and you'll quickly find out you can do more than a few cool tricks with this new knowledge!
Your FileMaker Go app is ready. You're excited that FileMaker Go 12 is free. You point your customers or users to go download FileMaker Go from the iTunes App store. Now you simply need to make the process of getting into that one specific database just a little bit easier. How about a Home Screen launch icon? Darn, FileMaker Go can't do that... but wait.
While it would be great if applications could generate their own launching icons, I personally couldn't find any app which would create icons for you. I do use an app which allows you to specify custom urls named Launch Center and I'm also familiar with using a url redirect. So, I married the two ideas together.
Knowing that Mobile Safari allows you to create Home Screen icons there were only a few little hurdles to make this all happen.
This video provides the information and insight you need in order to make Home Screen launch icons for specific FileMaker Go databases. With the concept of syncing, and using a local database on a mobile platform are taking off, it only makes sense that you'd like to customize this experience as much as possible. Watching this video will give you the know-how and tools to make it happen!
There's so much data moving around daily on our networks (including the Internet at large) that it would hurt your brain to even think of how many bits and bytes move over the air and wires.
The methods by which all this data is pushed and pulled around is all a matter of protocols, ports, packets and more. For us mere database developers, we need to know the various methods for pushing and pulling some of this data into our solutions.
This is where XML/XSL (and XPath) come into play. While importing and exporting into known structures, such as csv or tab delimited, is just fine when you have 100% control of both the sending and receiving end, things can get a bit more complicated when you have to start doing a lot of data massaging and you don't control the whole process. Cleaning up messy data can be far less worth your time, in the long run, as opposed to picking up a new skill or learning a new format.
While XML isn't anything new, it may be new to you and knowing how to use it, along with XSL and XPATH is one of those things which almost every developer may come across at least one - if not a few (or many) times in the life of all the solutions they may touch.
So, the trick is to pick something both fun, realistic and useful in order to learn how to import XML data into a FileMaker solution. Watching this video will provide you with a level of confidence to continue your education and push forward with using this ubiquitous encoding of data. If you have an option of doing bulk imports via tab delimited, csv or xml my hope is that you choose XML if you don't control the whole process. This video will show you why!
It's finally here, and it's a power tool you simply can't ignore. Yes, you can still build a FileMaker solution the same way you always have. With lots and lots of table occurrences to make FileMaker do exactly what you want it to do.
The problem, however, has always been information overload. As once the solution gets to a certain point, it becomes increasingly harder to decipher. This is due to the fact that FileMaker has always been a tightly bound environment between the data and the presentation of that data (the UI).
The new ExecuteSQL function presents a wide number of opportunities to SERIOUSLY (note the all caps!) reduce the complexity of both your relationship graph and the content of scripts.
The best way to visualize this is thinking of an apple tree. You can always start grabbing apples from the bottom. As you need apples from the top, you've got to come up with something to get you higher. Maybe you climb the tree. Maybe you see a board lying around and can lean it against the tree. Maybe there's enough boards to build a ladder. This is like adding table occurrences to achieve the end result.
Then again, wouldn't it be nice if you simply already had a ladder? This is the situation with ExecuteSQL. FileMaker now provides a tool which allows you to pull out any data (i.e. grab any apples) you wish at any time. While this has been possible for many years with plugins, some developers just never felt the need to venture into the land of SQL. Things can break and you have to learn a new syntax.
With excuses about SQL now gone, because it's baked in, - at least for the SELECT statement - you simply must start taking advantage of it.
This video is a great example of just how much this new function can reduce the complexity of your relationship graph - and it's only one example of many. Need to get your head around this new functionality? Take a ride on the SQL train!
For some developers, the Let function can be a confusing tool. However, without it, FileMaker calculations would be the eternal mess they used to once be.
The Let function is pretty much a critical tool (in my opinion) that all FileMaker developers should know and use. If only for the reason that it provides the ability to self-document code by using human readable variables.
This video provides a great walk through of how to get started with the Let function and more importantly, explains why you should be using it if you're not!
Personally, FileMaker's custom menus had always been an afterthought. Especially, when it came to creating my solutions. I've always considered their implementation pretty poor and there are a lot of dialogs to click through to set them up.
However, once I figured out a system which really worked for me, and kept my code organization pretty clean, I started adding them as part of the initial setup for new solutions.
In this video, I go through how I use custom menus and why you'll want to consider using them more heavily. If you've not used them before, then you'll be presented with all the information you need to get started.
If you have used custom menus, then you may find useful tips about how to optimize their use and making things more dynamic.
Either way, this tutorial video will present you will all the fundamentals about using FileMaker's custom menus.
People do good things - and - people do bad things. If people only did good things, we'd never need security, because nobody would fear what would happen when the bad comes out.
Of course, mistakes happen as well and killing a bunch of mission critical data is something you certainly want to avoid. So, whether you're worried about the bad things people do, or the fact that people simply make mistakes, you'll need to add some security to your database.
This video covers the ins-and-outs of FileMaker's security model and how you'd go about using it. Coming in at around an hour, this is pretty comprehensive, but doesn't cover every tiny detail.
If you've never worked with FileMaker's security and everyone is simply accessing your solution with the same username and password, then this video should give you everything you need to get started. It also provides enough information to implement a pretty complex security setup.
Leave comments on the video at YouTube
Full list of new features on FileMaker.com
More features, pricing and pictures at FileMaker.com
Can't get enough new FMP12 information? Take a listen to this podcast about FileMaker 12
Before you ever write a single line of code, within FileMaker or anything else, your primary goal should be maintenance and clarity. If you can't understand your own code later, then no one else will either. If your code is a pile of spaghetti, it will be extremely hard to maintain - and - just not that fun.
The principle of DRY (Don't Repeat Yourself) coding is such that, you can make sweeping changes in singular locations. This makes your code more maintainable and actually more fun to work with. It also becomes more "portable" in that you can more easily copy and paste it into other solutions.
This video presents the concept of DRY coding as it relates to FileMaker development and how to approach your logic and design before you simply head on off to the next big script or feature.
One of FileMaker's great advantages is that you don't have to be so specific when creating your fields. Specific in terms of how many bits and bytes you're going to store in every field. All you really need to do is pick the field type and then set any conditions you desire.
However, when it comes to conditions, you need to know what can be set and how to do so. There's always those hidden little tidbits such as using the Length() function on a container field in order to get the byte size of an image.
Then you also have issues related to image or file storage and making sure things either are (or aren't) pushed into the database and are stored as a reference instead.
Enforcing your data rules by using validation and script triggers are also specifics you need to know about within FileMaker Pro.