# Public app and user specific column **URL:** \ **Category:** Ask for Help\ **Created:** [December 13, 2020, 7:21am UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791 "2020-12-13T07:21:36Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [December 13, 2020, 7:21am UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/1 "2020-12-13T07:21:36Z")
Hello ! I create an app to let parents neighbours schedule kids go-to-school walk buses. I would like that this app should be very extra simple for users, so I didn’t want them to have to login or signin. Here’s how it works : - 2 tab in gsheet : one for the journey and one the building identification (name and building id) - an input on the home, which is user specific (user code on the journeys sheet tab) - always on home, a button to go to the building journey tab, with an inline list of journeys filtered by building code - on this building journey listing tab, a button with action! 1/ add a new row to journey tab, populating the building id input with User code (preset on home by user) 2/ open a link to screen in detail mode with input to add a new journey to this building (name of parent, date of journey, way school to building or building to school) I don’t want people to add a journey if the building doesn’t exist in the building gsheet tab. To not allow this, my trick was to set a single value column in the building tab sheet, populated by the User code from Journey tab, and an if/then/eslse column displaying “yes” if the single value column equals the building code id ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad82a6d6f4e3e70a111667f250958915fdcf369c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f86fb125afa2c3b1e642a4612d6380ea62beae2.png) When it doesn’t shows a “yes” in this column, I don’t show the “add journey” button ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50184f817f9ae7fddb6dda887bab188ab0345c05.jpeg) For filtering the building journey inline list, I have an If/the/else column that display “yes” if User code equals building code on the Gsheet Journey tab : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f414e849d515a787ef76ccc8d4651be0eeef9efd.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3e99abee37f794464f85fd4361ecea0c7614a67.png) My problem is that if there’s more than one people with the same User Code in the app at the same time, just one can see the button nor the listing in the building Journeys tabs. Here are screenshots for the building journeys tab showing different for 2 users with same User Code at the same time : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b60054d3f227924d2e859aac64680ceb3ebd9f77.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d772c6fc526e42b661fd577c4524ec9f9de00e6f.jpeg) I think it is because there’s a conflict with User code that are the same for users and that is User specific, but I don’t really understand what’s happening. If someone could help 🙂 Thanks a lot! ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [December 13, 2020, 11:52am UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/2 "2020-12-13T11:52:10Z")
@ThinhDinh or @Robert_Petitto maybe you can help me ? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 13, 2020, 12:02pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/3 "2020-12-13T12:02:06Z")
What if you point your IFTHEN directly to the user-specific column? ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [December 13, 2020, 12:14pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/4 "2020-12-13T12:14:28Z")
Thanks for your question. You mean the IF/Then from the building gsheet tab ? I can’t because the user code is in another gsheet tab (journey gsheet tab) If you meant from the journey tab, it is the same, because my building codes are in the building tab. I can’t check with if/then condition within another tab of db. Or maybe I didn’t understand well ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 13, 2020, 12:23pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/5 "2020-12-13T12:23:05Z")
I just mean eliminate the Single Value column all together. Check if user-specific is code residence. I don’t know if it will help or hurt, just an idea. My experience with user-specific columns in public apps has been hit or miss. Is there any chance you can make this a public with email login? ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [December 13, 2020, 12:30pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/6 "2020-12-13T12:30:23Z")
I’m afraid that it will brake users to use app. Maybe if I can concatenate the user code with some random caracters, it will work, because I will check with “is included in” and this way there will not have multiple same usercode ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 13, 2020, 12:42pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/7 "2020-12-13T12:42:33Z")
Can you make your codes a choice component? ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [December 13, 2020, 12:43pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/8 "2020-12-13T12:43:52Z")
oh it’s a good idea ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [December 13, 2020, 12:52pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/9 "2020-12-13T12:52:30Z")
Yeah, just thinking about something that happened for me. I had a similar setup and people would press enter or add a space after typing in their entry and it prevented it from matching with the corresponding list. ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [December 13, 2020, 1:15pm UTC](https://community.glideapps.com/t/public-app-and-user-specific-column/19791/10 "2020-12-13T13:15:46Z")
it is ok to force people to choose an existing building. But not for filtering journeys. I think you’re, email is the only way