Answered

change default options with creating a new table column

(0) Share

Report

Posted on by EricArcher33

When I create a new table column, under advanced options the "Enable Auditing" option is always checked, and I am manually turning it off most of the time. Also, the "Sortable" option is never checked, and I am turning it on more often than not.

Is it possible to change the defaults? If so... HOW?!

Categories:

Tables

All responses (2)

Answers (1)

EricArcher33 13 on at

Like (0)

Report

change default options with creating a new table column

Thanks SaiRT14 for the quick response and detailed explanation.

That makes sense as a solution, but is a little beyond my current understanding and ability to execute as I am still learning about all of this. I don't even know how to access either of those options yet! For now I will just proceed with the couple of extra clicks per column, but this will be something that I dig into in the near future.

Good to know there is a way to do it though, thanks again!
Verified answer

SaiRT14 1,926 on at

Like (1)

Report

change default options with creating a new table column

Hi EricArcher33,

You can use the Dataverse PowerShell module or the Dataverse Web API to automate the creation

User Dataverse SDK with powershell script.

Connect-CrmOnline -ConnectionString "AuthType=OAuth;Url=https://yourorg.crm.dynamics.com;ClientId=xxxx;ClientSecret=xxxx"

$entityName = "your_table_name"
$columnName = "your_column_name"

New-CrmAttribute -EntityLogicalName $entityName -SchemaName $columnName `
-AttributeTypeCode Decimal `
-MaxLength 100 `
-AuditingEnabled $false `
-Sortable $true

Create a template solution with commonly used column configurations

thanks