AnsweredAssumed Answered

What's the best way to represent a Year field in an Enterprise Geodatabase & Web AppBuilder? 

Question asked by jamatney on Nov 7, 2016
Latest reply on Nov 9, 2016 by rscheitlin

I have a Fiscal Year Start field in a Feature Class which is shared as a Feature Service in a Web Map > Web Mapping Application (built with Web AppBuilder) workflow. The field must only contain 4-digit years, therefore, I cannot set the field to data type 'Date'. Instead, the field uses a Short Int data type with precision 5 (I set the precision to 4 but ArcGIS automatically changes it back to 5). Here are the field properties:

 

Feature Class Properties

Layer Properties

Number Properties

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now, I can go into the config attribute settings in my Web Map and turn off the 1000 separator option. This works for displaying the years correctly in the Web Map. However, this does not carry over to the Web Mapping Application. When I use the Filter widget in the Web Mapping Application, the 1000 separator returns.

No 1000 Separator
Filter Widget Fail

I initially tried to get around this problem by using a Text field for year input, but that option does not work for this workflow due to the presence of a GeoForm - the GeoForm is  where data is entered for the project. The reason a text field does not work is because the GeoForm Fiscal Year Start field must throw an error if a non-4-digit-integer is entered, i.e., FY17, or 17.

 

Screenshot

 

Essentially then, my question is this - is there a better solution for representing a year in a geodatabase? This ideal solution would do the following:

  1. Have data entry limited to no more or less than 4-digits
  2. Throw an error if a non-integer was used during the data entry process in a GeoForm
  3. Would not use a 1000 separator to display a 4-digit integer in Web AppBuilder

 

Thanks in advance.

 

(By the way, is there a way to change the Error Message of 'Please enter a valid integer between -32768 and 32767.'? I'd much rather it said what the help text says, e.g., 'Enter a fiscal year as the four-digit year...'.)

Outcomes