Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 7 (Corporate Edition) » Lookup.ini - Update Owner based on 2 fields
Post new topic  Reply to topic View previous topic :: View next topic 
Lookup.ini - Update Owner based on 2 fields
PostPosted: Fri Aug 07, 2009 4:38 am Points: 0 Reply with quote
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 ,
View user's profile Send private message

PostPosted: Fri Aug 07, 2009 8:08 am Points: 0 Reply with quote
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
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Lookup.ini - Update Owner based on 2 fields
  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  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin