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

Question

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_b69v44 · Answer

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 · Answer

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

Dario Alarcón_opetk4 · Answer

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.