CRM 4.0 workflow

Posted on 2008-10-14
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?
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

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 250 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 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