# Show on screen **URL:** \ **Category:** Ask for Help\ **Created:** [January 31, 2024, 12:54pm UTC](https://community.glideapps.com/t/show-on-screen/70322 "2024-01-31T12:54:58Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 12:54pm UTC](https://community.glideapps.com/t/show-on-screen/70322/1 "2024-01-31T12:54:58Z")
sorry idont know what call it in subject Hello everyone. Hope this is not a stupid question, and I have searched all over and got several options, but I simply cannot see what is most correct or best. What I would like, I have a button on the front page where the user can click to enter their task list, this is where my problem comes, how do I make it so that only the tasks that the giving user has created they can see . Is it possible that I have understood it correctly that you cannot do that on the free version? But hope someone can guide me ---
**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:** [January 31, 2024, 1:01pm UTC](https://community.glideapps.com/t/show-on-screen/70322/2 "2024-01-31T13:01:47Z")
> [@Snookie](#): > > how do I make it so that only the tasks that the giving user has created they can see . Two ways. Either way, you need a column in your Tasks table that uniquely identifies the user that created each task. The user email address is commonly used, or sometimes a UserID (RowID from the Users table). Once you have the above, then you have two options: - Option 1 (secure): Apply Row Owners to the email column in your Tasks table. That’s it, done. Each user will _only_ see their own Tasks, and it will be impossible for a user to see any other users tasks. - Option 2 (not secure): Use filtering. Apply a filter to your Collection. It should be something like “Email is Signed in User” > **[Row Owners | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/row-owners)** > > A secure way to restrict access to certain rows. > **[Filter | Glide Docs](https://www.glideapps.com/docs/reference/user-experience/filter)** > > Filter your content based on criteria. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 1:28pm UTC](https://community.glideapps.com/t/show-on-screen/70322/3 "2024-01-31T13:28:42Z")
> [@Darren\_Murphy](#): > > Two ways. > > Either way, you need a column in your Tasks table that uniquely identifies the user that created each task. The user email address is commonly used, or sometimes a UserID (RowID from the Users table). > > Once you have the above, then you have two options: > > - Option 1 (secure): Apply Row Owners to the email column in your Tasks table. That’s it, done. Each user will _only_ see their own Tasks, and it will be impossible for a user to see any other users tasks. > - Option 2 (not secure): Use filtering. Apply a filter to your Collection. It should be something like “Email is Signed in User” Hello thanks for your prompt reply. That’s right, there must of course be an ID number for each item, its me where are stupid and forgotit I always used in asp coding e.g. when they created a question, then the userid was saved in the table for their question as an OwnerID so it was linked to the UserenID I’ll just watch those videos and see if I don’t get it this time. have otherwise looked at many. and can see there are several ways it is explained. What I emphasize is that it must be the most secure as it is the user’s data / info. and the thing about making it invisible is not visible on the screen but is still downloadable and with a 3rd party tool you can access that information. ---
**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:** [January 31, 2024, 1:36pm UTC](https://community.glideapps.com/t/show-on-screen/70322/4 "2024-01-31T13:36:59Z")
> [@Snookie](#): > > What I emphasize is that it must be the most secure as it is the user’s data / info. and the thing about making it invisible is not visible on the screen but is still downloadable and with a 3rd party tool you can access that information. In that case, you should use the first option - Row Owners. With Row Owners applied, each user device will only download those rows that are owned by the signed in user. So it becomes impossible for other users to get at that data, as it doesn’t exist on their device. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 2:54pm UTC](https://community.glideapps.com/t/show-on-screen/70322/5 "2024-01-31T14:54:37Z")
Thanks again but. It doesn’t solve my problem the one with rowID. Regardless of who I log in with, I can see what the different people have created. Maybe I didn’t explain it well enough. You have a page where user1 creates a task. When User2 logs in, he should not be able to see User1’s task. But I, as an admin, can see all the tasks that have been created by going to the individual profile I have created a Role in the Users table where I have Admin and Members. But it must still be the case that User1 cannot see what tasks User2 has created. And I just tried it in the 2 guides it didn’t help. Now I know it’s not aspen. but there they would do that If UserLevel=“Admin” then “show data” else Than If. However, that was just a short description ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 31, 2024, 2:59pm UTC](https://community.glideapps.com/t/show-on-screen/70322/6 "2024-01-31T14:59:45Z")
- Add a column called “Admin” in the Tasks table, always write “Admin” to that column when you create a new task. You can follow these steps. > [@Set Column Values after Form submit](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/27): > > An alternative is having a text entry column pointing to the status column in the destination table. Have a default value of “Active” for that entry, and then use a conditional visibility for that component that will never be true (say “Status” is empty, because it will always be not empty thanks to your default value). - Set that column as “Row owner”. - Also use a special form value to pass ̶t̶h̶e̶ ̶r̶o̶w̶I̶D̶ of the user who created the task to the Tasks table. (Edit: pass the email, not the rowID) - Also set that column as “Row owner”. - In the Users table, make sure you have already set the “Role” column with values being Admin and Members. ---
**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:** [January 31, 2024, 3:09pm UTC](https://community.glideapps.com/t/show-on-screen/70322/7 "2024-01-31T15:09:12Z")
> [@ThinhDinh](#): > > - Also use a special form value to pass the rowID of the user who created the task to the Tasks table. > - Also set that column as “Row owner”. That won’t work unless they give each user their RowID as a Role. I think what they should do instead is pass the signed in users email address with the form into an email column in the Tasks table, and make that a Row Owner. Then it won’t be necessary to give “normal” users as Role - only Admins will need a Role. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 3:13pm UTC](https://community.glideapps.com/t/show-on-screen/70322/8 "2024-01-31T15:13:12Z")
Thanks for the answer, but I’m lost there, I simply can’t understand it and I’m probably stupid, but what you wrote I definitely believe is right, but it doesn’t make sense to me at all since I probably can’t see the visual for me. I absolutely do not doubt your explanation, but it’s just me who knows how to do it. sorry ---
**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:** [January 31, 2024, 3:18pm UTC](https://community.glideapps.com/t/show-on-screen/70322/9 "2024-01-31T15:18:34Z")
If you can provide two screen shots - one of your users table, and one of your tasks table - we can probably give you some more detailed step by step instructions. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 3:35pm UTC](https://community.glideapps.com/t/show-on-screen/70322/10 "2024-01-31T15:35:05Z")
I have taken some screen short and maybe I have built it wrong… hope it makes sense [image] ![3a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8ccb9c0eeb62e24360eec487534ce85ac9eac523.png) ![quest2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b429692694c6c7b5bf7dc41ee1659f87663c98c1.png) ![user1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94111531df23496f57dd004a251c7d6caf3b3034.png) thanks agian for you use time on me 😃 ---
**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:** [January 31, 2024, 4:06pm UTC](https://community.glideapps.com/t/show-on-screen/70322/11 "2024-01-31T16:06:57Z")
Okay, there are a few things we need to fix here. Let’s take them one by one. The below column in your Tasks table should be an Email type. Click at the top to edit it and change the Type. Then edit it again and select “Make Row Owner”. ![CleanShot 2024-01-31 at 23.53.19@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db0fa7d6f294f8a0013acc27ac4b763b5075d80d.png) You need one more column in your Tasks table. It should be a Text type. Name it `AdminOwner`, and make that column a Row Owner as well. You do not need the below component on your form. Delete it. ![CleanShot 2024-01-31 at 23.56.22@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/662c4aa4517aee460c75f78b606cc2aa31c6cabf.png) To automatically set the users email when the form is submitted, you need to add a special component to the form screen. Click on the `+` to add a component, and look for the following one: ![CleanShot 2024-02-01 at 00.00.56@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/4981a90f76cc9c31ac28390da370762435e62ec7.png) Add that, and configure it to write to the email column in your Tasks table. To automatically set the OwnerAdmin column, add a Text Entry component to your form. Configure it to write to the OwnerAdmin column, and give it a default value of `Admin`. You also need to set a visibility condition on this so that it will always be hidden. You can use anything that will never be true, eg “Some column is XXXXXXX” (or whatever). Finally, you need to ensure that Roles are correctly setup in your User Profiles configuration. Refer to the below: > **[User Profiles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/user-profiles)** > > Define, store, and use data on your app's users. That should be it. Let us know how you get on. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 5:05pm UTC](https://community.glideapps.com/t/show-on-screen/70322/12 "2024-01-31T17:05:22Z")
I don’t understand this here: To automatically set the OwnerAdmin column, add a Text Entry component to your form. Configure it to write to the OwnerAdmin column, and give it a default value of Admin. You also need to set a visibility condition on this so that it will always be hidden. You can use anything that will never be true, eg “Some column is XXXXXX” (or whatever). Because it is already in shape. since a column with the name AdminOwner has been created,then hide the field. There in invisibility what to choose there? because I can see there are several of them that hide the field, but which is the right one ---
**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:** [January 31, 2024, 5:13pm UTC](https://community.glideapps.com/t/show-on-screen/70322/13 "2024-01-31T17:13:18Z")
> [@Snookie](#): > > Because it is already in shape. since a column with the name AdminOwner has been created, I cannot create a default value of “Admin” and then hide the field. You should be doing this in the Form screen, not in the Data Editor. I think I need another screen shot. > [@Snookie](#): > > There in invisibility what to choose there? because I can see there are several of them that hide the field, but which is the right one There is no right or wrong one. All that matters is that you set a condition that can never be true. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 5:20pm UTC](https://community.glideapps.com/t/show-on-screen/70322/14 "2024-01-31T17:20:21Z")
Hope you can use this picture ![7](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/be3849fa086a5e34e6076263e36a9c0789223809.png) ![6](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4f04c909e1fb4b9910d869e4bd484a9b8b964133.png) ![5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab89e3a3b6f4eed049434edc481c6334205c1d31.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 31, 2024, 5:50pm UTC](https://community.glideapps.com/t/show-on-screen/70322/15 "2024-01-31T17:50:35Z")
Like @Darren_Murphy said, you can choose anything as long as it’s never true. I like to use RowID is empty because Row ID’s will never be empty, so it’s a condition that would never be true. Or do something like RowID is ‘happy day’ because a Row ID will never contain the value ‘happy day’. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 6:12pm UTC](https://community.glideapps.com/t/show-on-screen/70322/16 "2024-01-31T18:12:00Z")
the picture i have oploade whit my user table. are this correct setup.? It does not work. just tried to go on with the other user and i can still see what user1 has created And have done what you have written. so I really don’t know what it is I should do differently or what I am doing that is wrong. because its not work ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 6:47pm UTC](https://community.glideapps.com/t/show-on-screen/70322/17 "2024-01-31T18:47:49Z")
Yes, as written earlier, it was probably me who made the mistake and didn’t doubt what you said either, that’s why I asked if you could if I had made a stupid mistake. And I had to see that true. because where it shows the list of what was created, I had set the filter incorrectly. now it says like this OwnerID IS User Profile - Row ID so now it will only be shown to the person who created it. should just test if it works so admin can see it ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [January 31, 2024, 6:58pm UTC](https://community.glideapps.com/t/show-on-screen/70322/18 "2024-01-31T18:58:13Z")
I’m trying to make a filter so that admin can see them all. but as soon as I choose AdminOwner, it doesn’t matter what I choose in the filter list, I don’t get those that haven’t been created by the admin. how can that be? In AdminOwner where alm. member has created, the field is empty, but admin says admin. how to solve it. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 31, 2024, 11:55pm UTC](https://community.glideapps.com/t/show-on-screen/70322/19 "2024-01-31T23:55:42Z")
> [@Darren\_Murphy](#): > > That won’t work unless they give each user their RowID as a Role. Sorry, should have said passing the email, not the rowID. I believe they can work in tandem (the “Admin” column and the “Row owner email” column). Edited my original comment. ---
**Author:** ![Snookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/snookie/32/62322_2.png) [@Snookie](https://community.glideapps.com/u/Snookie)\ **Post date:** [February 1, 2024, 12:23pm UTC](https://community.glideapps.com/t/show-on-screen/70322/20 "2024-02-01T12:23:11Z")
I just want to know iam do it right, see picture ![rettighederGlide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/78169fee297972a41869a93b9f51e7a2a5ace765.png) [Next page](https://community.glideapps.com/t/show-on-screen/70322.md?page=2)