Not all fields show up in view designer

HCL Domino Domino Forum
1

While designing a view, I noticed that one of the fields I need to display in a view is not available to choose in the list. This field is an editable text field. After discovering this field that I need, I also noticed that there were only fields not showing up as well. Any ideas why and how to fix?

I could understand if these fields were computed for display, but they aren’t.

Thanks.

2

Subject: Not all fields show up in view designer

If you want to have the field to be shown in the view then just type the field name as a formula. That will get you the field’s value in the view column.

HTH – Cheers

3

Subject: RE: Not all fields show up in view designer

I think I figured out the problem. The field in question started out life as a rich text field. Later, management decided they wanted this field to display in a view. I transfered out all of the attachments and just left text in that field. Following that, I changed the data type to text. But Notes still doesn’t appear to be happy with the field.

I fixed things by creating a text field and then copying all the existing text from the first field into the second and then hiding the first field. That field shows up as a choice.

Before I tried this, I did try just typing in the field name as my formula, but the field still didn’t display even though I knew some of the fields had values.

4

Subject: RE: Not all fields show up in view designer

Kevin,

It sounds like you might be a trifle confused. Once a field is saved as rich text, it will always be rich text and will only display in a view using @Abstract. Changing the field type in Designer will not change any existing documents.

Instead of changing the field type from rich text in the form, why not just use @Abstract to get the text value of the field? That way they can continue to use the field as was originally intended and you have only to change a column formula.

5

Subject: RE: Not all fields show up in view designer

Thanks, Chuck. I didn’t know about @Abstract.

6

Subject: RE: Not all fields show up in view designer

Glad to help! Hope everything’s working well.