FileMaker Pro 12: Beginner Tutorials
Introduction / Why an Invoicing Solution?
Subtitles of the Movie (FileMaker Pro 12: Beginner / Introduction / Why an Invoicing Solution?)
All three tutorials will use the same solution, an Invoicing Solution. It will start off at the beginner tutorial as a contact manager but in the intermediate and the advanced it'll transform into an Invoicing Solution with customers or contacts. So why did I choose an Invoicing Solution? Let's try to explain that decision because it's a very important one. You may not be trying to build an Invoicing Solution but building an invoice solution will help you with any solution. Let's go through the bullet points I have here listed and try to explain why we've chosen this particular solution. First of all, everybody watching this tutorial will be familiar with transactions, buying and selling things, going to a store and buying things. They may own a store and selling, buying and selling things themselves, whatever it is, everybody is familiar with that process and so I have a lot of buy in that way. Everybody's going to be immediately familiar with what we're trying to accomplish so that's easy for you. I could have chosen something like, let's say, students at schools with classes and things like that but I think this is just a little bit more familiar to everybody else and not such a niche area. Everybody buys and sells things, it's part of our life. So I like this familiar solution so everybody can immediately understand what's going on. Now the second bullet point says, show techniques in context. What that means is, better explain by looking at other training materials I've seen. In a lot of other training materials, they use many different examples, you know an Invoicing Solution, a classroom solution, solution X, Y, Z and they show different techniques in different solutions and they never give you all the nuts and the bolts. We're going to build this solution right from the ground up so you know every nut and bolt and we're going to show you each one of these techniques that could be shown in different solutions in a single one so it's completely in context. You get the whole idea, you're going to have in your head then how to completely build an entire solution and in this case, an Invoicing Solution. Now don't get worried because all these concepts that we're teaching inside the Invoicing Solution can easily be applied to any solution. I would say at least 90 percent of the techniques we're going to cover are applicable to any solution out there. I also like the Invoicing Solution because it's simple enough to create a complete solution, there's going to be about four tables, at least four main tables but its complicated enough to show all the advanced techniques I want to show. So really it is the perfect solution to show off FileMaker, to allow you to learn how to use FileMaker. The other great thing about an Invoicing Solution is, it allows you to show all the relational concepts you need to know. Starting with many-to-many relationships, this is probably the hardest thing to understand as far as relationships in a relational database. It allows you to join two tables with another table and you really have to understand this, you can't skip over the many-to-many relationship. You have to study hard and use this example we're going to give you inside the Invoicing Solution to really understand it so you can apply it everywhere. You're going to see them all over the place; probably the only exception is very simple solutions. But the great things about them is a many-to-many relationship is comprised of several one-to-many relationships, so it's not that much more difficult to understand but it is a stumbling block usually. And the great thing is the Invoicing Solution shows it off really well. The other thing we get to do inside of an Invoicing Solution is show tons of portals, we get to show related fields, in fact we get to show great scripts. There's a lot of scripts we can show inside of an invoicing solution that will do all kinds of things, that demonstrate loops, variables, the whole gamut of scripting in FileMaker, automating in FileMaker. And we also get to show calculations, tons of calculations, so you get to cover just about everything. And we won't cover every script step or every Calculation Function but we get to the ones that are most important, the ones I use most every day and they can be easily explained and make sense within the context of an Invoicing Solution.
Tutorial Information
| Course: | FileMaker Pro 12: Beginner |
| Author: | John Mark Osborne |
| SKU: | 34323 |
| ISBN: | 978-1-61866-046-6 |
| Release Date: | 2012-06-08 |
| Duration: | 16 hrs / 169 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
