hithere is a ‘simple’ text field which becomes a problem: On Computewithform by Agent or Action the value in this textfield disappears.
Also strange is that item properties of this text-field show Datetimevalue NOT nothing in Debugger. Seems it comes from bad Design?
Any Help will be much appreciated
(History: The values were imported from Oracle to a Notesdatabase. Next Step: I copied the values into existing documents of another Notesdatabase (replaceitemvalue and save). The field in this database was once removed and created again)
Subject: RE: field value disappears on computewithform
Suspect formula on form is clearing this field. Check input translation (if editable) or Value formula (if computed). Not all @Functions work in ComputeWithForm – check documentation.
Your point about the debugger is not clear. Saying a value is “not nothing” doesn’t mean much since you didn’t say when it had a value or what the value was at that time.
Subject: RE: field value disappears on computewithform
[The field is nested in a computed subform(other fields in subform are working correct).]
I searched all fields in form for setfield-formulas for input translation and validation, all events like querysave/recalc etc. and i searched the field by name in the design overview database dsgnsyn.nsf and nothing found what could explain this behaviour.
There was an input translation formula i wasn’t able to delete so i created the field again:
@Left(Fieldname; 20)
You are right: Comparing more than two document items (text) in Debugger i see some have datetimevalues and others not
Subject: field value disappears on computewithform Solved
We introduced a form with same name for replication activities without subform. Inside there was a wrong input validation formula for the field. Thanks a lot Andre for Your Help