Hi all,
Does the CRM automatically assign each lead a system generated unique ID?
If so, where can I find it?
Many thanks
David
*This post is locked for comments
Hi Aileen,
Can you please help me for retrieving leads from CRM..
I posted a question here -- community.dynamics.com/.../215055
am using this - jlattimer.blogspot.in/.../PHP
Thanks!
I would correct myself, yes there is something called GUID, but I can understand you are looking for something like LD-AU-0001, while GUID is a 32 characters string, for which you will have to do a lot of customization to get it on the form, moreover, it does not make sense to Auto-number a lead with 32 characters. And on top of that if you are using CRM online, it would be a lot of clarical work to get it via excel export & reimport.
My solution in the above post, will let you decide the pattern of auto-number/Lead ID you want to get on Leads form
Thanks
Hi David,
Yes, Dynamics CRM automatically assigns a Unique ID which is also referred to as GUID (Global Unique Identifier) when a new record is created. The GUID is stored in a specific system field called <EntityNameID> like "leadid", "accounted", "incidentid".
All activity entities GUID is stored in "activityid".
The GUID is in the form of "8-4-4-4-12" set of characters.
eg: 541067bd-4db1-2208-e5b0-a601ead56d03
However, this is not a user friendly set of characters which can be used to identify records in Dynamics CRM, there you can specify a more user friendly Unique ID for your Leads (Like the one for Case Record - CAS-00002-B8K4H9).
You can create a Custom Field and then create a Real Time Workflow to update the field with your own unique id.
Here is one good article on achieving this
community.dynamics.com/.../auto-numbering-with-crm-workflows-real-time-vs-asynchronous.aspx
Hope that helps
Please mark my post as verified if you found it helpful
If you are not using contracts, case, articles, Quotes, orders , invoice or campaigns.. then you use CRM auto numbering for one of your entity.
Suppose you are not using Contracts..
Then create workflow on lead entity creation as follows
When creating Contract record set only required fields to create contract..
Then copy the contract Id to Lead Id field.. here I am using Job Title attribute to show..
Then activate your workflow..
Create lead record..
You will lead Id will auto numbered..
You are using CRM auto number functionality.. so CRM is taking care of unique number.. you can easily configure your auto number with CRM.. by adding pre fix, ID length etc.
Note: Only thing you need to do is that you need to delete contract records created during this process by scheduling bulk delete operation..
This is easy way to generate auto number..
Hope this will work..
You can use Advanced auto number solution from codeplex to set uniqueue number to eash leads
advcrm2011autonumber.codeplex.com
Mognoose,
Yes, it does. All of CRM entity record has the unique ID assigned by CRM.
community.dynamics.com/.../121490.aspx
In your case, the Lead entity, yes, it does as well. "leadid" is the field name.
You can find it through SQL,
select leadid from lead
but you are using CRM Online so you can get it once you export to excel (include and tick the re-importing data feature) or using odata query, power query connect to CRM.
But it is a system generated ID, 32 characters GUID with dashes. If you want to build new one you need to create yourself or re-use the read-made solution (free and paid), generate the Running Number
www.powerobjects.com/.../powerautonumber
Hope this helps you!
Thanks.
No unique ID is assigned by default from the system; you need to install a free unique id solution in CRM and configure it as per your requirement, its easy
Download the solution from here & read the steps to do:
www.planetxrm.com/microsoft-dynamics-crm-2013-2011-auto-id-generator
Other way is by creating a real time workflow; follow the below URL:
if my post has helped you, please mark it as verified
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Aric Levin - MVP 2 Moderator
MA-04060624-0 1
