Learning FileMaker - Practical Techniques

Translate real life scenarios into a database through data modeling and planning, weigh reporting needs when choosing between separate tables or single fields in FileMaker.

Create an open script that runs on file open to go to a layout and hide the status toolbar, using modular scripting and privilege set checks to conditionally show toolbars.

Add dynamic portal rows for addresses, phones, and e-mails in FileMaker, using relationships, names, and script parameters to navigate quickly to the last row.

Discover how to script a print workflow in FileMaker, including a clean button layout, show only related records, subsummary grouping, and page breaks by company.

Explore self relationships in FileMaker by using a tab and portal to show contacts from the same company, excluding the current record and displaying related phones and emails.

Sort portals by a primary flag in FileMaker, using a checkbox label, and apply descending order to prioritize the primary email address.

Learn to use FileMaker conditional formatting with a formula to highlight primary contact info (email) by bolding when primary equals one, with optional color formatting.

Explore recursion in FileMaker by building a custom function that repeats a text input a given number of times using a case-based base case, concatenation, and a final stop condition.

learn how to synchronize modification timestamps across contacts and related portals with FileMaker calculations, using let, max, and case logic to show the latest timestamp.

Create a FileMaker notes field with a timestamped entry system. Build a reusable notes script using go to object, set selection, and insert calculator result with get current time stamp.

Learn to implement a safe delete workflow for letters in FileMaker by adding a delete button, performing existence checks, confirming deletions with dialogues, and updating fields and layouts.

Inspect the linked record by examining the relationship graph and portal keys, explain why John Mark Osborne doesn’t show Billy Adlington, and preview auto enter calculations to fix the issue.

Use conditional formatting to hide linked contacts on each other’s records by making text white and tiny, overlapping fields, with a formula of 1.

Build a FileMaker reminder system by duplicating a history table, configuring date and done fields, and designing a sortable portal with conditional formatting and a script to locate unfinished reminders.