Community
Products
Jira
Questions
How to dynamically populate custom field with values from excel

How to dynamically populate custom field with values from excel

I need help!!!

I am new to JIRA...and I am setting up a new project.... One of the custom fields in my issue needs values to be populated from excel sheet.

I have no clue about how to get this done

I would be grateful if some kind soul guide me on this

3 answers

0 votes

Hi @Maryam Nadir,

Since you've mentioned that the list of users in the excel are the employees of your organization, if you need them all to be onboarded to Jira as well, you can check the possibilities of turning on automatic Jira access for all new hires which will in turn onboard them into Jira. This will in turn keep the user base up to date.

The custom field can then be configured as a user picker field which can automatically fetch its values from Jira's user base.

Thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

@Nic_Brough__Adaptavist_ I saw you reply in one of the threads. Could you kindly help

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi @Maryam Nadir

Do you need to add value to custom field in issues or you need to set values for custom field?

For add values in issues you can use csv import - https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

Regards,

Seba

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks a lot for your reply!

I need to set values to custom field... like when creating new issues, this custom field should fetch values dynamically from a excel or csv file.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Maryam Nadir

Are the values in your Excel/CSV file being regularly updated by people? Or is it just that the list of values is very long? Is that the reason you don't want to add the custom field options within Jira?

You mention fetching the valus dynamically: do you need to set the value of the custom field based on another field? For example, if component is X, set custom field to Y ?