
John Mark Osborne shares 20+ years of Filemaker Pro expertise, certifications from version 7 to 17, and insights on scripting, relational design, and reporting for building password manager in Filemaker.
Discover how this FileMaker password manager tutorial is organized for beginner to intermediate learners. Build a single complete solution from scratch while mastering four modes and basic scripting.
Touring the completed password keeper in FileMaker, this lecture shows form and list views, password generation and history, search workflows, printing, and the full data model, layouts, and scripts.
Design the table and fields for a password manager in FileMaker, including a serial primary key, creation and modification timestamps, and essential fields like name, account, password, site, and notes.
Apply consistent filemaker naming conventions with all caps for tables and lowercase fields, use a managed database workflow, and design a layout that scales with screen size via auto sizing.
Select a built-in theme in FileMaker using lamp mode and frame your layout to fit the screen. Import and apply custom themes via manage themes, inspector styles, and layout mode.
Design a form view in FileMaker by balancing header, body, and footer layouts, using dynamic guides, alignment, and merge fields to create a clean, information rich password manager layout.
Master auto sizing in FileMaker by adjusting headers, notes, and fields with anchors and resize behavior in browse mode for a cleaner password manager interface.
Design list and form views in FileMaker, duplicate layouts with clear naming, and use list view to select records before switching to form view for data entry.
Learn to navigate a FileMaker solution using Grip's navigation shortcuts and custom buttons to switch between list and form layouts, with icons, sizing, anchoring, and scripted go-to layout steps.
Learn how to build a password manager workflow in FileMaker that copies passwords to the clipboard, opens websites with a web viewer, and uses calculations and scripts to streamline login.
Frame the layout on open with an open script in file options. Resize the current window, hide toolbars, and maintain a consistent, professional interface for a FileMaker password manager.
Recreate the password manager toolbar in FileMaker by adding new and delete record buttons, navigation controls, and a delete dialog, then test scripts and layout for safe record management.
Learn to generate passwords in FileMaker using the random function with let and left, selecting from uppercase and lowercase letters, numbers, and symbols, to produce a password of any length.
Generate a random password by embedding a character generator into a script, looping until ten characters accumulate in the password field, using set field and concatenate to build the value.
Enhance your random password generator with bells and whistles, adding a show custom dialog before overwriting and using not is empty checks, if statements, and calculation dialog for safety.
Create a password history table linked to passwords via a foreign key, enforce cascade delete, and add a portal to log account, password, notes, and date with newest entries first.
Automatically archive old passwords by replacing the current password and recording a history entry in a related table, using either a same-window or new-window method to preserve context.
Archive old passwords and create new ones in FileMaker using modular scripts, preserving password history.
Hide a password in FileMaker with a concealed edit box from the Data tab inspector, showing bullets in browse mode and preventing copying, and enable placeholder text for fields.
Create a copy password button in FileMaker that copies the password to the clipboard via a script, selects the field, commits the record, and uses triggers for reliability.
Create a preferences popover in FileMaker to customize random password length and characters using global fields, enabling a simple single-user solution.
Implement a show-password preference in FileMaker by adding a global field X password, using a checkbox to toggle between two password fields and hide them in browse and find modes.
Implement database security by setting an admin password, disabling the guest account, and using privilege sets to control access in FileMaker's security manager.
Learn to use privilege sets and extended privileges to control who can view, edit, print, or delete records in a FileMaker file, and apply a data entry set to accounts.
Master extended privileges to access FileMaker features and extend business logic with scripts, including support for multi-user solutions, while configuring web direct, web publishing, and custom privilege sets.
Limit access to external files with the file access panel, requiring the full access password. Favor a single-file design to simplify management while strengthening protection through FileMaker security.
Turn off the auto log on feature and stop saving passwords to the key chain, so users must enter credentials instead of logging in with admin and no password.
Track logons by creating a log on history table and script that records the account and timestamp at login. Hide log on and history layouts from users to reinforce security.
Encrypt your FileMaker file to protect data from password crackers; use an encryption password, and manage single and multi user access alongside admin access removal.
Explore how FileMaker custom menus enhance security by limiting visible commands, creating data-entry and navigation menus, and using scripts to control access and workflows.
Deploy custom menus in FileMaker by using per-layout menu sets in layout mode. Use an open script and privilege sets to switch to data entry or standard menus and test.
Create a FileMaker script called notes time stamp to dynamically format a notes field, appending a timestamp with a colon and two returns, and adjust the cursor for editing.
Build a notes portal in FileMaker by creating a notes table linked to passwords, using a resizable portal to store notes with timestamped records and enable reporting.
Create an adaptive portal navigation button that scrolls to the last row in any notes portal by using a parameterized script in FileMaker, enabling consistent behavior across portals.
Implement a delete portal rows feature in FileMaker by building an adaptive script with a confirm dialog and script parameter, and apply layout tweaks to hide empty rows.
craft a simple find script in FileMaker to search accounts by name or website, using a global search field, custom dialogs, and get found count checks to handle no results.
Enable the allow user abort script step in FileMaker to prevent users from canceling long scripts, ensuring ongoing operations complete, and use modular scripting to propagate the setting across scripts.
Add a category field in FileMaker to classify passwords as web site, application, or e-mail using a pop up menu, and adjust hiding rules and search accordingly.
save the tab order for last to avoid rework as fields change. set order by clearing non-field controls and walking through name, count, password, category, website, and notes; test it.
Organize your FileMaker project by grouping scripts, layouts, and relationships into folders, labeling and color-coding elements, and documenting with clear comments to simplify maintenance and future updates.
Discover free FileMaker resources and paid services, including blogging insights on scripting, relational design, and custom web publishing, plus consulting, training videos, and royalty-free solutions.
Explores related FileMaker courses and videos, including the philosophy of FileMaker, a 90-minute contact/CRM manager, document management, a calendar solution, and password manager tips.
Learn FileMaker Scripting, Calculations, Relationships and Layout Design while creating a password management solution from the guy who actually wrote the book, Scriptology: FileMaker Pro Demystified. With over two decades of experience teaching FileMaker, John Mark Osborne will help you understand tough FileMaker concepts with ease. Beginner/Intermediate FileMaker techniques will be taught throughout this tutorial. In order to better understand every nut and bolt that goes into designing a solution, a single file will be created from scratch. The chosen solution is a password management solution that organizes the plethora of passwords needed in this digital age. The completed FileMaker file at each stage is provided to assist with the learning process.