Field Types
Understand the different field types that are supported on Noloco tables, or any external data source
Fields are the building blocks of Noloco and help you create powerful apps without code. They allow you to capture structured and unstructured data in the many ways you need to manage workflows and projects.
You can think of fields as columns in a spreadsheet, except the field type will dictate what type of value you can put in that column.
Basic Field Types
Text
Text fields hold basic text content like names, descriptions, and formatted text.
Date
Date fields store date values with optional time information and timezone handling.
Number (Integer)
Integer fields store whole numbers with various formatting options like currency, ratings, and sliders.
Learn more about Integer Number fields
Number (Decimal)
Decimal Number fields store numbers with decimal points, supporting currency, percentage, and precision formatting.
Learn more about Decimal Number fields
Boolean (Yes/No)
Boolean fields store True/False values, perfect for status indicators and toggles.
Learn more about Boolean fields
Single Option Select
Single Option Select fields allow selection from a predefined list with customizable colors and display options.
Learn more about Single Option Select fields
Multiple Option Select
Multiple Option Select fields enable selection of multiple options from a predefined list.
Learn more about Multiple Option Select fields
Duration
Duration fields store time durations for tracking elapsed time and event lengths.
Learn more about Duration fields
Advanced Field Types
Street Address
Street Address fields store complete address information with automatic geocoding capabilities.
Learn more about Street Address fields
Map Coordinates
Map Coordinates fields store precise latitude and longitude values for exact location tracking.
Learn more about Map Coordinates fields
Date Range
Date Range fields store start and end dates for events and time periods.
Learn more about Date Range fields
Full Name
Full Name fields store complete names with titles, first, middle, and last name components.
Learn more about Full Name fields
Phone Number
Phone Number fields store international phone numbers in E.164 format with country codes.
Learn more about Phone Number fields
File/Upload
File/Upload fields store various file types including documents, images, videos, and more.
Learn more about File/Upload fields
AI-Powered Field Types
Noloco AI Fields
AI-powered fields bring intelligence to your tables by using AI to perform tasks like classification, summarization, sentiment analysis, grammar correction, keyword extraction, and custom operations.
Learn more about Noloco AI fields
Available AI operations include:
Classify: Automatically categorize data based on content
Summarize: Condense lengthy text into concise summaries
Sentiment: Analyze emotional tone of text (positive, negative, neutral)
Chat Prompt: Use custom prompts for tailored AI responses
Correct Grammar: Improve text quality and professionalism
Keyword Extraction: Identify relevant keywords from text content
Computed Field Types
Formula
Formula fields calculate values from other fields within the same record using spreadsheet-like formulas.
Learn more about Formula fields
Rollup
Rollup fields summarize data from related records, providing aggregated insights across relationships.
Learn more about Rollup fields
Lookup
Lookup fields pull data from related tables based on linked relationships, ensuring data consistency.
Learn more about Lookup fields
Link to Another Record
Relationship fields create links between records, enabling complex data relationships across tables.
Last updated
Was this helpful?