I have a multivalued field, computed when composed, that contains values from other fields on the document, some of which are null.
When I edit and save the document, Notes performs an automatic trim of the null values. I need the null values in order to capture changes in the original fields.
I can get around it by converting the list to a string and back again when I want to operate on it, but it’s very annoying. Is there a way to prevent the automatic trim from happening?
Subject: RE: automatic trim of multivalue field with null values
If you leave the field off the form, and just assign it with a FIELD statement or LotusScript code, then Notes will not trim it.
Subject: automatic trim of multivalue field with null values
You would have to modify the save event to inhibit refresh.
I have an alternative which will work, but will cause you a few changes. You could make the field to contain not just the value but the element number. So if your mult-value field had “A” : “B” : “C” : “D”, the field would have “1~A” : “2~B” : “3~C” : “4~D”. Then if a null is introduced it would not be tried because the field would then have the element number. I added the “~” because this denote the field has 2 values (one the element number and the second the true value).
HTH – Cheers