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 70 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.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can accountnumber be changed to Auto Number type?

    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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,289 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans