Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


CRM 4.0 workflow

Posted on 2008-10-14
Medium Priority
Last Modified: 2012-05-05
Using "or" instead of "and" in workflow

I am trying to say:

If Account:Address 1: State/Province does not equal [NY] or [MA] or [CT],

blah blah blah.

But it seems the condition will only say "and".  I would have also thought I
could use "not in" but it only allows one entry.

If Account:Address 1: State/Province not in [NY]. Can't add any more entries
to this...

Can anyone point me in the right direction?
Question by:simprick
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
LVL 15

Expert Comment

ID: 22715546
2 ways to do this I think
The Not In is a list, so I just type and separate with comma

So State/Province NOT IN MA, NY, CT

it should save and work as expected.

OTHERWISE, you could cascade some IFs.
If it doesn't equal NY, then the next Condition check is the next state, etc.  basically you drop to the "Else" if none of them are equal.  

I tested the first one (somewhat dirty test) but it worked.

Not great documentation on the NOT IN condition.
LVL 15

Expert Comment

ID: 22715555
OK, weird, my second test failed (of the first method)

LVL 15

Expert Comment

ID: 22715773
Alright, so the second method works.

BUT, I also just added each state as a separate Does Not Equal and it created the AND.  Maybe I am confused what you want to do:

MD or PA or DE - do the workflow action
NY or CT or MA - don't do it....

Am I right?
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

LVL 15

Expert Comment

ID: 22715796
When I added the three Does Not Equals...I get a (S/P does not equal NY) AND (S/P does not equal CT) AND (S/P does not equal MA)


Author Comment

ID: 22720122
Thanks WilyGuy.  Here is a little explanation.  States are grouped into sales territories, but not all states just the 17 states we are currently working in.  So I am try to assign leads to the VP of sales if lead is not in one of our currently defined 17 states to determine who to assign the account to.  So I am trying to say (in the most straight forward way)
If Account:Address 1: State/Province does not equal [NY] or [MA] or [CT], (or any of the defined states that are grouped into territories)

then:  Assign lead to VP of Sales (or something to that affect)

I thought of doing the clause for each state but it just seems to be redundant and hard to manage as the states are going to change as the companies grow.  Seems like there should be an easier way to say it.

LVL 15

Expert Comment

ID: 22721529
So you need to just add each state with its own line, then as the states are pulled into territories, you can add a new line.

Still trying to find the syntax for the "NOT IN" (seems like that should be the condition)

Author Comment

ID: 22722285
Take a look at the WorkFlow Main pic "Otherwise, if Lead:State/Province does not equal [ny] AND Lead:State/Province does not equal [ct], then:

I would have thought I could change the "AND" into an "OR" and that would make it pretty easy, I would just have 17 OR statements, but having to do that (Create check condition, then go to WorkFlow Condition screen, add the state, the add another condition, ect, takes forever, but I guess that is the way it has to be done.  Are you able to add more than 2 characters to the NOT IN clause?  I can't.

LVL 15

Accepted Solution

WilyGuy earned 750 total points
ID: 22727222
Yours looks fine.

So if there is no State, you assign to someone
Then if there IS a state you are going to check if it is in a territory, so understand:
- you are trying to get the condition to "fail' (if it doesn't equal 1 AND if it doesn't equal 2 AND if it doesn't equal 3 assign it to this person).  So you are "bundling" that in a "If it isn't in our existing territory - do this"

I was able to add multiple characters to the NOT IN clause.  It is funny that all the DOES NOT EQUAL in an advanced find end up as a SQL statement with a NOT IN....  

Still no advancement on the NOT is not available when using Picklists or Lookup fields.  You CAN add a Dynamic Value there.  not sure what the functionality is supposed to be.  I think you can do a comparison to already established values (dupe checking maybe)

I FINALLY got the NOT IN to do SOMETHING :).  I said if Account:State/Province NOT IN Primary Contact State/Province make the Account main Phone number 5.
I then created a Contact with a State of MD and then created an Account in VA with that as the Primary Contact and sure enough it changed the number.  Then I made another account in MD with that as Primary and it didn't change it.  I feel like it could be useful, but not sure how yet.

Hope that finished answering the question you didn't really ask, while answering the one you did.

LVL 15

Expert Comment

ID: 22727227
of course, I can also do that with Does Not Equal....sheesh.

Author Closing Comment

ID: 31505909
Thanks WilyGuy.  I think I liked the workflow in 3.0 better.

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question