Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Building Grps With Details and dbase Expression

Status
Not open for further replies.

imageres

Vendor
Jun 13, 2006
6
CA
Can someone tell me how to use the expression portion of this feature? I am trying to build a group based on a Detail equal to "Trucks" and Ref starting with "NES" (This part is no problem) the next thing that I tried was to use an expression (still found in the Group building wizzard)to limit the group to contacts where Key2 was equal to "Disqualified" (contact1->key2= "Disqualified") This last part seems to have no efect on the group. Am I misunderstanding how this expression thing is supposed to work?

Doug
 
Maybe, but you can only really go so far with it. I'd suggest working with the SQL Query tab instead. It's much more flexible with what you can do -- and with 6.7 (and 7.0) versions of GoldMine, there's an excellent WIZARD that'll help you build the queries, so you don't even have to know much about SQL queries to get some use out of it. Once you have the results list, you can then flip back to the groups tab and add members to the group(s) based on the SQL query results. It's really quite handy.

Doug Castell
Castell Computers
(310)601-4738
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top