Hope I am just missing something here and this is really easy.
I have a series of 7 agents that run when triggered by an Action on a view. These agents update a doc and its corresponding Profile doc. The 6th agent changes the Status and saves the doc - which moves it to a different catagory in the view. Important thing here is the doc being worked is no longer selected. And so when the 7th Agent executes next it is not executing on the correct doc.
The doc ID for the selected doc had been saved in the Profile doc via the 1st Agent.
I know for the 7th Agent I can get a handle on the proper doc via Script, but is there a way to do the same thing in formula.
The developers here do not know Script and so needed to make this happen with formula.
your developers don’t know Lotus Script? Sounds like you need soem new developers. If you have and can get the UNID of the doc you need to get a handle on then take a look at OpenView and OpenDocument @Commands.