Refresh computed fields

HCL Domino Domino Forum
1

I have 3 forms, A, B and C.A and B are documents, C is a response document.

Based on A, I create B where some fields are ‘computed when composed’ based on the fields in A. C is created based on B, where the same fields are ‘computed when composed’.

When the fields are changed in A, I would like to have the fields in B and C refreshed automatically.

Can anybody help me with this ?

2

Subject: Refresh computed fields

why would you choose “computed when composed” fields and then want them to compute again? change the fields to computed. What type of field is A? If it is a dialog list you can set its properties to automatically refresh the other fields. If its just plain text, you might to use a field event script to call a uidoc.refresh

3

Subject: RE: Refresh computed fields

Sorry, I am not an expert …Field in A is a ‘name’ field (looked up in an address book). This name editable. When created doc B, the name field is automatically taken over in doc B (by using computed when composed). Creating doc C based on B (response doc), The name field is also been taken into doc C, by using computed when composed. (Probably not the right way to di this ???).

When I change the name in doc A, I would like it to be automatically updated in doc B and C.

4

Subject: RE: Refresh computed fields

Hi Marise,

There is no magical way to do this. You need to capture the existing value in the name field on Form A during the queryopen or postopen event of the form. Then check it again on the queryclose to see if it changed. If it did then you need to get a collection of all related documents and update with the new value.

HTH

Mark

5

Subject: RE: Refresh computed fields

I misunderstood your original request. I didn’t realize they were seperate fields on seperate forms. Notes is not a relational database, so this is not very easy. Like Mark mentioned, you will have to put some lotusscript in one of Form A’s Querysave or Queryclose event and then go update the other documents.

6

Subject: RE: Refresh computed fields

Thanks to you all.I will do as you suggested.

Hopefully it will work !!

Thanks