Script to change a record number in a seperate window

[Musoguy]

Hello all, I am new to the forum (and to Filemaker)so hope I am posting in the right place.

The file I am working on, I always have two windows open,side by side. I need to be able to always work on 2 consecutive records at the same time, and be able to go back and forth between the two. The record in the right window always needs to be 1 record higher than the one in the left window (so if I am on record 1 in the left window, the right window is on record 2, if 5 is in the left window, 6 is in the right etc.)

Is there any way to automate the process so that whatever record I go to in the left window, the right one automatically updates to the next record up from the left window. I have a field in each record that has automatically incrementing serial numbers in it that corresponds to the record number, if that helps at all.

Hope someone can help! I'm not even sure this is possible, and if it is, figuring it out is definitely beyond my current experience level.

Thanks in advance for any ideas. :)

[Ocean West]

Here try this

first run the window script to create the two windows.

then scrolling or jumping between records should correspond +- 1 record.

windows.fp7_2.zip

Edited March 7, 2010 by Guest

[Musoguy]

Thank you so much! That is exactly what I was looking for. I am trying to get my head round how it works, but will get there. The important thing for me right now is that it DOES work!

Thanks again :)

[Musoguy]

Spoke too soon! Your solution works perfectly in your example database, but is not translating to my own (which means I am doing something wrong!). Like in your example I have a field set up that has a number that corresponds to the record number. I added the "Scroll" script to this field as a script trigger, with the same properties that you did but nothing is happening. I tried changing instances of your window names to the names of my windows (instead of window and window[2], stagedoor audition form and stagedoor audition form - 2. Not sure this will make any difference as my understanding so far is that these names are variables. But I tried it anyway. I'm not sure what I am missing!

[bruceR]

Well, upload your file. It is really hard to guess what you might be doing, and not appropriate to give people who are trying to help you so little information.

[Musoguy]

As you can see I am new to the forum and to Filemaker, and wasn't sure if uploading files was frowned upon as it is in many Excel forums I have belonged to in the past. I have expressed my thanks for the help I have received so far, and now I know what is "appropriate"! The file is attached. Again, I appreciate the time people are putting in to help.

Audition_File.zip

[Musoguy]

Solved the problem and got it working. For anyone else with a similar problem, I've attached the fixed file. I ended up with the scroll script:

Set Variable [ $rec; Value:Get ( RecordNumber ) ]

If [ ValueCount ( WindowNames ( Get( FileName) ) ) = 1 ]

Exit Script [ ]

Else

If [ Get ( WindowName ) = "Audition File" ]

Select Window [ Name: "Audition File - 2"; Current file ]

Go to Record/Request/Page [ $rec + 1 ]

[ No dialog ]

Select Window [ Name: "Audition File"; Current file ]

Exit Script [ Result: 1 ]

End If

If [ Get ( WindowName ) = "Audition File - 2" ]

Select Window [ Name: "Audition File"; Current file ]

Go to Record/Request/Page [ $rec -1 ]

[ No dialog ]

Select Window [ Name: "Audition File - 2"; Current file ]

Exit Script [ Result: 1 ]

End If

End If

This is made to trigger when a record loads (not when the ID field changes (as I had mistaken before). For any other newbies that aren't sure how to do this, in Edit Layout, go to Layouts - Layout Setup. Go to the Script Triggers Tab. Check "On Records Load". Next to Script click Select and select the script you want to load when a record loads.

Hope I was able to help someone else! Stephen, thank you again for your time and for sending me in the right direction!

Audition_File.zip

[bruceR]

You need a real record ID field, for one thing.

Alternative technique next post.

[bruceR]

Try this.

Audition_File.fp7.zip

Edited March 9, 2010 by Guest

[Musoguy]

OMG! That is incredible! Thank you so much! I'm speechless and have no clue how to start trying to figure out how you did that! I'm going to sit down with the file when I have a few hours tomorrow and try and figure it out. Do you mind me asking how you got 2 records to show in 1 browse window, as that was the first issue I had when trying to create my solution. Bruce, thank you so much again, this is far beyond what I could hope for. And for the record, I hope Jerry Seinfeld and Will Smith audition for the show! :)

[bruceR]

Look at the relationship graph and the record-load script.

[Musoguy]

Will do. Thanks again :)

[bruceR]

Another mod. Maybe you want to keep the current selection but look at a different record on the right. Shift click in the portal to view the alternate record but leave the main selection untouched.

Audition_File.fp7.zip