CODEWITHSUNDEEP
viewlotus-noteslotus-formula
user3426448
user3426448

Reputation: 55

Lotus Notes View unable to show all the values in separate view

I have created a field which is able to support for "multiple value" . In the Lotus Notes view, I have enabled an option "Show multiple values as separate entries" in order to show separate entry of the each value. Noticed that the Lotus Notes view is unable to show all the values in separate entries. Do you have any ideal?Lotus Notes View with Separate Line![][1]

Upvotes: 1

Views: 2059

Answers (1)

Knut Herrmann
Knut Herrmann

Reputation: 30970

Option "Show multiple values as separate entries" shows only unique values in column.

Some of your values are several times in your list like "26" and "462". They show up in column only one time. Think of this option like a categorized column. Multiple identical values are connected to one.

If you really need to show all values then here is a workaround:

Create a second unsorted column right after your column with the formula

@Transform(list; ""; @Random)

This will create a unique random value for every entry in your list.

enter image description here

Hide the second column. Your original column will show all values now.

Upvotes: 2

Related Questions