Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

lookup.ini and duplicate fields like "Ref" "OnDate"

lookup.ini and duplicate fields like "Ref" "OnDate"

lookup.ini and duplicate fields like "Ref" "OnDate"

I need to pupulate a user-definited field (UASK) with the contents of Cal.Ref whenever a new appt is entered by a specific user. I am trying to use lookup.ini to do this. In the AutoUpdate I have something like this:
Cal->OnDate = UASK

but it's not working. I'm not sure why. Is it possible to identify a field in this way in the lookup.ini? There is more than one OnDate field so I can't just use OnDate.
Also, for the result I have:
   Otherwise = iif((Cal->UserID)="ask", Cal->Ref, "")
I'm trying to say if the user is "ask", put the contents of Ref into the UASK field. Am I going about this completely the wrong way? I get no result at all but all my other iif statements work fine.  

RE: lookup.ini and duplicate fields like "Ref" "OnDate"

Unfortunately you cant use the AutoPopulate section to trigger on a Cal entry, you can only use this to trigger on a new contact1 record or an an update to any contact1 or contact2 field.

You can use the OnNewRun to trigger an exe file to populate the Contact2 field when a new cal record is created but you would need to get a GoldMine solutions partner to write the exe for you.

Hope this helps.

Andrea Ingham
Prior Analytics Ltd (UK)

RE: lookup.ini and duplicate fields like "Ref" "OnDate"

Thank you Andrea! I appreciate the information. We just recently contracted with a GM solutions provider so I will talk to them.

Oops "populate" not "pupulate" - proofreading not so good that day I guess :)

RE: lookup.ini and duplicate fields like "Ref" "OnDate"

If you're using an SQL database, you could accomplish this with an SQL trigger and a little coding...

Doug Castell
Castell Computers

RE: lookup.ini and duplicate fields like "Ref" "OnDate"

It may be possible to update the uAsk field via the Lookup.ini. If you place a special character as the first character in the Ref: field like an asterics ( * ) then eventually this will make it into the Next Step feel on the Summary screen. When it does, and with the marker as a flag, you may be able to utilize the Lookup.ini to populate your field.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close