- edited description
Populate multiple fields based on combined value of other fields...?
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
Comments (4)
-
reporter -
repo owner 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
-
reporter Thank you for your continuous amazing help! :)
-
repo owner - changed status to resolved
You are welcome :-)
- Log in to comment