A multiple value field w/results in a single column view..need help!

HCL Domino Domino Forum
1

I have a field from a form that allows multiple name entries. I am creating a view and want to see the results from this field.

Ex. Field “Name” has results:

Jane Doe

John Doe

Jane Doe

The view column is showing:

Jane Doe John Doe Jane Doe

I would like the column view to look like

Jane Doe, John Doe, Jane Doe

OR

Jane Doe

John Doe

Jane Doe

I tried using the column properties and choosing multi-value separator and comma and new line and it does not work.

Any advice? Thanks!

2

Subject: A multiple value field w/results in a single column view…need help!

  1. it should work if you set column’s property to “show multiple values in separate rows”, it should, no any other way.

  2. are you sure that your’s field is multiple? check it please, probably just put in field 3 value using only Enter key as separator, and it still 1 value, not 3

  3. try to use @implode(youField, ", ") in column

hope it will help you

3

Subject: RE: A multiple value field w/results in a single column view…need help!

I apologize. I am trying to clean up someone else’s database.

This field is a Names/editable. Is there a way to do what I need to do with the field properties like this?

4

Subject: RE: A multiple value field w/results in a single column view…need help!

Several things come to mind- a) A Names data field type field can be “Mulit value” - if it isn’t use @explode to do it. you can get them to show up like you want by using the “separate multiple values with a new line” (column properties) and make sure that in the view properties style tab you need to set the (row section) to the number of possible values- you can set up to 9 rows- make sure you then select ‘shrink to fit’- if you are concatenating stuff, you also need to use ( ) for each line- ex Name : (City + " " State + " " + Zip) will work- but if you take the () off, it won’t.

5

Subject: RE: A multiple value field w/results in a single column view…need help!

Thank you for taking the time to respond to my question! I tried doing eveything that you listed above but my column data still looks like this:

Jane Doe John

Doe Jane Doe John

Doe etc…

Any other suggestions? Thank you again for your time!

6

Subject: A multiple value field w/results in a single column view…need help!

Did you try the column option “Show multiple values as separate entries”?

Regards

Litty Joseph