NavigationEasier DevelopmentClick this video (use the full screen or click to go to YouTube) to see what you may be missing in your copy of FileMaker Pro! I don't develop without it! |
Learning Looping Power - Part 2Posted by: Editor / Monday, March 29, 2010 – 8:58pm
22
minutes
This is the second part of a two part series dealing with really understanding how to take advantage of loops within FileMaker scripting. Using the example of an event seating solution, I walk through data loops, portal loops, counter loops (commonly known as a for loop) and embedded loops. The video showcases how to really optimize your loops for the fastest possible execution. Added to this are some really great tips about making your loops both as short as possible and super easy to read! Details: Released - 3/29/2010 / Size - 41.1 MB / Length - 22 min
Filed under: videos | Subscribers Only
|
Be Notified!Let us tell you when a new video is posted. We'll send you an email with a direct link right to your email inbox.
Make sure and whitelist (or add to your address book editor@filemakermagazine.comiPod Video
10 Most Recent Videos
|
Create new related records
Hi Matt,
Very efficient use of looping. I have to say, I was even more intrigued by the technique of using a non-matching relationship through a blank field to create new records in the child table. This seems very useful, but I'm still a bit hazy on how to do it, and I wanted to ask if you either have suggested reading or could take it up in greater detail in a future video. For example, how would I use this example in real life to, for example, document what the kids turned up in their Easter baskets? Let's say Ewen found 4 jelly beans, one plastic egg filled with Cheddar bunnies, 3 Peeps, and one shiny rock, while Max found 6 jelly beans, a Cadbury egg, 2 pinecones, etc. I'm not being facetious, I just have Easter hunts on the brain. Would I have a button that says, enter swag for kid blank, with a script trigger that creates a new kid record on object save, and then a list of items in a portal that would be added as a 'found items' TO with a foreign key for the kidID?
I'm struggling, because this seems extremely powerful, but I can't quite figure out how I put it to use in a solution other than one that loops, and I feel like it could be very useful other places as well. Thanks for your help!
Cheers,
Bob