January 12, 200917 yr Newbies 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.
January 12, 200917 yr 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, 200917 yr by Guest
January 12, 200917 yr Or define a relationship between the two tables and use Go to Related Record to find your records.
Create an account or sign in to comment