# Is it possible to limit someone's access to a particular row in tables?

**URL:** <https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919>\
**Category:** Ask the Community\
**Created:** [January 23, 2023, 11:08pm UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919 "2023-01-23T23:08:32Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Greg\_McBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/greg_mcbrien/32/32898_2.png) [@Greg\_McBrien](https://connect.superhuman.com/u/Greg_McBrien)\
**Post date:** [January 23, 2023, 11:08pm UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/1 "2023-01-23T23:08:32Z")

</div>

Hi All,  
I like the ‘Content Library’ template I found in the Gallery, it allows different content pieces to be setup on individual rows in a table, with each row being ‘assigned’ to an owner. My question is, is it possible to limit the viewing of the table so an owner can only see the rows they’ve been assigned too?

Here is a link to the template I’m referring to: https://coda.io/@codatemplates/content-library

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [January 24, 2023, 7:15am UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/2 "2023-01-24T07:15:31Z")

</div>

HI Greg,

Search the gallery for Paul Danyliuk’s enhanced cross doc implementation. I believe that will allow something like that.

REgards

---

<div class="post-metadata">

**Author:** ![Samuel\_Langford](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/samuel_langford/32/47844_2.png) [@Samuel\_Langford](https://connect.superhuman.com/u/Samuel_Langford)\
**Post date:** [January 24, 2023, 2:51pm UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/3 "2023-01-24T14:51:24Z")

</div>

The User() formula gives you access to the information of the current user. So you can this filter:

thisRow.Email = User().Email

---

<div class="post-metadata">

**Author:** ![Greg\_McBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/greg_mcbrien/32/32898_2.png) [@Greg\_McBrien](https://connect.superhuman.com/u/Greg_McBrien)\
**Post date:** [January 24, 2023, 11:01pm UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/4 "2023-01-24T23:01:52Z")

</div>

Thank you. I must admit I’m not very skilled at coding (plus I’m new to Coda) so if there is someone that has the skills to do this (paid of course) please reach out to me.

---

<div class="post-metadata">

**Author:** ![anon55094081](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@anon55094081](https://connect.superhuman.com/u/anon55094081)\
**Post date:** [February 2, 2023, 1:03am UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/5 "2023-02-02T01:03:08Z")

</div>

This sounds good. I have just come to coda to build a solution for my clients to manage and update asset information. Seem like it would be more scalable to have one assets table and a table for clients/users and build filtered client pages as opposed to separate docs.

What roadblocks can I expect guys\>

---

<div class="post-metadata">

**Author:** ![Samuel\_Langford](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/samuel_langford/32/47844_2.png) [@Samuel\_Langford](https://connect.superhuman.com/u/Samuel_Langford)\
**Post date:** [February 3, 2023, 2:03pm UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/6 "2023-02-03T14:03:06Z")

</div>

> [@anon55094081](#):
>
> users and build filtered client pages as opposed to separate docs.

If all of the docs are basically the same but with different data, it’s definitely easier to create a single document and use filters. I recommend checking out the canvas column type and selective controls.

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [February 3, 2023, 2:34pm UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/7 "2023-02-03T14:34:45Z")

</div>

My general advice is to have a single document until you have to split.

There is nowadays typically only one reason to split, and that is to maintain confidentiality. A person that has access to a doc, has access to ALL of the doc.

Same with tables; fewer tables is generally better.

OF COURSE, those are generalisations. So experiment with what works best for you. But I frequently see problems with too many tables, I can not recall a problem with a table being to big. (Either too many rows, or too many columns.)

Regards  
P

---

<div class="post-metadata">

**Author:** ![anon55094081](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@anon55094081](https://connect.superhuman.com/u/anon55094081)\
**Post date:** [February 14, 2023, 2:37am UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/8 "2023-02-14T02:37:55Z")

</div>

Thanks for the reply. So is it possible to restrict the user access in a robust way so each person only sees their data. The rows specific to each user are confidential. The users are low tech, so it only has to be reaonsable robust. thanks

---

<div class="post-metadata">

**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\
**Post date:** [February 14, 2023, 1:08pm UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/9 "2023-02-14T13:08:37Z")

</div>

Of you only need it to be reasonably robust, Access Tables are going to be your best bet.

I give a full tutorial on their setup here.

[![](https://global.discourse-cdn.com/coda1/original/3X/3/8/3839df677b85f1fead6e93cf9baaa5998314c3ee.jpeg "Access Tables: Limit access to sensitive data in a Coda Doc") ](https://www.youtube.com/watch?v=aft9wHI0zfQ)

---

<div class="post-metadata">

**Author:** ![anon55094081](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@anon55094081](https://connect.superhuman.com/u/anon55094081)\
**Post date:** [February 16, 2023, 2:40am UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/10 "2023-02-16T02:40:34Z")

</div>

Nice one. I did see your video. Very good! I was snooping for second opinions here, but I’ll give it a go Scott!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [May 17, 2023, 2:40am UTC](https://connect.superhuman.com/t/is-it-possible-to-limit-someones-access-to-a-particular-row-in-tables/36919/11 "2023-05-17T02:40:54Z")

</div>

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