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
  • Scheduled Syncing
  • How Scheduled Syncing Works
  • Live Syncing
  • How Live Syncing Works
  • Schema Syncing
  • Updating or creating data in Noloco
  • Manual Syncing
  • How do I manually sync a table?
  • How do I manually sync a data source?
  • How do I manually sync a data source schema?
  1. Data Sources
  2. Data Overview

Syncing

Syncing data from external data sources to your custom Noloco applications

PreviousSetting a Collection's Primary FieldNextNoloco Tables

Last updated 1 month ago

Noloco offers two robust methods for syncing data from external sources to your custom applications: Scheduled Syncing and Live Syncing. Understanding how these processes work can help you maximize the efficiency and reliability of your data flow, ensuring your application always reflects the most current information in your data source.

Data Source
Live Syncing
Scheduled Syncing

Airtable

✅

Google Sheets

✅

Hubspot

✅

MySQL

✅

PostgreSQL

✅

REST APIs

✅

SmartSuite

✅

Xano

✅

Scheduled Syncing

Scheduled syncing is enabled for data sources that require regular data updates;

How Scheduled Syncing Works

  • Process: On the set schedule, Noloco reads all of the data in your external data source. It checks for any new or updated data since the last sync. This includes additions, deletions, or modifications to the records in your tables.

  • Application Update: Once the syncing process is complete, the changes are reflected in your Noloco application, ensuring your data remains current up to the latest sync.

Live Syncing

How Live Syncing Works

  • Real-time Updates: Unlike scheduled syncing, live syncing listens for changes in your external data source in real-time. When a change occurs, it's immediately communicated to Noloco and reflected in your application.

  • Setup: Live syncing is enabled by default for Airtable and SmartSuite, providing an effortless setup for instant data updates.

Schema Syncing

In addition to syncing data content, Noloco also periodically syncs the schema (structure) of your external data sources. This ensures that any changes to the tables or fields in those tables are accurately reflected in your Noloco application.

  • Periodic Checks: Noloco periodically reviews the schema of your connected external data sources for any changes every few minutes.

  • Automatic Updates: If a change is detected, Noloco automatically updates your application to align with the new schema, ensuring structural consistency.

Updating or creating data in Noloco

For example, if you use Airtable as an external data source and create a new record in your Noloco app, that record will be instantly created in Airtable and stored in Noloco.

Manual Syncing

Despite the efficiency of scheduled and live syncing, there might be instances where an immediate update is necessary, or an inconsistency arises.

  • Immediate Action: In such cases, Noloco allows for manual syncing. Users can initiate a manual sync for a specific table or the entire data source directly from the data table in their application.

  • Problem Resolution: This feature is particularly useful for quickly resolving any discrepancies or ensuring data is up-to-date following unforeseen changes.

How do I manually sync a table?

How do I manually sync a data source?

How do I manually sync a data source schema?

Frequency: The frequency of scheduled syncing depends on your . Each plan offers different syncing intervals (priority or standard), allowing you to choose one that best fits your business needs.

For businesses requiring their applications to reflect data changes almost instantly, live syncing is the ideal solution. This method is supported exclusively for and data sources with limited support for too

When you make changes to any data source in your Noloco app, or through our or integration or through the the data will instantly be updated in your external data source too.

🔗
Google Sheets
MySQL
PostgreSQL
API Collections
Xano
Noloco subscription plan
Airtable
SmartSuite
Hubspot
Make
Zapier
API