troubleshooting Question

Update Field Values with Scheduled Agent

Avatar of kali958
kali958Flag for United States of America asked on
Lotus IBM
6 Comments1 Solution555 ViewsLast Modified:

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:

nameList:=@DbLookup("":"NoCache";"862575D2:006578DA";"lkupLOIAll";CRD;3;[FailSilent]);
name:=@If(CRD = "";"";@Subset(repList;9));
FIELD Adv_Status:= @If(name = "";"";rep[7]);
FIELD Adv_Term:= @If(name = "";"";rep[8]);

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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros