All Collections
Basics
Users Spreadsheet
Users Spreadsheet
Patrick avatar
Written by Patrick
Updated over a week ago

This article ties in with a few other Frontly articles relating to User Management.

We encourage you to carefully consider and review the options in each of these settings before finalizing your set-up.

User Roles, Groups & Permissions
Custom User Fields
User Profile

Frontly stores your basic user data like email and password in a secure internal database so that you don't need to store that in a sheet.

However, if your use-case requires storing user data in a spreadsheet in addition to Frontly's internal storage, go over the 'Users Spreadsheet' tab to import a Sheet that will automatically link the active user to corresponding row in the spreadsheet.

You can locate this setting from homepage by clicking Users.


Benefits

When setup correctly, Frontly will automatically find the matching row in your Users Spreadsheet every time your user logs in and make those fields available inside the user data source all throughout the app.

Additionally, all of your custom user fields will be neatly organized and referenced from your User Spreadsheet instead of your app, as an alternative to entering them in-app detailed in this article.

Imagine you have a sheet with users, their emails, and a field called 'favorite_animal':

In setup mode, you can access the variable like this:

In live mode, it will appear like this:


Requirements

To use this feature, you must have a column in your spreadsheet called 'email' in lowercase with no other characters or spaces. Frontly will use this to locate the row with the matching email address.

Emails must match perfectly. If there are duplicate records with the same email, the first matching record will be used.

Additional Note: Core Frontly user fields first_name, last_name, username, email, id, user_groups, is_owner will remain as fields processed in-app, and will be ignored if their fields and values are updated into a User Spreadsheet. Therefore, this will not be a viable method to modify these core fields.

Did this answer your question?