validation

Question

Hi, 
 
 i have a picker field when i select some particular users names it has to show validation message else no 
 i have written like this but it is showing for all users whoever i select in picker field

KM · Accepted Answer

if(
 isusermemberofgroup(
 ri!approver_txt,
 {
 cons!CR_GRP_BOARD_OF_DIRECTORS_GROUP
 }
 ),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[3],
 if(
 isusermemberofgroup(
 ri!approver_txt,
 {
 cons!CR_APP_GRP_HOC_GROUP,
 
 }
 ),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[3],
 if(
 isusermemberofgroup(
 ri!approver_txt,
 {
 cons!CR_APP_GRP_DCEO_GROUP
 }
 ),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[3],
 if(
 isusermemberofgroup(
 ri!approver_txt,
 {
 cons!CR_APP_GRP_CEO_GROUP
 }
 ),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[3],
 null
 )
 )
 )
 ) 
 this worked

Naresh · Answer

Hi, 
 you can update you logic like below 
 if(
 a!isUserMemberOfGroup(
 ri!approver_txt,
 cons!CR_GRP_ALL_CCC_USER_GROUP
 ),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[3],
 ""
)

venkyuppala09 · Answer

Isusermemberofgroup returns boolean value but here your checking with Text/user type, Don't check the value use Isusermemberofgroup alone like below.

venkyuppala09 · Answer

Check with below code, If it throws same error check the groups security. 
 if(
 not(isusernametaken(ri!approver_txt)),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[2],
 if(
 ri!approver_txt = loggedInUser(),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[1],
 if(
 a!isUserMemberOfGroup(
 ri!approver_txt,
 {
 cons!CR_GRP_ALL_CCC_USER_GROUP,
 cons!CR_GRP_BOARD_OF_DIRECTORS_GROUP
 }
 ),
 cons!CR_NEXT_AUTHORITY_VALIDATION_MESSAGE[3],
 null
 )
 )
)

Mike Schmitt · Answer

Please note also that if you're on a reasonably modern version of Appian, you should be using the newer function a!isUserMemberOfGroups() , which automatically handles checking many groups (and built-in logic for requiring the user to be a member of all listed groups or any listed groups).

validation

Top Replies