Cris Ippolite is a three-time FileMaker Excellence Award–winning trainer and the founder of iSolutions, a Los Angeles–based FileMaker consulting firm. Cris is a FileMaker Certified Developer in all versions, as well as a FileMaker professional trainer and one of 50 partner-level FileMaker Business Alliance members in the world. Cris also serves on the FBA Partner Council as an advisor to FileMaker, Inc. He also has been a regular speaker at several technology conferences, including the FileMaker Developer Conference, where he has been a speaker over 35 times. Cris has managed the FileMaker Certification training track at the FileMaker Developer Conference and won an award for his training efforts there in 2014 and again in 2016. For more information on Cris and his training offerings, visit him.
Related courses. By: Cris Ippolite Shows how to translate aspects of the real world into the form and language of a relational database, using three practical data modeling examples. Course.
2h 40m 43s. By: Cris Ippolite Walks you through the advanced FileMaker Pro development techniques, including using calculations, security, advanced reporting, scripting, sharing, and web publishing. Course. 7h 33m 19s.
By: Cris Ippolite Learn how to work with your FileMaker database on the go and understand the design considerations that come with mobile access. Course. 1h 15m. By: Cris Ippolite Tour the new and enhanced features in FileMaker Pro, Server, and Go 13, including layout styles, new popover and slide controls, and publishing to WebDirect. Course.
3h 56m 31s. Course Transcript Once you become familiar with the FileMaker application and how it's set up, there's a couple different ways that you can start creating databases. Of course, you can create them by scratch, which we will be talking about for the remainder of this title, but there are also a couple different ways to get a quicker start. You will notice when you first open the FileMaker application that you have got some options over here on the left that allow you to either Create a New Database and start from scratch or Convert Existing Files or use that's called a Starter Solution. You can select the Use a Starter Solution from the Quick Start screen or when you are already in FileMaker you can go under the File menu and choose New From Starter Solution. FileMaker updated its Starter Solution viewer window in FileMaker 12, and it lists all the different Starter Solutions that are available to you, and you will see that they are also grouped logically in sort of business units, for instance, of the 16 here are the ones that are General, ones that are related to People & Assets, and so on.
But if you're looking at All Solutions, you can scroll through these and they're pretty self-explanatory for the most part. You'll see, for example, if you choose the Contacts option and then hit Choose, it's going to ask you where you would like to save this. We will hit Save, and now it opens up the Starter Solution. So the first thing you will notice is that there's really not much development that's necessary, the layouts are already created.
If you take a peek into the Database you will see that there's a contact Table and a series of Fields. So a lot of this stuff is already programmed for you, there are some routines and Scripts already built-in.
And it's ready to start creating new data. You can hit New Record and instantly start working with the Database. But more importantly you should know that in addition to being able to add your own data to the Database, you can also go into Layout mode and manipulate the database, change some of the fields and the way things look and really customize it for exactly how you need it go look. So you don't have to just settle on the way that they're built already for you, the idea is you can tell by their name is that these are intended to get you started. And the Starter Solutions are also a great way for you to see how different functionality works. Like, for example, here is something that's called Web Viewer, and it displays the addresses that are listed in these fields. And this is a great way for you to see how these Web Viewers actually work.
But also you'll see that there are some layouts that are pre-built. You will notice that in each of the Starter Solutions they've got iPad and iPhone layouts already created. Each of these layouts conform to Apple's touch screen guidelines, so making things like buttons and some of the touch areas larger so that they'll be ready to be viewed on any device without any modification whatsoever. So in addition to being able to work with the data or add your own data you'll also be able to view this information on the various different Apple devices. One thing I should mention about Starter Solutions is that if you happen to be using a 30-day trial version of FileMaker, keep in mind that that's just a 30-day trial for the application. The Databases that you create or the Starter Solutions that you create and modify, they don't have a 30-day limit on them. So feel free to go ahead and poke through all the different Starter Solutions in the Starter Solution Viewer and see if there's maybe something that's already built in here, and that'll let you get started as quickly as possible.
Starter Solutions are a great way to get familiar with FileMaker without having to do any programming. So I encourage you to go ahead and take a look at a couple of different ones, download them, and play around and see which one suits you best. Practice while you learn with exercise files. Watch this course anytime, anywhere.
Course Contents. Introduction Introduction. 1.
Getting Started 1. Getting Started. 2.
Database Creation Essentials 2. Database Creation Essentials. 3. Creating Tables 3. Creating Tables. 4. Creating Relationships 4.
Creating Relationships. Best conference room scheduling software. 5. Working with Fields 5.
Working with Fields. 6. Working with Container Fields 6. Working with Container Fields.
7. Working with Records 7. Working with Records. 8. Importing and Exporting 8. Importing and Exporting.
9. Creating Layouts 9. Creating Layouts. 10.
Filemaker Free Database Templates
Working with Layouts 10. Working with Layouts. 11. Formatting Layout Objects 11. Formatting Layout Objects.
12. Finding Data 12. Finding Data. 13. Sorting Data 13.
Sorting Data. 14. Value Lists 14. Value Lists. 15.
Printing and Saving 15. Printing and Saving. 16. Reports. 17.
Calculation Essentials 17. Calculation Essentials. 18. Script Essentials 18. Script Essentials.
19. Script Triggers 19. Script Triggers. 20. Using Relationships 20. Using Relationships. Conclusion Conclusion.
Database Pros:Store s All solutions come with the full access password so you can modify the solution to meet your unique needs. In addition, solutions do not requirelicensing fees for seats, servers or distribution. If you have any questions, feel free to email me. Learning Complex Calculations contains hundreds of the most widely-used calculation formulas for FileMaker Pro for beginner, intermediate and advanced developers. Even though it contains reference material, the purchase comes with the full access password so you can see how it was created! Learning Every script step defined with over 200 example script, notes, errors and much more! Even though it contains reference material, the purchase comes with the full access password so you can see how it was created!
Solution The Invoicing Solution is great for a small business or someone who wants to jump start their own invoicing solution. Registration comes with the master password so you can add features or reverse engineer it to learn more about developing in FileMaker. No licensing!
Technical support is not included with purchase. Solution The Contact Manager quickly organizes all your contacts with great features like storing documents, organizing by groups, printed and electronic correspondence, history, todos and much more. Fully unlocked and no licensing! Technical support is not included with purchase. Solution The Calendar Solution is a unique calendar solution that is completely relational sound, allowing reports and finds to be performed naturally. The product comes with the full access password so you can modify it to your specific needs and there are no licensing fees. Multiple users are supported in a network environment.
Technical support is not included with purchase. Solution Donations allows non-profit organizations to track their donations by contact, organization, event and cause.
Quickly print reports by contact, organization, event or date to help make sense of where your donations are coming from. Full Access password provided upon purchase or call to inquire about customization.
Technical support is not included with purchase. Solution The Envelope solution is a simple product that prints out #10 envelopes with a logo, return address and destination address.
I use it all the time so I thought it would be useful to others at the right price. Download a copy and give it a try! Solution With so many web sites and apps that require passwords these days, it's nearly impossible to remember them all. Password Keeper makes it easy to create, save and restore your passwords with features like random passwords, copy/paste passwords, drag and drop and much more. Solution The Project Management solution helps you manage projects with tasks, sub-tasks, expenditures, hours, documents and more.
Quickly print reports by project, task, sub-task and employee. Full Access password provided upon purchase or call to inquire about customization of the Project Management solution.
Technical support is not included with purchase. Solution Organize your Database Design Reports (DDR) in a FileMaker database at a reasonable price. Fast imports save you time and an easy drill down interface allow you to find what you are looking for quickly. Why pay ten times as much for a product with a fancy interface! Solution Tired of the inadequate bookmarking feature for large numbers of web sites?
Organize your web sites better in a FileMaker solution! Full access password provided with purchase. Solution The Message Tracker allows a small, medium or large company to take messages from phone calls and track responses.
Includes areas for message taking, employees and client tracking with cross-referencing between all three areas. Fully unlocked upon purchase with no licensing. Technical support is not included with purchase. Solution The Template Set contains 20 templates based on the themes that come with FileMaker.
This template set has been completely rewritten from the ground up to include dynamic scripts, calculations, interface elements and much more. Technical support is not included with purchase.
Solution The Template Set contains 19 templates based on the themes that come with FileMaker. This template set has been completely rewritten from the ground up to include dynamic scripts, calculations, interface elements and much more. Technical support is not included with purchase. Service This service allows you to work one-on-one with John Mark Osborne while he helps you over a FileMaker hurdle.
It's half training and half development. The service can be provided in person, over the phone or via GoToMeeting. The bulk rate saves you $500.00 over the normal cost when buying 8 or more hours! Service This service allows you to work one-on-one with John Mark Osborne while he helps you over a FileMaker hurdle.
It's half training and half development. The service can be provided in person, over the phone or via GoToMeeting. Save money and purchase the bulk rate! Service Database Pros offers project based FileMaker consulting or development but you can also purchase programming time from John Mark Osborne at an hourly rate. Please call for bulk rates. S This site runs entirely on FileMaker and a Macintosh server. I just wanted to prove that FileMaker can really do it all!
Database Pros recommends for Colocation of your Web Server!
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |