Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Answered

Can accountnumber be changed to Auto Number type?

Posted on by 69 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans