# How can I use the row owner with multiple emails?

**URL:** <https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561>\
**Category:** Ask for Help\
**Created:** [February 6, 2023, 10:56am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561 "2023-02-06T10:56:55Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arturo480](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arturo480/32/53929_2.png) [@Arturo480](https://community.glideapps.com/u/Arturo480)\
**Post date:** [February 6, 2023, 10:56am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/1 "2023-02-06T10:56:55Z")

</div>

I am trying to have a row with 2 or more Row Owner in Glide Pages but I can’t find the way, can anyone help me?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2023, 10:59am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/3 "2023-02-06T10:59:47Z")

</div>

You can set any non-computed column as a row owner, and you can have multiple row owner columns.

What have you tried that hasn’t worked?

---

<div class="post-metadata">

**Author:** ![Arturo480](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arturo480/32/53929_2.png) [@Arturo480](https://community.glideapps.com/u/Arturo480)\
**Post date:** [February 6, 2023, 10:59am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/4 "2023-02-06T10:59:57Z")

</div>

I have tried this as a first solution, but it doesn’t work.

---

<div class="post-metadata">

**Author:** ![Arturo480](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arturo480/32/53929_2.png) [@Arturo480](https://community.glideapps.com/u/Arturo480)\
**Post date:** [February 6, 2023, 11:00am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/5 "2023-02-06T11:00:56Z")

</div>

Hello, thank you very much for the answer, could you add a picture?

I have tried with arrays, with lookpups etc. and nothing.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2023, 11:03am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/6 "2023-02-06T11:03:00Z")

</div>

Lookups and arrays are computed columns. They cannot be used as row owners.

The original reply from the bot is misleading - array column as a row owner only works if you are using an external data source such as a Google Sheet. In this case the array column is created in the Google Sheet, so it is not computed.

---

<div class="post-metadata">

**Author:** ![Arturo480](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arturo480/32/53929_2.png) [@Arturo480](https://community.glideapps.com/u/Arturo480)\
**Post date:** [February 6, 2023, 11:37am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/7 "2023-02-06T11:37:30Z")

</div>

So, if it has to be non-computed, should I create a column for each email to be added?

I’m not getting it right.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2023, 11:40am UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/8 "2023-02-06T11:40:24Z")

</div>

Yes, if your data source is Glide Tables then you would need to do that.

Alternatively, you could use Roles as Row Owners. This can simplify it, however the downside is that any user that you assign a role to will be counted as a private user.

If you can describe your use case in a little detail, perhaps I can advise on the best approach.

---

<div class="post-metadata">

**Author:** ![Arturo480](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arturo480/32/53929_2.png) [@Arturo480](https://community.glideapps.com/u/Arturo480)\
**Post date:** [February 6, 2023, 12:05pm UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/9 "2023-02-06T12:05:38Z")

</div>

Hi Darren,

I give you the following example:

I have an app with 3 tables: users, dealers and stores.

A dealer can have multiple users

One user only belongs to one dealer

A dealer can have multiple stores.

I want that the information of the stores can only be seen by the users that belong to the dealers of those stores.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2023, 12:10pm UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/10 "2023-02-06T12:10:53Z")

</div>

Okay, so I think the ideal setup for this scenario would be to use the Dealer name as a role.

So in your Users table, you would have a Role column, and each user would have the name of the dealer they “belong” to in that column.

And then in your Stores table, you have a Row Owner column, and for each store you put the name of the dealer in that column that the store belongs to.

However, keep in mind what I said earlier. With this setup, every user will be counted as a private user. So there is a cost consideration.

---

<div class="post-metadata">

**Author:** ![Arturo480](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arturo480/32/53929_2.png) [@Arturo480](https://community.glideapps.com/u/Arturo480)\
**Post date:** [February 6, 2023, 12:24pm UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/11 "2023-02-06T12:24:12Z")

</div>

Thank you very much for your reply!

For this case I think I could work, but it is strange that if I use Google Sheets I can do it without roles and, using Glide Tables, I have to do it with roles.

Do we know if this functionality will be soon in Glide Native?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2023, 12:26pm UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/12 "2023-02-06T12:26:43Z")

</div>

You could still do it without roles, it would just be very difficult to maintain as you’d need a separate owner column for every user. The same would apply if you were using a Google Sheet, the only difference is that your multiple Google Sheet columns would appear as a single array in the Glide table.

---

<div class="post-metadata">

**Author:** ![Arturo480](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arturo480/32/53929_2.png) [@Arturo480](https://community.glideapps.com/u/Arturo480)\
**Post date:** [February 6, 2023, 1:04pm UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/13 "2023-02-06T13:04:59Z")

</div>

It is not the same since in my user table I have the ID of the dealers table. Therefore, in the dealers table I can make a relation and an array, getting easily all the users that belong to a dealer without having to have a column for each one.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2023, 2:24pm UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/14 "2023-02-06T14:24:52Z")

</div>

Yes, but that array would be a computed column. And computed columns cannot be used as row owners.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 7, 2023, 2:25pm UTC](https://community.glideapps.com/t/how-can-i-use-the-row-owner-with-multiple-emails/57561/15 "2023-02-07T14:25:10Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
