topic Re: Default or Force column to store Upper Case? in ArcGIS Pro Questions

Default or Force column to store Upper Case?

LorindaGilbert — Wed, 11 Aug 2021 21:15:02 GMT

Hi All,

Working on setting up a project and the client has asked if there is a way to enforce a column's value to always be upper case. I see the arcade function of Upper(value), tested it and it didn't do what I expected.

Any sage advice out there for how to do this? It will be published to be used in a web app as well.

Thanks,

Lorinda

Re: Default or Force column to store Upper Case?

DavinWalker2 — Thu, 12 Aug 2021 00:39:02 GMT

Attribute rules should be able to help you achieve your outcome.

Re: Default or Force column to store Upper Case?

LorindaGilbert — Thu, 12 Aug 2021 13:25:55 GMT

I tried it with an attribute rule.

var cmts = $feature.Comments

Upper(cmts)

return cmts;

Applied after adding test string, still lower case. Did I miss something in this one? Did as a calculation rule, maybe it should be a constraint rule?