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.  (This field has been made somewhat obsolete because TEXT type fields will now sort numbers numerically as well.  In most cases we recommend using the TEXT fields in place of NUMBER fields)

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.

LOGSHEET Like the LOG field type described above, this field type is also used for recording a running history.  However, a LOGSHEET field is used for tabular data with rows and columns, where the LOG field is used for narrative  data.  A LOGSHEET field types embeds a mini spreadsheet to each feature on your layer.  It is intended to be used as a daily or periodic log of readings, inspections, or test results.  Each row of the log sheet records one set of readings (ie. one day).  And each column represents the different types of readings you want recorded such as Date, Pressures, Test results, or even notes.  When you select LOGSHEET on the field setup screen you will be prompted to define your log sheet's columns.  Take care in doing this because once you have finished setting up this new log sheet you will not be able to go back and rearrange the order of your columns.  You can always come back to this setup screen and add new columns.  And you can hide obsolete columns by erasing the column name.  Also, when you are actually entering data onto your log sheet you can only add new rows.  You cannot go back and edit previously logged rows.  This is by design so that you can trust that your data will not be tampered with for years to come.

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. See also the EXPANDEDLINK field type

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.  Click here for example expressions.

EXPANDEDLINK This field type is designed to help you link a bunch of existing pictures or documents to their respective features on a layer.  It does this by converting (or "expanding") the values from a certain field of your layer into complete URLs.  Click here for further explanation and examples.

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.