Looking to utilize a custom field answer to drive the assignment of a decision task to an SVD not an individual.
Does anyone have an example of this scenario they have been successful with?
Understand the decision task part of this may be an issue btu thought i’d reach out here while support continues to review.
Thanks!
if custom field answer a then assign to svd a, if answer b then assign to svd b, etc
Hi Mitch,
We use the itemB field as Single Select Lookup with a filtered list from our CMDB. This allows us to use userFieldChar1 as a service department lookup.
Then on the decision task, the SVD expression is set as such: $new.itemB.userFieldChar1 (using itemB). This avoids having the issue of an IF in the dynamic expression that needs to be maintained as the maintenance is done in the CMDB and automatically updates the lookup on the form as well.
In theory you could do the same with a custom field, but I cant find an example of us using a custom Single Select Lookup to drive the same functionality so that dynamic expression might look something like $new.parentEvent.W(“Field”).item.userFieldChar1
Something we’ll give a go! Thank you so much for following up!
If I am understanding what you are asking, then yes, I use this same functionlity in multiple processes, basically to assign a decision (or any task for that matter) to a users local IT based on the value of a custom field (though you could also use a system field).
Where the entire expression looks like this, just a bunch of nested IF statements. Basically, we have a custom field on the Parent event called “BUSINESS UNIT" where we check the value as follows:
If "BUSINESS UNIT" = “VALUE” , ShortCode of Assigned SVD, if not, If "BUSINESS UNIT" = “VALUE” , ShortCode of Assigned SVD, if not… just do the nested IF over and over again, finally ending on if no values match, assign to our base Service Desk service department to figure out.
If($new.parentEvent.W("BUSINESS UNIT").name = "Albany", "PIT_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Atlanta", "ATL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Austin", "SOUTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Autoservice", "SVD", If($new.parentEvent.W("BUSINESS UNIT").name = "Boston", "BOS_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Buffalo", "PIT_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Charlotte", "CAR_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Chicago", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Cincinnati", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Cleveland", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Columbus", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Dallas", "SOUTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Denver", "NORTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Detroit", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "External", "SVD", If($new.parentEvent.W("BUSINESS UNIT").name = "Houston", "SOUTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Huntsville", "HUN_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Indianapolis", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Irvine", "SCA_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Kansas City", "NORTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Los Angeles", "SCA_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Mahwah", "MAH_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Mail Enabled Users,San Antonio", "SOUTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Maryland", "MID_ATL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Maumee", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Memphis", "NAS_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Miami", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Milford", "CON_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Mumbai,International", "INDIA_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Nashville", "NAS_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "New York City", "NYC_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "New York City Corporate", "NYC_HQ_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Not Recognized", "SVD", If($new.parentEvent.W("BUSINESS UNIT").name = "Not Used", "SVD", If($new.parentEvent.W("BUSINESS UNIT").name = "Oakland", "NORCAL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Orlando", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Outside Consultant", "SVD", If($new.parentEvent.W("BUSINESS UNIT").name = "Philadelphia", "PHI_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Pittsburgh", "PIT_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Portland", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Raleigh", "CAR_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Real PM", "SVD", If($new.parentEvent.W("BUSINESS UNIT").name = "Retirees", "SVD", If($new.parentEvent.W("BUSINESS UNIT").name = "Sacramento", "NORCAL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "San Antonio", "SOUTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "San Diego", "SCA_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "San Francisco", "NORCAL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "San Jose", "NORCAL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Seattle", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Somerset", "SOM_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Southern California", "SCA_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "St Louis", "IS_IO_SUPPORT", If($new.parentEvent.W("BUSINESS UNIT").name = "Tempe", "SCA_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Toronto", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Turner International", "INTL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Turner International - ME", "TIME_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Turner International LA", "INTL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Turner International NP", "INTL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Vancouver", "BOOTS", If($new.parentEvent.W("BUSINESS UNIT").name = "Washington Dc", "MID_ATL_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Omaha", "NORTH_CENTRAL_REGION_ISE", If($new.parentEvent.W("BUSINESS UNIT").name = "Iowa", "NORTH_CENTRAL_REGION_ISE", "SVD" ))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.