A custom auto number solution is required to set various auto number fields.
The Auto number generation is required for many entities which should cater for a wider range of numbers with different formats. Below are some examples of formatted pattern for auto number value.
| Entity | Entity Field Label | Format | Prefix | Increment | Example |
|---|---|---|---|---|---|
| Account | Account_Id | Prefix + 8 digits number | ACC- | last number + 1 | ACC-00000001 |
| Contact | Contact_Id | Prefix + 8 digits number | PER- | last number + 1 | PER-00000001 |
The Auto Number solution framework needs to be able to generate padded strings in various formats. A configuration entity “Auto Numbers” will be added to manage the auto numbers going forward. The Plugin will read the Auto Number format for each entity from this configuration entity.
Source code - ref at: AutonumberGeneration
- Optimistic concurrency: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/optimistic-concurrency