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
Hi folks! I have 4 custom fields (Impact, Likelihood, Risk score and Risk rating). Impact and Likelihood are single choice dropdown fields, where predefined values are stored. Based on those values of what you have selected, Risk score is automatically calculated via automation. Based on Risk score, Risk rating should be assigned again automatically.
For example, if Risk score is equal 4 or less, Risk rating should get the value LOW. If Risk score is between 5 and 9, Risk rating should be MEDIUM and so on. But my automation didn't work, however when I manually type Risk score and hit ENTER, it works. What should I change, that the Risk rating get automatically a corresponding value?
Here are the fields:
As you can see, Risk score calculation automation works, but Risk rating allocation automation not.
Here is my Risk score calculation automation:
And here is the second automation, which didn't work:
You seem to have 2 rules, one which makes field changes that could trigger the other rule.
By default, automation prevents that to avoid errors/run-away rules. You can enable this for the second rule by looking in the details at the top and enabling the option "Allow Rule Trigger".
Thank you @Bill Sheboy . It has worked. A question: is there any way to prevent that the calculated value gets manually changed by user after the calculation? For example impact is 2, likelihood is 2, it gives me the risk score 4, therefore my risk rating gets automatically assigned the value LOW. But if I change manually the risk score to 8, risk rating will change to MEDIUM, which is technically correct, but not what I want.
So basically risk score should be automatically calculable, but not manually changeable. What do you think about the idea?
I have not tried that, although I recall some posts about making fields that can only be set through automated rather than manual changes. If you do not need to see the field Risk Score, you could either eliminate it (using one rule) or use an entity property to conceal it.
Alternatively to keep the Risk Score visible...a work-around is a modification to your rule which detects a change to the field: