create_autonumber_column
Add an AutoNumber column to Dataverse tables that automatically generates unique alphanumeric identifiers using sequential numbers, random strings, and datetime placeholders with custom formatting.
Instructions
Creates a new AutoNumber column in a Dataverse table with specified format. AutoNumber columns automatically generate alphanumeric strings using sequential numbers, random strings, and datetime placeholders. Requires a solution context to be set first.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
autoNumberFormat | Yes | AutoNumber format using placeholders like "PREFIX-{SEQNUM:4}-{RANDSTRING:3}-{DATETIMEUTC:yyyyMMdd}" | |
description | No | Description of the AutoNumber column | |
displayName | Yes | Display name for the AutoNumber column (e.g., "Serial Number") | |
entityLogicalName | Yes | Logical name of the table to add the AutoNumber column to | |
isAuditEnabled | No | Whether auditing is enabled for this column | |
isValidForAdvancedFind | No | Whether the column appears in Advanced Find | |
isValidForCreate | No | Whether the column can be set during create | |
isValidForUpdate | No | Whether the column can be updated | |
maxLength | No | Maximum length for the column (default: 100, ensure enough room for format expansion) | |
requiredLevel | No | Required level of the column | None |
schemaName | No | Schema name for the column (auto-generated if not provided) |
Input Schema (JSON Schema)
{
"properties": {
"autoNumberFormat": {
"description": "AutoNumber format using placeholders like \"PREFIX-{SEQNUM:4}-{RANDSTRING:3}-{DATETIMEUTC:yyyyMMdd}\"",
"type": "string"
},
"description": {
"description": "Description of the AutoNumber column",
"type": "string"
},
"displayName": {
"description": "Display name for the AutoNumber column (e.g., \"Serial Number\")",
"type": "string"
},
"entityLogicalName": {
"description": "Logical name of the table to add the AutoNumber column to",
"type": "string"
},
"isAuditEnabled": {
"description": "Whether auditing is enabled for this column",
"type": "boolean"
},
"isValidForAdvancedFind": {
"description": "Whether the column appears in Advanced Find",
"type": "boolean"
},
"isValidForCreate": {
"description": "Whether the column can be set during create",
"type": "boolean"
},
"isValidForUpdate": {
"description": "Whether the column can be updated",
"type": "boolean"
},
"maxLength": {
"default": 100,
"description": "Maximum length for the column (default: 100, ensure enough room for format expansion)",
"maximum": 4000,
"minimum": 1,
"type": "number"
},
"requiredLevel": {
"default": "None",
"description": "Required level of the column",
"enum": [
"None",
"SystemRequired",
"ApplicationRequired",
"Recommended"
],
"type": "string"
},
"schemaName": {
"description": "Schema name for the column (auto-generated if not provided)",
"type": "string"
}
},
"required": [
"entityLogicalName",
"displayName",
"autoNumberFormat"
],
"type": "object"
}