Populate multiple fields based on combined value of other fields...?

[Will]

This seems complicated but doable.

Requirement

A user has requested that based on the combination of these fields' values @ point of creation...

• Issuetype
• Component
• Environment (customfield)

...use a post-function to populate 4 user-picker fields' values:

• Assignee
• Sponsor (custom userpicker field)
• BSA 1 (custom userpicker field)
• BSA 2 (custom userpicker field)

And if no predetermined pattern is found, only assign to project lead leaving all other fields alone.

There are 60 possible combinations that I have in a spreadsheet so I assume that will mean 60 separate post functions..?

For Example

IF

• Issuetype = "Bug"
• Component = "Survey" (and what would happen if multiple components were selected??)
• Environment (customfield) = "Production"

THEN

• Assignee = user1
• Sponsor (custom userpicker field) = user2
• BSA 1 (custom userpicker field) = user2
• BSA 2 (custom userpicker field) = user1

ELSE

do nothing, try next post function

Thanks for any help you can provide, Will

[Fidel Castro Armario]

Hi Will,

You can implement it using 4 Set a field as a function of other fields post-functions, one for each field to be set: Assignee, Sponsor, BSA 1 and BSA 2.

You should use configurations like this one:

For setting 'Assignee':

• Field to be checked...: it doesn't matter the value.
• Target field: Assignee:
• Setting rules:

[%{00014} = "Bug" AND %{00094} ~ "Survey" AND %{00070} = "Production"]user1

where

• %{00014} is field code for Issue type.
• %{00094} is field code for Components.
• %{00070} is field code for Environment.
• user1 is the username, not to be confused with user's full name.

You should use one setting rule for each combination of values of fields Assignee, Sponsor, BSA 1 and BSA 2, but you can also write some rules in a way that can be applied to more than one combination of values, like this ones:

[%{00014} in ["Bug", "Story"] AND (%{00094} ~ "Survey" OR  %{00094} ~ "Web") AND %{00070} in ["Production", "Test"]]user1

[Will]

Thank you for your continuous amazing help! :)

[Fidel Castro Armario]

You are welcome :-)