I need a script step called "Press Enter"

[shulme]

Hey folks --

I'm relatively new to writing scripts, but am figuring it out. In short, what I'm looking for is a script step that effectively presses "Enter." Here's why:

I'm an editor, and in my video library database, I have a table of "Original Tapes" (raw tapes of documentary footage), each record with an individual tape number. Another table houses "Available Products," with each record being an edited production (and including a text field called "Raw Sources" that lists what original tapes were used in the edit). I want to go from looking at the original tape record to running a search in the other table (to see what "Available Products" utilize that raw tape).

The script I designed is run by pressing a button available while browsing the original tape record. It basically follows the steps I would take if I were doing the process manually:

1) copy the original tape number

2) go to the layout that shows available products

3) hit ⌘-J to show all records

4) enter Find mode

5) paste the clipboard contents into the "Raw Sources" text field.

and then, I would press Enter. But there doesn't seem to be a script step that does that. I've tested the script as I wrote it, and when it completes, I can then press Enter manually and presto -- my found set. But I don't want to press Enter every time. So I need something that says "Go!" "Execute!" or "Make It So!"

Thanks,

Scott

P.S. A screenshot of the current script is attached.

P.P.S. I tried to do it differently by looking at the "Perform Find" command, but I couldn't figure out how to make that work in this application.

[Ocean West]

Welcome Scott,

I would refrain from using copy & paste as its a flawed method to preserve data plus the pasting requires the field to be present on the layout.

You can use Variables instead!

go to layout [ your layout ]

set variable $number = Original Types::OriginalTape_TapeNumber

go to layout [ your layout you want to find on ]

enter find mode

set field 'Available Products::AvailableProduct_Raw Sources' to $number

perform find

Edited January 12, 2009 by Guest

[comment]

Or define a relationship between the two tables and use Go to Related Record to find your records.

[shulme]

Works like a charm -- thanks!