| Lookup.ini - Update Owner based on 2 fields | |
Posted: Fri Aug 07, 2009 4:38 am |
Points: 0 |
|
Mags |
n00b |
|
|
Joined: 20 May 2009 |
Posts: 2 |
|
|
|
|
|
|
|
|
Please can you tell me if it’s possible to setup the Lookup.ini to automatically setup the Owner field based on Two Goldmine Fields , our system is currently using repcode at the moment to assign the owner code
What I need to do some how is to create a New matrix using two fields
If recode = X and Userdefined field = Y then use defined matrix B
Other if repcode = X and User defined field is not = y” then matrix A
Many thanks , |
|
|
|
|
Posted: Fri Aug 07, 2009 8:08 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
Yeah, that's terribly simple to do.
Lookup1 = upper(trim(FieldA)+trim(FieldB))
WALDOA = WALDO
WALDOB = 1SALES
MOEA = MOE
etc
Overwrite = 1 |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
ContactReview Forum Index » GoldMine 7 (Corporate Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|