Computed when composed

HCL Domino Domino Forum
1

I created a form with some fields populating using computed and a dblookup formula.This work well, but I then realised that the data that my dblookup is accessing changes every 2nd day. But i need to keep the data from initial doc creation. So I changed the fields to computed when composed, keeping the same formula, but the fields are not populated.

Any ideas?

thanks

2

Subject: what’s in the formulas?

formulas evaluate “top-to-bottom and left-to-right” so if a field has a formula that depends on another field’s content, and that field is not above it, you’ll get an empty result

3

Subject: use 2 fields

create a hidden computed multivalue field with this formula onb the top of the form:@if(@isNewDoc;@DBLookup(yourlookup);@ThisValue)

(or instead of @ThisValue the name of the second field)

and in your field just enter the name of the hidden field

that should work

4

Subject: thanks

Thanks for the two replies. Both useful info.And the @isnewdoc advise saved the day. It worked a treat.

Many thanks!