Row Owners

A secure way to restrict access to certain rows
This video shows an outdated UI. To see what's new visit https://youtu.be/7UxJzBGc-DI

Row owners allows you to make only certain rows available to certain users. Only the rows with the current user's email in the row owners column will have access to that row.

Enabling row owners

Your app must use Public with email or Allowed Email List sign-in options to use row owners. Glide can then use the email address of the current user to determine which rows that user owns.

To enable row owners, click the dropdown menu on a column in the data editor which contains individual emails and select Make Row Owner.

In the app below you can see a full list of interviewees. When we click Make Row Owner on the Interviewer column we can see that the list gets filtered to only show rows with the current signed in user's email address.

Row owners is also different to filtering data per user in that it's more absolute. With filtering, you could have two lists reading from the same sheet. In one list you could filter per-user and in the other list, you could show all users all items.

With Row Owners however, you cannot do this. By enabling a row owner you give complete ownership (and privacy) to the user that owns that row.

You cannot make a Computed Column a row owner column. For example, if you had a Template Column or If โ†’ Then โ†’ Else Column outputting an email as a result then you couldn't then make that column a row owner column.

Multiple row owners

Very often, you'll want more than one person to be a row owner. If your app is on a private plan you can use Roles for this. However, if it is publicย โ€“ there are two ways of approaching this.

Add another Row Owner column

You can make more than one column a row-owner column. For example, in the table below, we've made another column that contains an administrator's email in every row. This way, each individual user is a row owner for their row, but the administrator is also a row owner.

Use Array Columns

You can also use an array column as a row owner column to give multiple people access to the same row. Simply choose an array column in the data editor and make it the row owner column in the same way.

For example, in the table below we've added another column with two more administrators that we want to have access to every employee. We've then selected this Array Column and made it a Row Owner column.

Roles

As well as adding an email in a Row Owner column, you can also assign Roles. This allows you, for example, to make everyone with the role of 'Admin' a row owner. Learn more here ๐Ÿ‘‡