Problem in value calculated from view

HCL Domino Domino Forum
1

I have a field “count” on a form that shows the no of requests raised and I calculate that count by using dbcolumn on a view that contains the total requests.I want that this field should be computed when composed and shows the same value either no of requests increases after creating this form or not.But whenever i open the created form , it always shows the updated no of requests although i make this “count” field as “computed when composed”.what should I do?

2

Subject: problem in value calculated from view

Can you send the formula used in the “count” field…hopefully this will be helpful.

Use the type of field as "Computed when composed’ in the Field Properties tab.

3

Subject: RE: problem in value calculated from view

actually I am creating and saving the form by an agent and form is created at backend.

formula i am using is @Count(@DbColumn( “Notes” : “NoCache” ; “” ; “abapview2” ;1 ) ).

I think i should try computewithform funtion in the agent.wat you say?

Thanks.

4

Subject: RE: problem in value calculated from view

absolutely …When u create a form in the backend …Formulas will not be refreshe unless u use computwithform method.

success = doc.ComputeWithForm( False, False )

If success Then

Call doc.Save( True, True )

End If

5

Subject: RE: problem in value calculated from view

its working now after computewithform. thx :slight_smile: