Mandatory/enforced field value entry

MikeLouwrens — Thu, 22 Sep 2022 20:08:56 GMT

We have a database system that has some fields that must be filled in before the user can save a new record. If they leave those fields blank they're prompted to fill them in or cancel and lose changes.

We'd like to see the same functionality in the Geodatabase where ArcMap prompts the user to populate mandatory fields. A default value won't work as these are often fields where the user would need to make a decision about what value to use, but we can't allow no value in the field.

There is an option "Field Is Nullable" when adding a new field via ArcToolbox. This doesn't do what we require, as all it does is leave a 0 or blank value in a field rather than a NULL. It doesn't notify the user or refuse to save etc. if the field hasn't been populated. What we need is another option here something like "Field Value Mandatory" where a value that isn't blank or NULL or 0 - some kind of user input - is required.

idea Mandatory/enforced field value entry in Data Management Ideas

Mandatory/enforced field value entry