Atlas logo
⌘K

Documentation

Getting Started
Data
Maps
Builder
Workflows
Forms
Sharing & Collaboration
Projects & Management
Connections

Data Table Fields

Complete guide to data table field types, configuration, and management in Atlas

Data table fields define how information is stored and displayed in Atlas. Each field type serves specific data needs and can be enhanced with AI capabilities.

Field Types

Text Fields

Field TypeDescription
TextStore names, descriptions, and general text
URLWeb links with click-to-open functionality
ImageImage URLs with preview display
PDFPDF document URLs with preview support

Numeric Fields

Field TypeDescription
NumberInteger and decimal values
CurrencyMonetary values with currency formatting
PercentagePercentage values with % display
RatingNumerical evaluation scales (e.g., 1-5 stars)

Date & Time Fields

Field TypeDescription
DateCalendar dates with timezone support
TimeTime values
DurationTime duration values

Selection Fields

Field TypeDescription
Single selectChoose one option from a predefined list
Multi selectChoose multiple options from a predefined list

Selection fields support custom colors for each option, enabling visual categorization on maps.

Boolean Fields

Field TypeDescription
CheckboxTrue/false values for yes/no data

Contact Fields

Field TypeDescription
EmailEmail addresses with validation and click-to-email
PhonePhone numbers with international format support

User Fields

Field TypeDescription
UserAssign team members to records
Created byAuto-populated with the user who created the record (read-only)
Modified byAuto-populated with the last user to edit the record (read-only)

Relation Fields

Field TypeDescription
RelationLink records to another dataset
LookupDisplay values from related records (read-only)

Relation fields connect datasets together, while Lookup fields retrieve values from linked records. See Relations & Lookups for the complete guide including setup, use cases, and best practices.

Formula Fields

Field TypeDescription
FormulaComputed values based on other fields (read-only)

Formula fields calculate values dynamically using expressions, functions, and operators. See Formula Fields for the complete guide including syntax, functions reference, and examples.

System Fields

These fields are automatically calculated and read-only:

Field TypeDescription
Created atTimestamp when the record was created
Modified atTimestamp when the record was last modified
AreaCalculated area of polygon geometries
PerimeterCalculated perimeter of polygon geometries

Geographic Fields

Geographic fields are typically auto-generated from geocoding and are read-only:

Field TypeDescription
GeometryRaw geometry data (WKT/GeoJSON)
AddressFull street address
CityCity name
StateState or province
CountryCountry name
Country codeISO country code
RegionGeographic region
Zip codePostal/ZIP code
LatitudeDecimal latitude coordinate
LongitudeDecimal longitude coordinate
CoordinatesCombined X/Y coordinate pair
H3 indexUber H3 hexagonal index
UTM zoneUTM coordinate zone
UTM eastingUTM easting value
UTM northingUTM northing value
UTM hemisphereUTM hemisphere (N/S)

AI-Enhanced Fields

Enable AI for supported field types to automate data entry and analysis.

Supported Field Types

AI capabilities are available for:

  • Text
  • Number
  • Date
  • Checkbox
  • Rating
  • Phone
  • Email
  • Single select
  • Multi select

Setup Process

  1. Add field → Select type → Toggle Use AI
  2. Write specific instructions with context
  3. Reference other fields using {field_name}
  4. Test with preview before creating

AI Capabilities by Field Type

Field TypeAI Capabilities
TextGenerate descriptions, extract information, summarize
NumberCalculate values, estimate missing data, parse numbers
CheckboxMake logical decisions, classify data
Single selectAuto-categorize, standardize inputs
Multi selectTag and classify with multiple categories
DateExtract dates from text, calculate relative dates
RatingScore based on criteria, assess risk levels
Email/PhoneExtract and validate contact information

Writing Effective AI Instructions

  • Be specific about expected output format
  • Provide context and boundaries
  • Include examples of desired results
  • Use the {} button to insert field references

Field Configuration

Adding New Fields

  1. Open the data table view for your dataset
  2. Click + Add Field in the table header
  3. Select field type from the dropdown
  4. Configure field properties:
    • Field name and description
    • Validation rules and constraints
    • Default values and formatting
    • AI settings (if applicable)
  5. Click Create to save

Modifying Existing Fields

Click the field header dropdown to access field settings:

  • Rename field
  • Change description
  • Modify display formatting
  • Add or remove AI capabilities
  • Reorder fields (drag and drop)
  • Delete field

Read-Only Fields

The following field types cannot be manually edited:

  • System fields (Created at, Modified at, Area, Perimeter)
  • User tracking fields (Created by, Modified by)
  • Lookup fields (values come from related records)
  • Formula fields (values are computed)
  • Geographic fields (generated from geocoding)
PreviousAtlas Data HubData
NextDownload DataData