if() function

Question

Could someone explain why the following code work without compiler errors? 
 
 if(
 isnull(ri!user),
 "",
 isusernametaken(ri!user),
 user(ri!user, "firstName") & " " & user(ri!user, "lastName"),
 joinarray(split(ri!user, "."), " ")
) 
 
 I expect some kind of evaluation error, but it works just as the three lines starting on "isusernametaken" were an embedded if. 
 I saw that in one of the Appian courses and I'm wondering if it is some undocumented feature of the if function. 
 Thank you

Dave Lewis · Accepted Answer

if() has hidden else if functionality in it. What's documented is: 
 if( 
 condition 
 return if true, 
 return if false 
 ) 
 What you can do with it: 
 if( 
 condition1, 
 return if condition1 true 
 condition2 if condition1 false {else if} 
 return if condition2 true 
 return if condition2 false 
 ) 
 Or you can do it with 7, 9, 11, 13. Every odd input is another conditional until the very last one, what returns if they're ALL false. 
 It's way less keypresses, but gets dramatically unreadable.

Richard Michaelis · Answer

if() has 3 parameter 
 condition and true, false statement https://docs.appian.com/suite/help/22.1/fnc_logical_if.html 
 if you like to use more check a!match() https://docs.appian.com/suite/help/22.1/fnc_logical_match.html -> this is just a kind of mistake in the appian course. at least unproper use.

if() function

Top Replies