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!

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

AUTOMATED PROCESSES &/or lookup.ini

Status
Not open for further replies.
bhayward

bhayward

IS-IT--Management
Joined
May 27, 2002
Messages
1
Location
AU
Is there a way via an AP or through the lookup.ini to update a field with a value Y or N if a date field is older than todays date?
 
Sort by date Sort by votes
Hi

You can do this with the lookup.ini, have a look at the following:

[autoupdate]
UDATEFIELD=UYESNOFIELD

[UYESNOFIELD]
otherwise=&iif(contact2->UDATEFIELD >= date(),"Newer","Older")
overwrite=1

Just change Newer and Older to No and Yes respectively


Robert Colborne
Experts in GoldMine
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SGP1
  • Locked
  • Question Question
alert setting or rather un-setting!
Replies
7
Views
460
SGP1
SGP1
hjwelch
  • Locked
  • Question Question
Adding multiple contacts to organisation/company
Replies
2
Views
440
goner
goner
SGP1
  • Locked
  • Question Question
Strange place to ask, but does anyone have experience of ORCA?
Replies
3
Views
363
goner
goner
mgross
  • Locked
  • Question Question
Automated Process using Lookup.ini on GM 7.5
Replies
4
Views
413
mgross
mgross
sn1b
  • Locked
  • Question Question
GM 5.5 where are stored e-mails senders/recipients AND c.c & b.b.c related contact e-mails!
Replies
4
Views
401
goner
goner

Part and Inventory Search

Sponsor

Back
Top