How to transform a numeric (floating) custom field to an integer?

[Dario Alarcón]

Hello community, I have the following scenario.
There is a custom field of the numerical type called 'Telephone Number', once this field is completed and when viewed in the 'issue view' it appears in decimal format, but I need it to be seen in 'integer' format, that is, There are no periods or commas, since it is a telephone number.
Is it possible to make some configuration in that custom field so that it does the conversion?
Should I create an automation rule?

I tried to create a new custom field (Phone number) of type 'Text Field (single line)', but the issues that are already created stop showing me the previous custom field, therefore I must copy the information from the old field to the new field.

Thank you very much in advance for the help you can give me.

[Vijay Dadi]

Dear @Dario Alarcón ,

Instead of number field, keep the field type as Text field and control the input data type to be numeric only using regex validation. Also you can restrict the number of input characters. Below is the reference.

https://confluence.atlassian.com/proforma/regex-validation-1087521274.html

Hope this helps!

Regards,

Vijay

[Dario Alarcón]

Hi @Vijay Dadi Thanks for your answer!

In the link you gave me, the form was created with ProForm but in my case it is a 'Request type' that is part of an 'Issue type' within the project. Do you suggest that I redesign the 'Request form' and do it through 'ProForm'?

I need to have it available in the Client Portal so they can generate issues, I have never worked with this 'ProForm' tool.

[Vijay Dadi]

Hi @Dario Alarcón ,

I would suggest you to design your form and add it to your request type which will be available on your client portal for issue creation.

This will work as i have implemented this solution multiple times.

Hope this helps !

Regards

Vijay

[Hannes Obweger - JXL for Jira]

Hi @Dario Alarcón

I've seen people doing this via a CSV export/import, as well as via Automation rules; kindly see this related thread for reference.

Alternatively, if you're open to solutions from the Atlassian Marketplace, I believe that this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also allows bulk editing your issue fields via copy/paste, like so:

This works for any number of fields and issues in one action, both within JXL and across JXL and pretty much any other app (like e.g. Excel) - so you should be done with your work in no time. (I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.)

Any questions just let me know,

Best,

Hannes