Working with user-specific columns

User-specific columns allow cells to hold unique data for each user. This means each user can experience their own data for a particular item.

For example, in the app below there is a column for User notes. This allows users to write their own notes on each item in the app.

Without user-specific columns, this note would appear to everyone else who can see that row. And if someone else changed that note, it would change for everyone else. Obviously not ideal!

Instead, we can make a new user-specific column in the Data Editor and tie the notes component to that column. Now, when users make notes in this section those notes will be specific to them. In other words, that single cell will contain a unique value for each user.

Requirements

To use user-specific columns, your app needs to use sign-in with email, email whitelist or belong to an organization. You can still add user-specific columns with public or password protected apps but user-specific columns will not be able to save data for each user.

User-specific columns also requires a Row ID column. If you try to create a user-specific column without Row IDs Glide will prompt you to add one.

Creating user-specific columns

User-specific columns live in the Data Editor only. They don't live in your sheet.

To create a user-specific column, first create a Basic Column and then tick 'Column is user-specific' in the column's configuration.

This will create a new empty column in the data editor, ready for you or your users to add their own data.

Previewing user-specific data

To preview user-specific data, you can use Preview As. This will show you the user's data in the app as well as in the user-specific columns in the data editor.