CODEWITHSUNDEEP
lotus-noteslotus-formula
Florin M.
Florin M.

Reputation: 2169

lotusnotes: creating a new field, update the already existing documents

I create a new computed field called txt_new in a form, which has a default value based on some calculations between other fields.

I also create a new column in my view named vwMain which has the default value: txt_new.

The problem is that the column is empty considering the fact that the .nsf has already >10k documents. Is there any posibility to update/(re)save the documents in a safe method ?

Thanks for your time!

Upvotes: 2

Views: 1185

Answers (2)

Knut Herrmann
Knut Herrmann

Reputation: 30960

Write an agent which contains the default formula of your field txt_new and execute agent for all 10K documents. That should be fast enough or to be more exactly: there is no faster way.

Example for agent:

SELECT txt_new = "";
FIELD txt_new := ... here is your default formula code ...

Upvotes: 3

Mike
Mike

Reputation: 2549

You can create an agent to run against all the documents in the view/selected documents only using

@Command([ToolsRefreshAllDocs])

Upvotes: 1

Related Questions