nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Set Number Format on a layer attribute table

KarlBeal

I have a layer feature table with fields joined from a plugin datasource. How can I programmatically change the number format on a joined field?

Vind meer berichten getagd met

Accepted answers

GKmieliauskas

Hi,

You need to set NumberFormat property in layer field description:

var fieldDescriptions = featureLayer.GetFieldDescriptions();
foreach (var fieldDescr in fieldDescriptions)
{
    if (!fieldDescr.IsVisible || fieldDescr.Name == shapeField) continue;
    if(fieldDescr.Type == FieldType.Integer)
    {
        var custNumbFormat = new CIMCustomNumberFormat();
        custNumbFormat.FormatString = "###-##-####";
        fieldDescr.NumberFormat = custNumbFormat;
    }
}
featureLayer.SetFieldDescriptions(fieldDescriptions);

All comments

KarlBeal

Apologies I missed that line in your original post. Works as expected now.

GKmieliauskas

You need to set back field descriptions after modifying using SetFieldDescriptions method.

KarlBeal

The code shown below is after a join. I do not see a change to the formatting in the attribute table after this executes.

var layerDef = layer.GetDefinition() as CIMFeatureLayer;
JoinLibrary.UpdateJoinTable(layerDef, oldTableName, newTableName); // setup join here
layer.SetDefinition(layerDef);

// Attempt to update numeric format
var fieldDescriptions = layer.GetFieldDescriptions();
foreach (var fieldDescr in fieldDescriptions)
{
    if (fieldDescr.Type == ArcGIS.Core.Data.FieldType.Double)
    {
        var custNumbFormat = new CIMNumericFormat();
        custNumbFormat.ZeroPad = true;
        custNumbFormat.RoundingValue = 6;
        fieldDescr.NumberFormat = custNumbFormat;
    }
}

GKmieliauskas

Hi,

You need to set NumberFormat property in layer field description:

var fieldDescriptions = featureLayer.GetFieldDescriptions();
foreach (var fieldDescr in fieldDescriptions)
{
    if (!fieldDescr.IsVisible || fieldDescr.Name == shapeField) continue;
    if(fieldDescr.Type == FieldType.Integer)
    {
        var custNumbFormat = new CIMCustomNumberFormat();
        custNumbFormat.FormatString = "###-##-####";
        fieldDescr.NumberFormat = custNumbFormat;
    }
}
featureLayer.SetFieldDescriptions(fieldDescriptions);

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.