I have to split each document into two separate documents applying a factor to be determined. I’m not sure if a script is my only choice or if I can kludge together a formula option…
Basically I have a job form with a bunch of fields (name, age, sn, etc.) and also a %Time worked field…which can be from 10-100% … I need to split the person’s job into 2 separate jobs (documents) so if my factor is .5 then I need to split my one job of 100% time worked into 2 jobs with 50% one job & 50% another …
This only happens to certain jobs that are coded as “GI” … so my first thought would be a view that contains only jobs coded “GI” … then a script would walk thru each document and grab the 1st document, capture the %worked - change the %worked in this document by half … then create another document with the remaining %of time worked and changing a few other fields…
I’m going to start the script method … but if anyone has any thoughts on easier ways to do this plz do tell!!
THnaks!!!
ER
Subject: Making copies of every document … but changing couple fields…
Eric,
of course I didn’t actually try, but telling from what you are writing you could do it in formula language.
However, I wouldn’t do, and that for a couple of reasons.
The most important however is that your agents seem to be pretty complicated from the workflow point of view, and that formula language offers only bad debugging compared to Lotusscript. I believe it will be far easier to do it in Script.
Additionally, in formula language you will need to create the new documents in the UI, while Lotus Script will run in the background, which is way more efficient and less prone to errors.
If it’s only a one-time-activity, performance doesn’t matter so much. If this activity is to be executed repeatedly, LotusScript should have massive performance gains on the scenario you have given.
However, if you don’t know Script, but are really good in formula language, you probably don’t want to learn script first, but have your results this year…
Subject: View?
Do you need real documents to contain the calculated times, or would it be good enough to show the calculated times in a view?