Update Lotus Document Using View

HCL Domino Domino Forum
1

Dear Guys

I have 100 employee records in Lotus having quota of leave with form Name Quota. Also I have created a view with name view_Quota.

An another form is used to send leave application, reads quota from Quota form and subtract the remaining quota in a Form name Quota according to the days for which leave submitted.

So I have two forms Quota and Leave. I want to read Quota in Leave Form from Quota Form for a particular employee and then wants to adjust remaining Quota in Quota form of that employee.

Please suggest a script to read and update a field of a particular document using another document.

2

Subject: Update Lotus Document Using View

You can retrieve the other document via a sorted view. Get the view and use GetDocumentByKey to retrieve it.

Replacing a value can be done with:

call doc.ReplaceItemValue(“fieldname”, new value)