• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

Multiple Conditions in @If formula

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;"")
  • 2
1 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.
AliciaVeeAuthor Commented:

Yes!  Thank you.  @Trim<fieldname) fixed my problem.  Thanks!!
thanks! :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now