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:
[UASK]
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.
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:
[UASK]
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.