Field Properties

The field properties screen is displayed whenever you add or edit a field from the Add/Remove Fields screen.  

Field Name
The name of this field.  It is recommended that you keep these names shorter than 15 or 20 characters so that they fit on the feature form and feature table views without wrapping.

Field Type
The field type controls how the data in a field is entered and displayed.  You can choose from any of the following field types when adding a new field.  When changing the field type of an existing field not all options are available.

TEXT This is a catch all field type that will store any type of value you want to type into it.  Text fields can store up to 10,000 characters each.

NUMBER If your field is intended to store either integer or decimal values use the NUMBER field type so that those values will be sorted correctly.  

DATE  If your field is intended to store date or date+time values then use the DATE field type.  This field type causes all entered values to be automatically converted to a standard format making perform better in sorting and searching.  The DATE field type lets you enter values in varying precisions.  For example, all of the following are valid for a date field.  "1994",  "2015-11", "2016-02-23", "2004-04-01 13:32:01"

PICK  A pick field lets you specify a list for the user to choose from when they enter a value into this field.  Pick list values are displayed and sorted as text values.  Enter one value per line in the box provided.

LOG  A log field is special field that can be added to any layer for the purpose of keeping a historic record of things that happen to each feature.  See Log Field topic for more details.

ATTACH An attachment field is another special field that can be added to a layer for the purpose of cataloging pictures and documents that you want to associate with your features.  See Attachments for more details.

LENGTH This is a special field type that calculates and displays the length of the feature.  This calculation is automatically done each time you click on a feature.  So if you adjust a vertex point on a line, this value will automatically update.  Indicate the units that you want this value displayed as.  We recommend you name this field "GIS Length" to indicate that this field is automatically calculated by the GIS system rather than being an actual measurement recorded from the field.

AREA This works similarly to the LENGTH field type described above but it calculates area instead.

CENTROID This field type displays the latitude/longitude coordinates of the feature.  This value is calculated fresh each time you click on a feature so if the feature gets moved on the map then this value will reflect coordinates of its new location.

EXPRESSION This field type displays a value calculated based on a custom expression that you enter here.  This expression can use common math operators like + - / * and it can be based on the values of other fields.  Add a field name to your expression surrounded by square brackets and the value of that field will be inserted into the expression at that point whenever the value gets calculated.

Example 1:
Here is an example of an expression that calculates the volume of a pipe in gallons based on the pipes diameter in inches and length in feet.  This expression assumes you have fields in your layer called "Diameter" and "GIS Length".
  ([GIS Length]*(([Diameter]/2)*([Diameter]/2)*3.1416)/144)*7.48

Example 2:
Expressions can also be used to generate useful text values.  An expression like the one below could be used to generate a hyperlink to online SCADA information about your lift stations.  Note how it uses a "Name" field from the layer to create a deep link to that specific lift station's web page.

EXPANDEDLINK Adding an "ATTACH" field to your layer lets you take pictures or import documents for any feature on your layer.  But whenever you import a layer that contains references to already aquired documents you can use this EXPANDEDLINK field type to setup a link from the document file name, stored in this field, to the actual documents.  You can either host these documents on some other hosting site or you can send them to us and we can host them on our server.  Either way, this field type allows you to specify WHERE these documents are stored.  Here is an example of how you would use this:
Example 1:
1. This example assumes you have a shapefile that you created in some other GIS software and one of the fields in this layer contains a document file name for each feature (ie. "MH12345.jpg").
2. First you import this shapefile
3. Next you upload your pictures to some website that hosts pictures or you send them to us and we will host them.
4. Open the "Add/Remove Fields" screen for this newly imported layer and click the chg link next to the field name that contains the document file names.
5. Change the field type to EXPANDEDLINK
6. In the link template section enter the full path to the location where your documents are hosted.  For example,[FILENAME]
7. Note: Notice the place holder [FILENAME] is used in this template in place of the actual document file name.  Whenever you click on a feature of this layer, a link will be displayed matching this template but with this place holder replaced with the file name from this field.  If your file names stored in the layer contain paths such as "C:\Project1\Pics\MH12345.jpg" then the path will be stripped away and only the "MH12345.jpg" will be inserted into the link in place of [FILENAME].

Example 2:
The above example assumes that all your file names are unique since all files will be assumed to be in the same location at the hosted site.  If, however, your data contains relative paths that should be preserved, such as "2016/MH12345.jpg" then use the [VALUE] place holder instead of [FILENAME].  So in this case the template text from step 6 above would be[VALUE].  Now when the link is clicked for this example feature the full link will be

CREATEBY A field of this type will be auto populated with the user name of the person who creates each new feature on the layer

CREATEDATE A field of this type will be auto populated with the date that each each new feature is created

EDITBY A field of this type will be auto populated with the user name of the person who last made any change to the feature.  This includes either text or geometry changes.

EDITDATE A field of this type will be auto populated with the date that each feature gets modified

SECTION This field type does not accept or display any value but rather just acts as a section title that can be added to various positions within your list of fields.  This is used for esthetic purposes only to help visually categorize your fields into sections on the feature form.

CHILDREFS This is a special field type reserved for custom projects and not recommended for general use at this time.

AUTOINC This field type can be used to display a custom formated unique ID for each feature.  All features are given a unique and permenant id within their layers and stored in the "FTR ID" field.  However, this FTR ID field is hidden in most views.  The AUTOINC field allows you to display this unique ID along with an optional Prefix and/or Suffix.  For example if you want the system to create display a unique ID for all of your fire hydrants and have all ID's start with the letters "FH" then you would create an AUTOINC field and assign "FH" as the Prefix.  Not that this field will only be populated for new features.

Check this box to force all users of this layer to enter a value into this field when adding new features.