Multiple Fields in a select statement for a view

Posted on 2004-11-17
Last Modified: 2013-12-18
I have a view and the first column I want to use 5 differnt fields from the form.

I want to use


Only one of the fields will be populated in each document

Can someone help me with the logic on setting this column in my view
Question by:Jaziar
    LVL 24

    Accepted Solution

    You mean only one field will contain a value and others don't..then simply trim



    LVL 46

    Expert Comment

    by:Sjef Bosman
    Nothing wrong with that solution. If you want to improve performance, create an additional field in your document, Computed, multiple values, with the formula above as its value.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now