2 Replies Latest reply on Jun 8, 2009 1:05 PM by philmodjunk

    Perform Find with a global variable and match entire field (==) operator

    swhite

      Title

      Perform Find with a global variable and match entire field (==) operator

      Post

      I have a drop-down list on a layout allowing users to set a global variable. The global variable will be used to go to a specific record (i.e. project) on another layout. I've written a script that almost does this using a find, but the default behaviour of find will return multiple records if the project name is a substring of another project name. So, I need to use the 'match entire field' operator (==), but I don't know how or where to implement it...or if there is a better way to go to a specific record using a global variable. I'm using a global variable because I'll need to repeatedly reference the user's choice during their session on multiple layouts.

       

      Here's my script so far:

      Set Variable [$$chosen_project; DASHBOARD::g_project_list]
      Go to Layout ["Projects" (PROJECTS)]
      Enter Find Mode []
      Set Field [PROJECTS::PROJECT_NAME; $$chosen_project]
      Perform Find []

      I've tried various attempts at placing the == operator in different places, but haven't found the right place

       

      tks,

      Scott