Noloco
Ask the CommunityHire an ExpertLoginSign up
  • Noloco Overview
  • ๐Ÿš€Quickstart
    • Start with your data
    • Start with AI
    • Start with a template
  • Data to App
    • Database Consolidation
  • App Settings
  • Components
    • Containers
    • Video
  • Templates
  • ๐Ÿ”—Data Sources
    • Data Overview
      • Setting a Collection's Primary Field
      • Syncing
    • Noloco Tables
      • Field Types
      • Relationships
      • Automatic Links
      • Rollup Fields
      • Lookup Fields
      • Formulas
      • Noloco AI
      • Import a file
    • Airtable
    • Google Sheets
    • SmartSuite
    • MySQL
    • PostgreSQL
    • REST APIs
    • HubSpot
    • Xano
  • ๐Ÿ“„Pages
    • Collection views
      • Show collection record count
      • Empty State
    • Blank pages
    • iFrame embeds
    • External links
    • The Home Page
    • User Profile Page
    • Parent pages & folders
    • Page visibility rules
    • Cloning pages
    • Renaming pages
    • Hiding pages
    • Sidebar dividers
    • Tabs
  • ๐Ÿ“‚Collections
    • Adding collection views
    • Display
      • Rows
      • Cards & columns
      • Tables
      • Kanban boards
      • Calendar
      • Timeline
      • Gantt
      • Split-view
      • Charts
      • Maps
      • Pivot Table
      • Single record view
      • Grouping records
      • Record Colors
    • Filters
      • Logged in user
      • Relative Filters
      • Record values
    • Filter fields
    • Sort & limit
    • Row Action
    • Column Summaries
  • ๐Ÿ“Forms
    • Forms
      • Customizing Form Fields
      • Passing Linked Record Values to a Form
      • Dynamic Form Field Filters
      • E-Signature Fields
    • Public Forms
  • ๐Ÿ“ƒRecord Pages
    • Overview
    • Visibility Settings
    • Hidden Field Values
    • Record Comments
  • โœ๏ธField Formatting
    • Field visibility conditions
    • In-line editing
    • Conditional Highlight Colors
    • Dates & Time Zones
  • ๐Ÿ“ŠCharts
    • Overview
  • ๐Ÿ“‚Data Management
    • Export Data
    • Import Data
  • ๐Ÿ‘ฅUsers & Permissions
    • User Table
    • User Management
    • User Roles & Permissions
      • Record-level permissions
      • Field-level permissions
    • Open Sign Up
    • Offboarding Users
    • Testing as other users
  • โฉActions
    • Action buttons
      • Create records
      • Update records
      • Bulk actions
      • Barcode Scanner
      • Add a Comment Action
  • โšกWorkflows
    • Workflows
      • On-demand workflows
      • Comment Added Trigger
      • Watched Fields
      • Trigger webhooks
      • Send automated emails
      • For each item in a list...do...
      • Only continue if
      • Create a Record Action
      • Update a Record Action
      • Delete a Record Action
      • Deactivate a User Action
      • Reactivate a User Action
      • Send an Invitation Email Action
      • Add a comment to a record
      • Send a Push Notification
      • Ask Chat GPT Action
      • Summarize Text Action
      • Correct Grammar Action
      • Extract Keywords Action
      • Analyze Sentiment
      • Finish Text Action
      • Send a message to a Slack Channel
      • Send a message to a Slack User
      • Generate a PDF with DocsAutomator
  • ๐Ÿ””Notifications
    • Notifications
    • Notification Preferences
  • ๐Ÿ“‘API Documentation
    • API Overview
      • Fetching Records
      • Fetching a Record
      • Creating a Record
      • Update a Record
      • Deleting a record
  • โš™๏ธSettings
    • General Settings
      • Live Mode
      • Custom Logos
    • Theme & Design
    • Progressive web apps
    • Navigation Settings
    • Spaces
    • Email Settings
    • Custom Code
    • Custom Domain
    • Login & Signup
      • Sign in Options
      • Single Sign On
      • 2FA - Two Factor Authentication
      • Client Portal User Add-On
    • Login Screen
    • User Lists
    • Integrations & API Keys
    • Billing & Usage
    • Support
    • Publishing
      • App Version History
  • ๐Ÿ”„Integrations
    • Zapier
    • Make (Integromat)
    • Sign in With Google
    • Intercom
    • SMTP Emails
    • Documint
  • โš™๏ธAccount
    • Workspaces
    • Pricing
      • Client Portal Add-on (Legacy)
    • Transferring an App
    • Onboarding Call Preparation
Powered by GitBook
On this page
  • What is a Lookup Field?
  • Creating a Lookup Field
  • Advanced Options
  • Best Practices
  • FAQs about Lookup Fields
  1. Data Sources
  2. Noloco Tables

Lookup Fields

Lookups in Noloco allow you to fetch and display related information from other data tables, enhancing your data relationships and insights without duplicating data.

PreviousRollup FieldsNextFormulas

Last updated 10 months ago

What is a Lookup Field?

A lookup field in Noloco enables you to pull in data from a different table based on a linked relationship. This means you can display related information from another table without manually copying the data, ensuring consistency and reducing redundancy. Lookups are particularly useful for creating dynamic and interconnected datasets, such as referencing client details in a project management table or product information in an order tracking table.

Creating a Lookup Field

  1. Navigate to Your Table: Open the Noloco table where you want to add the lookup.

  2. Add a New Field: Click on โ€œAdd Fieldโ€ and select โ€œLookupโ€.

  3. Configure the Lookup:

    • Linked Field: Select the linked field that connects the current table to the source table.

    • Field to Lookup: Choose the specific field from the source table you want to display.

Example Use Cases

  • Project Management: Display client names from a clients table within a projects table.

  • Sales Tracking: Show product details in an orders table.

Advanced Options

  • Formulas: Combine lookup fields with formulas for advanced data manipulation.

Best Practices

  • Data Integrity: Use lookups to maintain consistency and reduce data redundancy.

  • Performance: Optimize lookup fields by filtering unnecessary data.

FAQs about Lookup Fields

  1. What data sources are supported for Lookups?

  2. What field types are supported for Lookups?

    You can use lookup fields with various data types such as text, numbers, dates, and even linked fields. The only unsupported field at the moment are file/attachment fields.

  3. Can I filter the data in a Lookup field?

    No, not at the moment, you can not apply filters to your lookups, but let us know if this is somehting you want to see in Noloco.

  4. How do Lookups help with data consistency?

    By referencing data from a single source, lookups ensure that any updates to the source data are reflected across all linked tables, maintaining consistency.

  5. Can I use Lookups in formulas?

    Yes, you can use lookup fields within formulas to perform advanced data manipulations.

  6. Are Lookups real-time?

    Yes, lookups fetch the latest data from the source table, ensuring real-time updates and synchronization. They are updated whenever one of the underlying links or values are updated.

Noloco supports lookups from all data sources, including , , , , , and . You can even add a lookup to a linked field that links across two different data sources.

๐Ÿ”—
Noloco Tables
Airtable
SmartSuite
Google Sheets
PostgreSQL
MySQL
Xano