Hi, I have views that get updated via an agent as it pulls data from an Access database. Is there a way to show on the form when the agent was last run in a field? I’m looking for a way to get agent stats and post them on the form. If not then maybe when the view was last updated. Just something to show when the data was last updated (if it even was updated)
Thanks alot,
KB
Subject: Show when an agent was last run on a form. Possible?
When you say the agent update the views, do you mean the agent update the documents in that view?. If so, you can place a temporary item like below:doc.LASTUPDATEDBY = Today.
HTH
Adi
Subject: Show when an agent was last run on a form. Possible?
You can also have the agent set a date/time field on the document that no other action updates. The agent puts the current date/time in that field. This can then be referenced.
Subject: RE: Show when an agent was last run on a form. Possible?
Others have posted advising you to have your agent add a field to the document, but I think you may have over-specified your question. Are you just looking to show when the document was last updated, regardless of the cause? Because that information is available thru @Modified function and you can just add a computed for display field.
Subject: Show when an agent was last run on a form. Possible?
If it were me I would create a new Form called AgentHistory and create a new document based on that form every time the agent runs and post whatever info about the agent that you want to know such as Agent Name, Start Date/Time, End Date/Time, Run Time, Documents processed, view(s) updated, etc.
Subject: RE: Show when an agent was last run on a form. Possible?
Hi and thank you for the responses. It’s an agent that modifies about 1500 documents so I guess what I really want is when the agent ran rather than having a time stamp of when each document was updated separated by a split second between each one (some of the documents might not get updated due to no changes in the Access query). But all these responses gave me some great ideas.Thanks again for your replies. I appreciate it.
KB