Update Field Values with Scheduled Agent
Posted on 2011-09-08
I have two apps I am working with. One is a library that contains employee profiles and is updated by admins with term dates, status, etc. I have another database that calls some of that data into the form. This works fine with @DbLookups on the form. What I am looking for is a way to update the Term Date overnight. So that if an admin edits the library with a termination date, then that night it will update that field in my current database.
I do have a basic formula that is running:
name:=@If(CRD = "";"";@Subset(repList;9));
FIELD Adv_Status:= @If(name = "";"";rep);
FIELD Adv_Term:= @If(name = "";"";rep);
This is working on demand but I have a lot of documents going into the new database and I was wondering if there is a more effiecent way to do this. Also not sure if I would need to update/refresh the document with the agent. I am running 8.5.1 FP2
I am still learning lotusscript - but I am thinking that this would need to actually be created in script rather then formula.
It seems like a easy answer, to update the term field and refresh the doc but I am struggling with how to accomplish this. Any help would be appreciated. Thanks