1 Reply Latest reply on Jan 21, 2013 11:46 AM by philmodjunk

    search by data in a given field box



      search by data in a given field box


           I'd like to make a script which will create a pop out window to another layout.  The trick I'm finding is that the record I want to have displayed is a particular value which is displyed in a portal in my currant layout.  Here's the breakdown:

           "Shot Record" Layout from "Shot Record" Table has a portal to a "Notes" Layout from a "Notes" table.  Each record in the Shot Record layout is sorted by "Shot Number".  The info in the portal is sorted linking the shot number in each layout and displays all the different filenames associated with that shot number.  I have several different filename records displayed in the protal per shot number record.  I have another layout "WIP" which has all the quicktimes of each filename.  I'd like to have a button next to the filename portal record that will open a WIP layout whcih has is linked to that filename.  

           The closest I've come is having something open a WIP layout with all the filenames associated with that Record Number b/c that's how the Shot Record table is associated with the Notes table.  

           Is it possible to have a script which I can set to the filename in the portal which opens a window in the WIP layout and searches for the filename using the contents of that given filename field?

           Any other suggestions?


        • 1. Re: search by data in a given field box

               Have a button in your Notes Portal use Go To Related Records:

               Go To Related Record [Show only related records; From table: Notes; Using layout: "Notes" (Notes) ; new window]

               This pulls up all the Notes records shown in your portal as a found set in notes, but makes the record you clicked the current record. If you select "view as form" for your notes layout, you will see just the record for the Notes record that you clicked appear in the original layout.