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

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

Auto Generate an Account Number?

(0) ShareShare
ReportReport
Posted on by

Is there a way to add a field on the Account Form to auto generate a new number whenever a record is created?  Similar to how Case has this out of the box?

I have the same question (0)
  • empath-e CRM Profile Picture
    1,136 on at
    RE: Auto Generate an Account Number?

    Would creating an Auto Number field on the Account entity work for you? Here is an example:

    d365goddess.com/.../

  • CRM Learner 88 Profile Picture
    on at
    RE: Auto Generate an Account Number?

    Wow I think that would work great!  Only problem is it says its not available in the classic interface.  How do I get to that area from the classic interface?  

  • necsa Profile Picture
    3,455 on at
    RE: Auto Generate an Account Number?

    Try following links

    jukkaniiranen.com/.../

    arunpotti.com/.../

    thattechiegirlroma.wordpress.com/.../

  • Suggested answer
    Thomas Goehrig Profile Picture
    20 on at
    RE: Auto Generate an Account Number?

    You will need to open Power Apps (make.powerapps.com)

    Select the solution "account" and click edit

    pastedimage1665006387172v1.png

    pastedimage1665006422987v2.png

    Click "New Column" on the top ribbon

    Enter Display Name "Account ID" or "Account #"

    Select "Autonumber" for data type

    pastedimage1665006543327v3.png

    Complete the following fields:

    1. Autonumbering type: String prefixed number, Date prefixed number and Custom.
    2. Prefix: See preview below
    3. Minimum number of digits for Account ID
    4. Seed value: Where Account ID value starts

    pastedimage1665006792029v6.png

    Click "Save"

    Add "Autonumber" field to "Account Form"

    Return to "Account" Solution and click the drop down next to "Table" on the site map on the left hand side. Click the drop down next to "account" and select "Forms". Choose the form you would like to update and click "Edit"

    pastedimage1665007249720v7.png

    Once the form loads choose the new field and place field within the "Account" form and publish changes. 

    Thanks,

    Tom

  • MH-07050742-0 Profile Picture
    10 on at
    Auto Generate an Account Number?
    Hello,
     
    I beleive I have followed all these steps. And if I upload a list of accounts all of then gets a unique accounID. Example below of an account that was uploaded from a file:
    But when Iclick on NEW (Create a New Account record) the AccountID field in there remains empty and furthermore I cannot save the new record unless I enter a value in the AccountID field. Trouble is it is very hard to know what ID-number to enter. Example below when clicking on NEW:
     
    How can I get the AccountID field to be automatically populated with a new unique ID when I click the NEW-button?
     
    /Mikael Helmers

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 117 Super User 2025 Season 2

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 115

#3
Erin Lubben Profile Picture

Erin Lubben 66

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans