It's funny with Domino how I sometimes think I know something about the way it behaves only to find I'm wrong. Whether I was always wrong or the behaviour has changed I'm never quite sure. What I'm about to describe is a case in point.
Here's my long-running assumption: If you have a multi-value field separated by, say, semi-colons and you give it a value of "1;;3;4;5" you end up with five stored items "1":"":"3":"4":"5". It's only if you @Trim the field in its translation that you get the blank item removed and end up with four entries.
It appears this is no longer the case and that you always just get the four items. Has something changed or have I always been wrong?
What was I trying to do? Well, imagine I was trying to maintain a list of names, split in to three multi-value fields — FirstName, MiddleInitial and LastName. Imagine storing the names:
- Karen L Howlett
- Jake Howlett
- Teddy S Edwards
The three fields need to store "Karen":"Jake":"Teddy", "L":"":"S" and "Howlett":"Howlett":"Edwards". If the MiddleInitial field doesn't store the blank entry for my name then it all goes to cock. Names are wrong and @For loops throw errors.
As a fix I used normal text fields and separated values using my own method. I'd be interested to know why I had to though.