I have a web-enabled database that has simple workflow…pushes the document to many approvers. The users wanted a priority field, a number the authorizer sets (2nd part of workflow) to determine the priority level of the document (1.0, 1.1, 1.2, etc). I’m trying to find a simple solution for an issue the users brought up.
If there is already a document with priority level 1.0, and they have a new document that came through that should be 1.0, but the validation doesn’t allow them to as the priority level has already been taken…they want a way where they can choose 1.0 and change all the existing documents priority. Yes, it would have to be a loop to loop through all existing documents and increment all priority levels. (ex: New doc is set to 1.0, which replaces existing doc with 1.0, so then existing doc has to be changed to 1.1, and so on and so forth)
I know I could somehow figure this out in a lotusscript agent, which would take me forever. But are there any other simplier ways you can think of? Maybe some new kind of functionality that is available in 8.5?
Thanks for your help.