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.
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: 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.