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
  • Who should use the User Lists feature?
  • What information is needed to connect a User List?
  • How do I connect my User List?
  • How do I choose which users are imported?
  • How do I assign roles to my users?
  • How do I let my users know that they can now log in to my app?
  • Can I add multiple user lists?
  • How do I separate out my 'Name' field into First & Last Name in Airtable?
  • 🎬 Video Tutorial
  • FAQs
  1. Settings

User Lists

If you have a list of users in an external data source like Airtable, PostgreSQL or Google Sheets, you can sync it to the Noloco Users table in your app to allow such users to log in.

PreviousLogin ScreenNextIntegrations & API Keys

Last updated 5 months ago

Who should use the User Lists feature?

If you already have an Airtable, SmartSuite, or HubSpot table, Google Sheet, or a Postgres/MySQL database with your users' information (first name, last name, email, etc.) and want to continue using this table as the source of truth for your users, you can use our User Lists feature to sync your user data to your Noloco Users table and allow those users to log in to your app.

What information is needed to connect a User List?

To connect a user list, you need to have the following information in your Airtable table, Google Sheets, or a Postgres/MySQL database:

  • Email address

  • First Name (optional but recommended)

  • Last Name (optional but recommended)

  • Profile picture (optional but recommended)

How do I connect my User List?

  1. Navigate to the User section in the left menu.

  2. In the dropdown menu, choose Sync your users.

3. Click on the + New user list button

4. Input the following details: a. User List Name: This is what you call a user in this list (e.g. Client or Contractor) b. What table are your users in?: Choose the relevant table in which your user information is. c. Choose the email address, first name, last name, and profile picture fields e. Select a default user role (for external users, we typically would advise you to use the User role or create a new user role) f. Click Save when you're done

5. After clicking Save, you will see a User list saved confirmation message at the top right of the screen.

  1. Your user information will soon start syncing and appear in the User section and your Noloco Users table (it may just take a minute or two).

  1. Your users can now sign in via your app login page.

How do I choose which users are imported?

By default, Noloco will import all records on your user list as Users; however, you can change this behaviour by switching off the "Should all users be included?" toggle.

If you turn this off you will instead see a rule editor where you can set the conditions that each record must match to be imported as a user.

Note that these rules will only be applied going forward. We will never remove existing users who were imported from the user list, even if they do not satisfy the new conditions.

How do I assign roles to my users?

There are two ways to assign a role to a user you're importing via a user list

  • Default Role

  • Conditional roles (available on our Pro, Business, and Enterprise plans)

When you define a default role - when that user is first imported, they will be assigned the role you specify here. If you have multiple types of users in your table and you need to assign different roles, you can do that with conditional roles.

For example, if you were running a conference, you might have attendees and speakers in the same table. Attendees should have a basic User role whereas speakers should be assigned the Speaker role.

You can add a conditional rule that says: If the field User type is equal to 'Speaker' assign this user the Speaker role.

Note: even if a user could match multiple conditional roles, they will be assigned the first conditional role whose conditions they match.

How do I let my users know that they can now log in to my app?

We recommend sending your users an email from your own email account with a link to your app's login page and letting them know that they can sign in.

Once they enter their email address from the login screen, they will then receive an email with a 'magic link' which they can click and be brought into your app.

Can I add multiple user lists?

Yes! As per the screenshot from Step #2 above, you can connect multiple different user lists - from the same or different data sources. This is useful if you're maintaining different lists for different types of users (e.g. Team vs Customers).

How do I separate out my 'Name' field into First & Last Name in Airtable?

By default, lots of Airtable bases and templates come with one 'Name' field - where the First & Last Names are combined.

If your 'Name' fields follow a regular format (just one First & Last Name), you can create the following formula fields in Airtable to separate and extract the First & Last Name.

First Name formula field (where a 'Name' field exists):

LEFT(Name, SEARCH(" ",Name)-1)

Last Name formula field (where a 'Name' field exists):

REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," ","~",LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")))),"")

🎬 Video Tutorial

FAQs

Why does my user not show up in the Noloco user table?

If you are using a User List to sync your users from your data source (like Airtable) to the Noloco user table, then they should show up in the table once we detect them in the data source, but this isn't always the case.

  • If the user hasn't got an email address we don't add a User record for them

  • It can sometimes take a few extra minutes for the User List to sync across, if you just added the record to your data source, give it a few more minutes

  • Your user might be excluded based on the custom filter you set on your user list

  • Your user's email address might not be unique, which means they would be linked to a different User record

Do my users get sent the invitation email when using a User List?

Firstly, you must connect your , , , , , , or data source.

If you sync your users with a user list, they won't be automatically invited to your Noloco app. If you do want to invite them automatically, you can use on the Noloco User table to trigger when a User is created. You can read more about notifications in .

⚙️
Airtable
SmartSuite
HubSpot
Google Sheets
Xano
Postgres
MySQL
a workflow
Sign in Options