web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Answered

Can accountnumber be changed to Auto Number type?

(0) ShareShare
ReportReport
Posted on by 74 User Group Leader

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.

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    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.

    pastedimage1635386214607v2.png

    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.

    pastedimage1635385943135v1.png

    You can refer following link for more details:

    Auto Number Fields – Dynamics 365 Talk (d365goddess.com)

    Note:

    The classic interface can't change data type of accountnumber field, and can't support Auto Number for any fields.

    pastedimage1635386296127v3.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 75 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 52 Super User 2025 Season 2

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 42 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans