Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

I need to combine information from two different columns & derive it in third column.

Aditya Raina
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 25, 2024

While configuring a Create a service request page, I have two different columns (Location & Country) Now whenever information is filled in both these columns, I would like that get populated in third column.

 

E.G Client filled 

Location - Nevada

Country - America 

Third column( custom Column) - Nevada_America_

1 answer

0 votes
Anandhi Arumugam
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 25, 2024

Hi @Aditya Raina Something like this should work

Automation Rule_Set  Issue Fields.png

Aditya Raina
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 25, 2024

Screenshot 2024-07-25 at 17.30.59.png

 

Hey @Anandhi Arumugam Please see I have created Channel, Language,customer journey etc, Now all the fields should get populated in Campaign Name column.

Screenshot 2024-07-25 at 17.34.58.png

My automation screen doesn't have same columns as above screen where data can be collated

Anandhi Arumugam
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 25, 2024

Can you type the fieldname in the search bar to see if they appear? Any field available on the Edit Issue screen will appear here. Please check the Edit Issue screen in the Project settings.

Aditya Raina
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 25, 2024

I tried but my columns are not getting displayed. @Anandhi Arumugam That's why bit worried. 

Anandhi Arumugam
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 25, 2024

@Aditya Raina Can you tell me what type of custom fields are Channel, Language,customer journey? There are certain fields not supported by Automation. You need to use JSON for those.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events