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
  • Key Functions and Importance of the User Table:
  • User Lists: Setting Up and Understanding Synchronization:
  1. Users & Permissions

User Table

Understanding the User Table: a central repository of all user-related information

PreviousImport DataNextUser Management

Last updated 5 months ago

In every Noloco app, thereโ€™s one table that is the backbone of the entire operation - the User table. Itโ€™s an inherent part of every app built on Noloco, serving as a central repository of all user-related information and playing a pivotal role in maintaining the appโ€™s structural integrity and functionality.

Introduction to the User Table:

The User table is the default table in your Noloco app, consisting of various fields to store user information like first name, last name, email, role, last active at, invitation token, among others.

This table is not just a storage unit but the beating heart of your app, driving permission and visibility rules and ensuring seamless synchronization with external sources.

Importantly, the user table can be extended with custom fields to fully capture the functionality of your app.

Key Functions and Importance of the User Table:

Permission Rules:

The User Table is fundamental to establishing and enforcing permission rules within your app, determining what users can see and do. Understanding the settings here is crucial to maintaining security and operational efficacy.

It helps in constructing visibility rules that dictate what information or sections are viewable by which users, enabling a personalized and streamlined user experience.

Just like Permission Rules, most visibility rules start by building a condition based on the currently logged in user, such as "Logged in User > Client > Name" is equal to "General Creative"

Synchronization with External Sources:

User Lists: Setting Up and Understanding Synchronization:

When setting up synchronization, the User Table in Noloco acts as a linkage between your app and your external user source, creating a linked field that facilitates real-time data exchange. Hereโ€™s a simplified breakdown:

  1. Create a User List: Start by setting up a user list that will sync users from your selected external source to the Noloco User Table.

  2. Synchronization and Linked Field Creation: Once the sync is set, it establishes a linked field between your External User Table and Nolocoโ€™s User Table, allowing fluid data interchange and updates.

  3. Maintaining Data Integrity: Understanding the dynamic between the User Table and the external source is crucial to maintain data integrity and ensuring that your app has accurate, up-to-date user information.

Each permission rule is applied to one or more which are a property of the User. Further, when using , the filters you apply to your data will all involve choosing a value from the User on the right side of the filter. Visibility Rules:

When you set up a that integrates users from an external source like , , or , the User Table becomes essential. It ensures the seamless sync of user data from these external platforms to the Noloco User Table.

๐Ÿ‘ฅ
Roles
Record Level Permissions
user list
Airtable
SmartSuite
Google Sheets