AnsweredAssumed Answered

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

Question asked by swhite on Jun 8, 2009
Latest reply on Jun 8, 2009 by philmodjunk

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

Outcomes