# Visibility Public/Only me options

**URL:** <https://community.glideapps.com/t/visibility-public-only-me-options/20897>\
**Category:** Ask for Help\
**Created:** [January 8, 2021, 5:16pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897 "2021-01-08T17:16:50Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed\_Saif](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ahmed_saif/32/19461_2.png) [@Ahmed\_Saif](https://community.glideapps.com/u/Ahmed_Saif)\
**Post date:** [January 8, 2021, 5:16pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/1 "2021-01-08T17:16:50Z")

</div>

Hi Everyone,  
I am creating a Public App with a password, and I am looking for a method for every Signed-in user to control the visibility whether their products’ info is (Public: anyone can see) or (Only-me can see)?

- Without using the ROLE method.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [January 8, 2021, 5:35pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/2 "2021-01-08T17:35:57Z")

</div>

Have you tried filtering data or using row owners?

---

<div class="post-metadata">

**Author:** ![Ahmed\_Saif](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ahmed_saif/32/19461_2.png) [@Ahmed\_Saif](https://community.glideapps.com/u/Ahmed_Saif)\
**Post date:** [January 8, 2021, 5:42pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/3 "2021-01-08T17:42:30Z")

</div>

@Pablo_Miguel_Martine Once the user adding his products’ row that already protected by “row owner”, no one can see and filtering is not helping, so I want a method to switch to public.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [January 8, 2021, 5:50pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/4 "2021-01-08T17:50:36Z")

</div>

Maybe you can do an array of the users sheet into a new sheet, copying the values you want to be public. So when a user creates a profile he can add all the values that will remain private, for the profile page for instance. And then you can do an array of the name and phone number for example so other users can see this info

---

<div class="post-metadata">

**Author:** ![Ahmed\_Saif](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ahmed_saif/32/19461_2.png) [@Ahmed\_Saif](https://community.glideapps.com/u/Ahmed_Saif)\
**Post date:** [January 8, 2021, 6:06pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/5 "2021-01-08T18:06:03Z")

</div>

@PabloMFalero I would appreciate if you could explain how can I use array for this.  
Thank you.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [January 8, 2021, 6:13pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/6 "2021-01-08T18:13:54Z")

</div>

If you go to the templetes and open the employees templete you have a good example. Copy the app and open the spreadsheet. You have profiles private and profile’s public tab, the public is an array from the private. I hope it helps you. If not, get back to me and I’ll help you with whatever you need

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 8, 2021, 6:21pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/7 "2021-01-08T18:21:10Z")

</div>

There’s no clean way to use a public/password app with roles/user profiles. The only way to really do this is to set up the app as though you were using user profiles and then switch it to public afterwards. Even then, since users aren’t providing their email, a user profile row won’t be automatically created for them—you’d need for them to complete an onboarding form of some type.

---

<div class="post-metadata">

**Author:** ![Ahmed\_Saif](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ahmed_saif/32/19461_2.png) [@Ahmed\_Saif](https://community.glideapps.com/u/Ahmed_Saif)\
**Post date:** [January 9, 2021, 12:01pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/8 "2021-01-09T12:01:39Z")

</div>

Many thanks @PabloMFalero @Robert_Petitto , it works now 😀

What I applied was the following:

- “Sheet\_1” has private info by applying “ROW OWNER” for the Email column.
- “Sheet\_2” will be created by “=ARRAYFORMULA()” or “=IMPORTRANGE()” to switch the private info to public info (including the Boolean column to switch between Public/Only\_me, True/False filter)

What was confusing me that I was importrange only the “ID column” and then apply a relation but this way reflected also the ROW OWNER from the 1st Sheet to the 2nd one.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [January 9, 2021, 12:18pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/9 "2021-01-09T12:18:35Z")

</div>

Glad it worked @Ahmed_Saif !!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:58pm UTC](https://community.glideapps.com/t/visibility-public-only-me-options/20897/10 "2024-01-17T16:58:24Z")

</div>


