Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Switching a custom field from text to numeric only?

Darren Smith February 12, 2021

Hi all,

Having read some posts online, once a data type for a custom field has been added, it's pretty much set in stone. The easiest option appears to be create a new custom field and migrate the ticket information across. But what is the best way of going about this?

It was my mistake to begin with. An internal reference (which is just six numbers) I created as a text field. Now, with nearly some 500 tasks generated later, I'm wondering if I can create a new numeric reference field and migrate the tickets to use this field instead?

Is this possible?

Kind regards,

Darren.

2 answers

1 vote
Aiden Marriott
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 12, 2021

After you create the new field you could export all your data, then bulk import the data back into Jira with value going to the new field.  Then you would remove the old text field from the screen.  

Or you could use an automation rule to loop through all your issues and copy from one field to the other.

1 vote
Mikael Sandberg
Community Champion
February 12, 2021

One way of doing it is to use an automation rule, I would use a scheduled one because you manually trigger that one, that copies the value from your text field over to the new numeric field.

Suggest an answer

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

Atlassian Community Events