Continue learning FileMaker 16 Scripting, Calculations, Relationships and Reporting 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. Intermediate and advanced FileMaker techniques will be taught throughout the three part tutorial series. 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 an Contact Manager or CRM solution for its familiarity to a wide audience and flexibility of applying techniques to other solutions. The completed FileMaker file at each stage is provided to assist with the learning process.
A discussion of the difference between a data entry layout and a print layout.
Printing a single contact at a time.
Including multiple addresses, phones and email addresses.
Creating a PDF version of your print layout and saving it to a specified location.
Exporting a PDF and attaching it than email without cluttering up the user's hard drive.
Saving a PDF in a user specified location.
Printing multiple contacts.
Appending two or more PDFs together.
Printing a company with all the contacts.
Exporting from a relational database to a flat file structure like Excel.
Exporting to non-standard formats using a looping script and the Export Field Contents feature.
Creating a print layout for the popular 3 by 10 printing label page.
Creating a layout to print number 10 envelopes.
A contact sheet with name and phone number in three columns, organized by the first letter of the contacts last name.
Creating a static merge letter layout.
Creating the interface for the custom form letters.
Mimicking merge fields in browse mode.
The print layout for custom form letters.
Using the Replace Field Contents feature to populate the letter with information from each contact.
Inserting a saved letter template.
Deleting a letter template.
Emailing a merge letter.
Sending a merge SMS text message using FileMaker only features.
Isolating the Mobile phone so SMS messages can be sent.
Sending SMS text messages with a service like Twilio.
Attaching a document to an email.
Tracking the history of letters, emails and text messages.
Tracking history for mass emails.
Adding correspondence history for phone calls and meetings.
Indicating the last contact in an easier to view location that the portal.
Learn how to create a join table to link contacts together.
Removing inactive contacts from the popup menu.
Adding buttons and other interface to the portal.
Creating two portals to display on both sides of the relationship.
Creating a popup menu based on a relationship to hide the current contact from the popup menu.
Removing the selected link contacts from the popup menu.
Dwindling the popup menu using ExecuteSQL.
Dwindling the popup menu using Set Field.
A picker window for better performance over a WAN.
Filtering the picker window with a find.
Making a selection from the picker window and adding it to the links portal.
Excluding the selected contacts from the picker window using Constrain.
Combining the two hidden portals into a single tab.
Reusing the list filter from the picker window in a standard list view.
Debugging is a key part of development.
Fixing the relationships to squash the bugs from the multi-portal approach.
Populating the new foreign key.
Completing the new portal with the hide object feature.
Fixing the dwindling value list used in the popup menu.
The final steps to a complex feature.
Sharing a file locally allows you to test record locking without uploading your file to a server.
What actions cause record locking occur and what gets locked?
A run through the list of script steps and which ones cause record locking.
How to lock a record so a script can write to it.
How do global fields behave in a multi-user scenario?
Fixing the existing scripts to play better in a multi-user environment.
Related to record locking, window locking occurs when trying to edit the same record in two different windows.
Basic insertion of a picture into a container field with tips on how to make it easier for a user.
A discussion of the different storage types for containers and the Manage Containers dialog.
Expanding a picture using a Window Card.
The creation of a table, relationship and portal designed to store multiple files per record.
Scripting the process of inserting a file.
Auto-entering the file name in a different field so it can be overridden if necessary.
Using the Export Field Contents feature, files stored in FileMaker can be opened and attached to emails.
Allowing the documents table to be shared with companies is as simple as adding a foreign key and relationship.
Set Field by Name can simplify nested If statements that contain Set Field steps.
John Mark Osborne has been working with FileMaker Pro for over 20 years. He earned his FileMaker Pro degree working on the frontlines of Claris technical support. John was the Technical Lead for FileMaker, serving as an escalation path for other technical support representatives and writing a large portion of TechInfo (now called Knowledgebase), their technical information reference. John also acted as a liaison between the technical support department and the FileMaker development team, reporting bugs, attending product meetings and acting as resource for the development team.
John Mark is best known as the author of the popular FileMaker Pro web site Database Pros. The Database Pros web site has been on the internet for 20 years and gets over 35,000 hits a day by offering free FileMaker Pro tips, tricks and techniques.
John Mark is also well known as the co-author of the wildly popular Scriptology book and CD ROM. John Mark launched a hands-on training class based on his Scriptology book and it has become so popular that it is now taught at MacWorld Exposition in San Francisco and New York. Most recently, John Mark was one of twelve trainers in the United States authorized to teach their new FileMaker Training Series of classes.
John Mark has been a featured speaker at the FileMaker Developer Conference for 15 years. At the 1999 Developer Conference, he was awarded the FileMaker Pro Excellence award for "creation of outstanding technical resources".
John Mark is a former technical editors for Advisor magazine working on the tips and tricks section which is the most popular column in the magazine.
John Mark has recorded beginner, intermediate and advanced tutorial videos for FileMaker 8, 9, 10, 11, 12, 13, 14 and 15 totaling thousands of hours.
John Mark Osborne is an FBA member (FileMaker Business Alliance) working closely with FileMaker, Inc. and their most important customers. John Mark Osborne has also passed the rigorous FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15 certification tests and is proud to display the FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15 certification logos.