You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I hope someone could help me find a better way or answer to my problem. Here's the background....
I got a custom cascading field named: Issue category/sub-category
A custom field for Functional area
And another custom field for Resolver group
The issue category/sub-category has more than 110 values in it. Sample list is...
|Category||Sub-category||Functional area||Resolver group|
|Application (Non-SAP)||Blueprint||Commercial||IT Commercial|
|Application (Non-SAP)||Corum||Commercial||IT Commercial|
|Application (Non-SAP)||Salesforce||Technology||Salesforce Team|
|Application (Non-SAP)||Jira||Technology||Jira Administrator|
|Application (Non-SAP)||KIA||Commercial||IT Commercial|
|Application (Non-SAP)||LAMLab||Commercial||IT Commercial|
I created an automation rule when issue category/sub-category is change to assign the appropriate Functional area and Resolver group.
My problem is when I was about 3/4 writing and saving my IF-THEN-ELSE statements I got an error where it says I reached the limit of 65 conditions per automation rule.
What is the best way doing the automatic population of fields based on another field values? I checked Lookup table, but I think it is not fitted to my requirements. I'm hoping not to buy any add-on app.
Hi @Zaldy Parian,
From the sample list, it seems several types of requests end up with the same resolver groups. Assuming that the number of resolver groups is a lot smaller than 65, can't you use JQL conditions grouping the number of combinations to either update your field or just set up Service Desk queues based on JQL instead of updating the field?
Hope this helps!
Thanks for your reply. I actually use JQL as condition. One example that has small list is this.....
project = "SDM " AND issuetype in (Incident, "Service Request with Approvals", Problem) AND
"Issue category" in cascadeOption ("Application (SAP)", "OpenText") OR
"Issue category" in cascadeOption ("Application (SAP)", "FICO") OR
"Issue category" in cascadeOption ("Application (SAP)", "Finance Supply") OR
"Issue category" in cascadeOption ("Application (SAP)", "Finance Tech")
assign to- Corporate / SAP Finance Management
And I do have queues for each Resolver group. But the Resolver group field needs to be populated first on create or on update. Which is the automation is doing.
And I could not add anymore condition because I max out the limit of 65 conditions.