Clear Multiple Fields in the document

HCL Domino Domino Forum
1

Hi,

I have a form, in which there are about 1000 fields. They are divided into 200 Rows.

The naming convention is as below.

Row1 ----> A1, B1, C1, D1, E1

Row2 ----> A2, B2, C2, D2, E2

…

…

…

Row 200 ----> A200, B200, C200, D200, E200

I want to write an agent, which should delete all the values that are present in these 1000 fields.

Can anyone help me with the code. How the loop should look like.

Thanks in Advance.

2

Subject: Clear Multiple Fields in the document

When doc contains your document you can do something like:

Dim doc As NotesDocument

Dim i As Integer

Dim stri As String



For i = 1 To 100

	stri = Cstr(i)

	doc.RemoveItem("A" + stri)

	doc.RemoveItem("B" + stri)

	doc.RemoveItem("C" + stri)

	doc.RemoveItem("D" + stri)

	doc.RemoveItem("E" + stri)

Next

And don’t forget to save the document when done.