Subtitles of the Movie

There's all our declarations before we leave that record because what we're going to do next is say go to a layout. We know we have that new layout from the history table all the way at the bottom. It doesn't have to look pretty, unless you want it to. We're not going to spend the time doing that, so we're going to change context, then we're going to create a new record. Let me find the new record step. There we go. Then we're going to put those values using set field, all those variables in there, so set field, come over to our history. We're going to choose ID here. We're going to say set that to dollar sign ID. Then we'll duplicate that one, set the table to dollar sign table. Click OK, duplicate. This time we'll do our dollar sign change, our change here, and then do the dollar sign change in there, and then we have one more. That'll be our field and we'll put dollar sign field in there. There we go. Then finally, when we're doing, we can go back to the original layout and there we go, perfect. It'll do everything we want it to do to track that history, so let's try it out. We'll save that, uncheck that, and then what we can do is go ahead and attach it to every field we want to track history on. Because it's completely dynamic, it will know what field we're on, so we'll go into Layout Mode and what we'll do is we'll just select all these fields in here. We'll do them all at once. Rather than doing them individually, just like with conditional formatting, we can go ahead and sometimes assign our script triggers all at once, so what we're going to do is on object save, we're going to say run that script. There's the history. Click OK. Go to Browse Mode. Let's try it out. Let's make some changes here. We'll go ahead and change that to database or let's change it to, let's say, FileMaker Pros. There we go. And we get this Save and Edit thing. We probably should remove that, so let's go ahead and do that before we go on any further. We'll save that and let's go into Layout Mode, go into Layout Setup, and we'll uncheck that for right now. There we go. Go into Browse Mode, try that again. We'll change this to unintelligible and we'll give her a new address, 2066 Rancho Hills Drive, and you can see how tabbing works just I mean, you don't even know anything's going on, so let's go try it out and see what happens. We'll go into the history and see what we have in there, and you see that we have some records. Let's go ahead into Layout Mode and make this a little bit easier to read, make that text color black. There we go. That should be better. I think we'll go up to 12.2, just to make it a little bit easier to read. Then we'll go into Browse mode and you can see we have that most recent change to the Address 1 field. There's the Name Last field. We changed it. There's the Company change. So you can see how it's tracking this history very easily, without any interruption to what the user is doing. So if we come back here, again, what we could do is, over in the Notes section, we could put a portal here because, remember, we stored that ID over there, so all we need is a simple relationship to put a portal in here to see all the history changes that you might want to see.