Sharpharp1
Apprentice

Advanced Rule with "DOES NOT START WITH"???

Doing some Advanced rules i need to say that If a field equals Staff and then the User ID field DOES NOT start with a?

In the Rules Wizard, there is only a STARTS WITH operator, there is no DOES NOT 

 

ANy ideas how i achieve the "User ID DOES NOT START WITH" rule in an advanced rule?

 

Thanks

0 Kudos
Reply
3 Replies
Albarghouthy
Apprentice

Re: Advanced Rule with "DOES NOT START WITH"???

Hi sharpharp1,

 

Use an expression( !starts with(field, a))

 

notice that Im using NOT in my expression "!"

 

in you advance condition you check if the expression result equals true or false

0 Kudos
Reply
Albarghouthy
Apprentice

Re: Advanced Rule with "DOES NOT START WITH"???

Accordin to my previous response, I've took screeshots of the solution, check the following:

 

2633i3D1360C568C40E1C.png

0 Kudos
Reply
AAschenbrener
Apprentice

Re: Advanced Rule with "DOES NOT START WITH"???

In K2 5 -  I'm trying to filter a picker down to where the AD Name does NOT include records starting with xxx 99.

 

I created an expression

<>NOT(Startswith(name,xxx 99))

 

And then on the list populate input I put the expression in along with tried setting a filter where

Name = 'expression'

Name not equal 'expression

 

 

How did I create my expression correctly?

Thanks!

0 Kudos
Reply