Multiple Conditions in @If formula

Posted on 2007-08-12
Last Modified: 2013-12-18
I know that I'm missing something, but can't figure out what is wrong?  I have a column in a view, and based on what values are available in the documents, I want a specific field to show in the column.  So, I'm using an @If statement.  There are four fields, sometimes only one has a value (at least one will), but sometimes all of them will have a value or only two of them.  So, I've listed what I want to show, based on the order.  But, I can't get it to work -- only the SolicitorName will come up and when that is blank (on the form), the next field BrokerName may (or may not be) blank, but nothing else displays.  At least one of the value of fields after Solicitor is available, but it isn't showing.  What's wrong?

@If(SolicitorName != ""; SolicitorName;
BrokerName != ""; BrokerName;
GAName != ""; GAName;
GAOffice != ""; GAOffice;"")
Question by:AliciaVee
    LVL 14

    Accepted Solution

    your formula seems to be in order.

    make sure of the following:
    1. that the fieldnames are correct, no typo error
    2. that the value of blank fields are not " " (space). might want to consider @trim(<fieldname>) != ""
    3. that the fields do exist. ->BrokerName != ""; BrokerName  will not be true if the field does not exists. try @IsAvailable to check if field exists.

    hope this helps.

    Author Comment


    Yes!  Thank you.  @Trim<fieldname) fixed my problem.  Thanks!!
    LVL 14

    Expert Comment

    thanks! :)

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
    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.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    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

    15 Experts available now in Live!

    Get 1:1 Help Now