Populating text list with null string

Hi,

I have a multiple text field- separator is semicolon, values displayed in new lines - which I would like to populate with values. Some of the values should be null string. If I type e.g. “string1”;;“string3” and refresh the form the value of the field changes to “string1”;“string3”. So the 2nd element is deleted and the 3rd became the 2nd. Type “” for the second is not good, because then “” displayed in the second row. (What I want is to display a blank line between string1 and string3.)

Same problem with number lists. Entering 1;;3 fails because the 2nd element can not be converted to a number. Entering 1;0;3 is not good, because the second row is supposed to be empty.

Thanks for help.

Etyien

Subject: populating text list with null string

Your number example will be impossible under any circumstances. There is no “null” in Notes; all empty values are represented by an empty string. You can’t mix data types within an array, so there’s no way to have a string sitting in the middle of an array of numbers. The first example, though, is simply a matter of changing your separator to New Line as well (or adding values through the back end).

Subject: populating text list with null string

You could use “.”, “-” or “(Alt-255)” for blank rows.

Subject: RE: populating text list with null string

Hi Mika,

I have tried these but I got the typed strings displayed. (E.g. string1; “.”; string3). In the 2nd row “.” (3 chars) were displayed.

Should I change the properties of the field?

Thanks.

Etyien

Subject: RE: populating text list with null string

If you change both the input and display seperator to “New Line”, you can even enter a space as value, and Notes won’t squeeze the list.

Subject: RE: populating text list with null string

For a situation like this I have used computed for display fields, and set the formula for the display field to add or filter spaces correctly to display blank rows, while the real field is hidden in the form.