2

For example if I had a "date" field (d = day digit, m = month letter, y = year digit) I could restrict entries to dd-mmm-yyyy instead of any number of different entry types(e.g. dd-mmm-yy or mmm-dd-yy or etc.) a user might enter.

A real life example using above entry types: User "A" creates a new feature in a feature class and in the "date_created" field user A enters 01-JAN-2015. User "B" creates a new feature in the same feature class and in the "date_created" field user B enters 01-JAN-15. User "C" creates a new feature in the same feature class and in the "date_created" field user C enters JAN-01-15. These are all valid entries for a "text" type field and 100% accurate for the date but it is incredibly frustrating to SQL. To prevent this I am hoping that ESRI file geodatabase or feature classes have input mask capabilities like Microsoft Access does. Below is an example of input mask for access database.

Example of input masks for access database

I am using ArcGIS 10.2 for Desktop.

4
  • 3
    Please edit the question to include the software product and version you are using, and the version of the file geodatabase itself. You'll probably want to clarify what you mean by wanting both "a lot of flexibility" and "only one way" to enter data.
    – Vince
    Commented Jan 6, 2015 at 16:36
  • Are you implying that you want the field to be formatted dd-mmm-yyyy regardless of how the user enters it? Commented Jan 6, 2015 at 17:37
  • Would you use a date field instead of a text field? This should provide the required flexibility for the date format. Commented Jan 7, 2015 at 8:28
  • @AlexTereshenkov Good suggestion but as far as I know the "date" field only has one input type (e.g. 1/7/2015). It will convert most other similar entry types to that one input type, which is nice for data integrity. But not being able to switch the input type to a more preferred type is what I'm hoping an input mask would allow me to do. Also, the above date example is just one of many in regards to data type, phone numbers, people names, are other kinds of data I would like an input mask for.
    – Lotalota
    Commented Jan 7, 2015 at 19:46

1 Answer 1

1

After talking with ESRI, they do not have this functionality at this point. Development of this enhancement is unknown.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.