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 strongm 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
May 27, 2002
1
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
alert setting or rather un-setting!
Replies
7
Views
121
SGP1
SGP1
hjwelch
  • Locked
  • Question
Adding multiple contacts to organisation/company
Replies
2
Views
96
goner
goner
SGP1
  • Locked
  • Question
Strange place to ask, but does anyone have experience of ORCA?
Replies
3
Views
85
goner
goner
mgross
  • Locked
  • Question
Automated Process using Lookup.ini on GM 7.5
Replies
4
Views
87
mgross
mgross
sn1b
  • Locked
  • Question
GM 5.5 where are stored e-mails senders/recipients AND c.c & b.b.c related contact e-mails!
Replies
4
Views
104
goner
goner

Part and Inventory Search

Sponsor

Back
Top