# Building a parking permit system in Glide, where multiple users living in the same apartment must be able to view, share, and edit the same permits (e.g., permanent parking permits) **URL:** \ **Category:** Ask for Help\ **Created:** [August 6, 2025, 6:28pm UTC](https://community.glideapps.com/t/building-a-parking-permit-system-in-glide-where-multiple-users-living-in-the-same-apartment-must-be-able-to-view-share-and-edit-the-same-permits-e-g-permanent-parking-permits/83695 "2025-08-06T18:28:31Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![BGA](https://avatars.discourse-cdn.com/v4/letter/b/9f8e36/32.png) [@BGA](https://community.glideapps.com/u/BGA)\ **Post date:** [August 6, 2025, 6:28pm UTC](https://community.glideapps.com/t/building-a-parking-permit-system-in-glide-where-multiple-users-living-in-the-same-apartment-must-be-able-to-view-share-and-edit-the-same-permits-e-g-permanent-parking-permits/83695/1 "2025-08-06T18:28:31Z")
I’m building a **parking permit system in Glide** , where **multiple users living in the same apartment** must be able to **view, share, and edit the same permits** (e.g., permanent parking permits). * * * ## 🧱 I’m only using 2 tables: ### 1. `Users` table: Columns: - `Email` - `LejlighedsID` (Apartment ID, e.g., “1”, “2A”) - `Name` ### 2. `FastTilladelser` table: Columns: - `License Plate` (`Nummerplade`) - `LejlighedsID` * * * ## ✅ Goal: - When **User A logs in** , they should see all permits associated with their apartment (`LejlighedsID`) - When **User B logs in** (same `LejlighedsID`), they should see **the exact same permits** - Both users must be able to **add and edit** these shared permits * * * ## 🎯 What I’ve already done: - I created a **relation** from `Users.LejlighedsID` → `FastTilladelser.LejlighedsID` → (✔ Match multiple) - I display this relation using a **Collection** (List or Card component) - I use **User Profile** as the base of the screen (confirmed via Settings → User Profile Table) * * * ## ❌ Problem: - When I log in as a user who shares the same `LejlighedsID` as another user, **no permits are shown in the frontend** - The permits **do exist in the backend** , and have the correct `LejlighedsID` - I’ve removed all filters and visibility conditions - I’ve selected the correct user using **“Viewing as [email]”** * * * ## 🔧 Desired functionality: - Users should automatically see and edit **shared permits** based on `LejlighedsID` - A maximum of **2 active permits per apartment** (optional limit) - When creating a new permit, the `LejlighedsID` should **automatically be assigned** from the logged-in user’s profile * * * **I don’t want to create a separate “Apartments” table — I want the system to work using just `Users` and `FastTilladelser`.** Can you help me find the best solution in Glide to make this work reliably? Thanks. ---
**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:** [August 6, 2025, 9:51pm UTC](https://community.glideapps.com/t/building-a-parking-permit-system-in-glide-where-multiple-users-living-in-the-same-apartment-must-be-able-to-view-share-and-edit-the-same-permits-e-g-permanent-parking-permits/83695/2 "2025-08-06T21:51:07Z")
The way you have it set up should work. User/Apartment ID –\> Permit/Apartment ID should yield the correct results. Can you share screenshots? ---
**Author:** ![Nicolas\_Joseph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicolas_joseph/32/76105_2.png) [@Nicolas\_Joseph](https://community.glideapps.com/u/Nicolas_Joseph)\ **Post date:** [August 6, 2025, 9:57pm UTC](https://community.glideapps.com/t/building-a-parking-permit-system-in-glide-where-multiple-users-living-in-the-same-apartment-must-be-able-to-view-share-and-edit-the-same-permits-e-g-permanent-parking-permits/83695/3 "2025-08-06T21:57:03Z")
Hi @BGA and welcome! 🙂 * * * ### Viewing as > [@BGA](#): > > I’ve selected the correct user using **“Viewing as [email]”** I think this is where the mistake comes from. Your relation is probably done correctly but despite it’s name, _Viewing as_ in this specific case doesn’t update the relation and stays with the same value (i.e.: the email you are currently logged in with I think). Have you tested it out for real? I mean by log in as a different user, with a different email address? Do you still face the issue? * * * ### Adding values from User Profile > [@BGA](#): > > When creating a new permit, the `LejlighedsID` should **automatically be assigned** from the logged-in user’s profile Assuming you’re using a form to let users add permits, there is a simple way to achieve that: in the form, simply add a _LejlighedsID_ avaible under _ **Values from User profile** _ and target the column where this value should be stored: ![LejlighedsID](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/293ad2065465e5239068013b68714eecf41d999c.png) When the user will hit the _Submit_ button, it’s automatically gonna reach his/her own _LeilighedsID_ value from their user profile and add it to the relevant column inside the **`FastTilladelser`** table. * * * ### Limit to 2 active permits > [@BGA](#): > > A maximum of **2 active permits per apartment** (optional limit) This one could also be easily done with this approach: 1. Add a _Rollup_ column (here `Number of Permits`) in your **`Users`** table to calculate the total of permits: ![Number of Permits](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/24d454f3d32b39ca4dddf05be8f39fc2372a2ac7.png) 2. In the layout, select your _Collection_ and go to _Actions → Allow users to add items → Add condition_. Set up the condition to allow that action only if _User Profile → Number or Permits is less than 2_: ![Condition on action](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/13ff84e1c64a783a78c350050c10012da30965af.png) Now, if a User has already 2 (or more) permits, the button isn’t displayed anymore, preventing any new addition 😉 | 1 permit | 2 permits | | --- | --- | | ![1 permit](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/503710e1861bece882969b1712531da72f83a3db.png) | ![2 permits](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/4980278086c54a6029dd1f1842e4f1a4f7a310fd.png) | * * * ### Row Owners If your application should be secure, maybe you will be intersted in enabling _Row Owners_. It’s the right way to make sure someone only sees what you want. Even if it requires some technical skills, without this feature, all the data will be downloaded prior the calculation of the relation. Anyone could theorically access the data. To prevent that, here is the link to the docs: [Row Owners | Glide Docs](https://www.glideapps.com/docs/row-owners) I hope this answers your questions 😉 ---
**Author:** ![BGA](https://avatars.discourse-cdn.com/v4/letter/b/9f8e36/32.png) [@BGA](https://community.glideapps.com/u/BGA)\ **Post date:** [August 13, 2025, 12:50pm UTC](https://community.glideapps.com/t/building-a-parking-permit-system-in-glide-where-multiple-users-living-in-the-same-apartment-must-be-able-to-view-share-and-edit-the-same-permits-e-g-permanent-parking-permits/83695/4 "2025-08-13T12:50:06Z")
HI Robert, thanx for the reply, I forgot to insert the role in user profil for the lejligheds ID. i have fixed this, and after it , i moved to creating a another table. called Lejligheder tabel 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2d0102df1850f5ec43c26f19d8f6a6062fdc6ca.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64aa057d9a9ff2d97efd7371beb8cd17d6dc1379.png) ---
**Author:** ![BGA](https://avatars.discourse-cdn.com/v4/letter/b/9f8e36/32.png) [@BGA](https://community.glideapps.com/u/BGA)\ **Post date:** [August 13, 2025, 12:51pm UTC](https://community.glideapps.com/t/building-a-parking-permit-system-in-glide-where-multiple-users-living-in-the-same-apartment-must-be-able-to-view-share-and-edit-the-same-permits-e-g-permanent-parking-permits/83695/5 "2025-08-13T12:51:24Z")
Hi Nicolas. Thanx for your reply. I forgot to insert the role in user profil for the lejligheds ID. _I_ have fixed this, and after it , i moved to creating a another table. called Lejligheder tabel 🙂 to make things more structured and easier 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2d0102df1850f5ec43c26f19d8f6a6062fdc6ca.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64aa057d9a9ff2d97efd7371beb8cd17d6dc1379.png)