Data Types - Default & Custom

Association

Choose Many: This data type can be used for when the user should be able to select multiple options.

Choose One: This data type should be used when the user should only be able to select one option.

Boolean

No/Yes: This data type will stay no unless the user clicks the check box to make it yes.
Yes/No: This data type will stay yes unless the user clicks the check box to make it no.

Date/Time

Auto: Date & Time & TZ: This data type automatically grabs the Date, Time, and Time Zone for the user.

Auto: Time: This data type automatically grabs the Time.

Date: This data type has the user manually select the date.

Date & Time: This data type has the user manually select the date and time.

Enumerated List

Enumerated List (Value = Label): When assigning a field this data type it allows the user to create a list of numbers or letters that allows the user to select one from when creating a record. (searchable list)

File

File Multiple Accept=any: This data type allows the user to upload multiple files to the record. In multiple different files types .jpg and .pdf are a few.

File Single Accept=any: This data type allows the user to only upload one file of the users choosing.

File Single Accept=image/* : This data type allows the user to only upload on image file.

File Multiple Accept=image/*,audio/*,video/* Meta=title,note,ge : This data type accepts in multiple images, audio files and videos.

Geometry

Auto: Generic: This data type will allow the user to place a point, linestring, or a polygon on the map.

Auto: Point: This data type allows the user to place a single point on the map.

Auto: Linestring: This data type allows the user to place a single line on the map

Auto: Linestring Z: This data type allows the user to place a single line on the map and includes the depth.

Auto: Multi Linestring: This data type allows the user to place multiple lines on the map.

Auto: Multi Linestring Z: This data type allows the user to place multiple lines on the map and includes the depth.

Auto: Multi Point: This data type allows the user to place multiple points on the map.

Auto: Multi Point Z: This data type allows the user to place multiple points on the map and includes the depth.

Auto: Multi Polygon: This data type allows the user to place multiple polygons on the map.

Auto: Multi Polygon Z: This data type allows the user to place multiple polygons on the map and includes the depth.

Auto: Point Z: This data type allows the user to place one point on the map and includes the depth.

Auto: Polygon: This data type allows the user to place a single polygon on the map.

Auto: Polygon Z: This data type allows the user to place one polygon on the map and includes the depth.

Number

Auto: Integer: This data type allows the user to enter in any non-decimal number between the range of negative -9,223,372,036,854,775,808 and positive 9,223,372,036,854,775,807.

Auto: Small Integer: This data type allows the user to enter in a non-decimal number between the range of negative 32768 and positive 32767.

Auto: Real 8 2: This will be a numeric field with up to 8 places (2 are to the right of the decimal). Example= 123,456.78

Latitude: Currently not usable.

Longitude: Currently not usable.

Text

Auto: Text (Number): This data type allows the user to enter in as many characters as they want up to (Number). For example, if the number is 10 the user can only enter in 10 characters.

Auto: Text Area (Number): This data type allows the user to enter as many characters as they want into the text area up to (Number) with the added ability to scroll.