Zero to Awesome - Using a History table
If you've worked with FileMaker for any length of time (5 years or more), then it's hard not to become affected by your historical knowledge of how FileMaker works. My reason for stating this is because of how data and interacting with it "might" be limited if you're taking the conventional approach within FileMaker.
"Conventionally", FileMaker provides your layout and you simply add fields from the table that layout is associated to. Here's the problem though, you end up with a mindset which potentially limits you from seeing other options - until you want to see things differently. How about each user of the database being able to see only the records they've interacted with, and being able to do so from a historical standpoint? Statements such as "Who was that customer I dealt with last week?" become easy to answer.
Seeing things differently is what this video is all about. The video will show you how to use a dedicated History table to provide unique views on how users have interacted with the data in the database. You don't always have to do things the same way. Sometimes, there's a different way that may provide better options!
Comments
Digging deeper into the History table
I've been following the Zero to Awesome series closely. It's excellent, very well thought out and clearly explained. However, with the History technique especially I really need a technique file I can pick apart. You also mention midway there will be a subsequent video on the inner workings.
Please let me know when these become available.
At a number of points you start explaining something, then break midway to explain something else as background, leaving the original point incomplete. The History technique is easily one of the more difficult to follow. Nevertheless I'd like to take a crack at adopting it.
Assistance appreciated,
Morley Chalmers
Morley Chalmers
--
Do not worry if you have built your castles in the air. They are where they should be. Now put the foundations under them. -- Henry David Thoreau