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

Page 1 / 1

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

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

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!

Sign up