Dynamics Community Forum Thread Details

Can accountnumber be changed to Auto Number type?

Can the Account field/column "accountnumber" be changed from Data type "Single line of Text" to "Auto Number" type?

1. The Data type on this field is grayed out, like I can't select and option to change it

2. I don't see the Auto Number Data type available to select when I create a new field on Account entity/table.

Hi Allie_B,

You can change any text fields to an auto number data type with the new form editor for Dynamics 365, and the system will start auto numbering this field!

It is definitely possible to change the data type of the account number filed!

And the classic interface does not support creating auto number fields, so we have to use the new form editor which can be accessed through https://make.powerapps.com

Once here and logged in as your User which is connected to the Dynamics 365 Instance you wish to update, you need to ensure that you have selected the correct environment in the header navigation (the environment you wish the new field to be available in).

Expand ‘Data’ and select ‘Entities’. You should see a list of Entities and selecting one will show a screen similar to the below screen, which in my case was the Account Entity.

From the following screen you can select ‘Add column’ create new or edit existing text field ,then screenshot below will be fly out from the right side. The screen will let you set the Name and Type of your field while letting you customize the field. For now we’ll be using the ‘Autonumber’ Data Type.