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

  • 24 July 2015
  • 3 replies
  • 16 views

Userlevel 3
Badge +16

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


3 replies

Userlevel 5
Badge +16

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

Userlevel 5
Badge +16

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

 

Badge +10

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!

Reply