AliciaVee
asked on
Multiple Conditions in @If formula
Experts,
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;"")
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;"")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
thanks! :)
ASKER
Yes! Thank you. @Trim<fieldname) fixed my problem. Thanks!!