nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to dynamically populate custom field with values from excel

Maryam Nadir

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

Accepted answers

All comments

Sebastian Krzewiński

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

Maryam Nadir

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.

Maryam Nadir

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

Julie d_Antin _Elements__bsgnak

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 ?

Maryam Nadir

Yes, you are right...the values of EXcel/CSV gets updated regularly. It basically has the list of employee names of my organisation.

Bharathi

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud