Row Owners hide all data | CustomerKey vs. SalonID confusion

[Marc1]

Hi Community,

I’m building a Salon CRM / customer card app in Glide with 3 main tables:

1. Users (User Profiles)

• name, email, role, salon_id (Row Owner)

2. Customers (Kunden-Template)

• customer_key (unique, email/phone), name, phone, email, birthday, salon_id (Row Owner)

3. Services (Services-Template)

• date, service_type, products, note, cost, customer_key, salon_id (Row Owner)

---

Problems I’m facing

1. Row Owners hide all data

• After I set salon_id as Row Owner in Customers, all my customers disappeared.
• Even though in Users.salon_id = Salon Müller and in Customers.salon_id = Salon Müller (copy & paste).
• It looks identical, but Glide doesn’t match them.

2. Wrong value in Services.salon_id

• When I add a new Service, the field salon_id in Services gets filled with my email address, not the salon_id from the User Profile.
• I added a Column Value component in the Service Form:
  • Target = salon_id (Services)
  • Value from = Signed-in User → salon_id
• But still, the email ends up in the Services.salon_id field.

3. CustomerKey vs. SalonID confusion

• In my Service Form, I also add a hidden value for customer_key.
• This works, but sometimes I get my own email there, instead of the customer’s key.
• Maybe because my button is not placed correctly in the Customer Detail Screen?

4. Salon ID values

• In Users.salon_id I use “Salon Müller”.
• In Customers.salon_id I also used “Salon Müller” (copy & paste).
• But it seems Glide is very strict → maybe Umlauts (Ü), spaces, or capitalization cause mismatch.
• Should I instead use IDs like salon_mueller, salon_schmidt?

---

What I already did

• Added salon_id as a column in Users, Customers, and Services.
• Set all of them as Row Owners.
• In the Customer Form: added Value → target = salon_id (Customers), value from = Signed-in User → salon_id.
• In the Service Form:
  • added Value → target = customer_key (Services), value from = Values from Screen → customer_key.
  • added Value → target = salon_id (Services), value from = Signed-in User → salon_id.
• Tested with “Viewing as” my User (Mark).

---

Questions

• Why does Glide not recognize my salon_id even though it looks identical (Salon Müller)?
• Why does my Service Form write email into Services.salon_id instead of the salon_id string?
• What is the best practice for salon_id values – should I always use machine-safe IDs (salon_mueller) instead of names with Umlauts/spaces?
• How can I make sure CustomerKey always writes the customer’s ID, not the signed-in user’s email?

photos of these i cant make, because the customers gone away from screen with Input Row ID Salon_id in Customers:

• Service Form screen settings → where you set Column Value for salon_id and customer_key
• Customer Form screen settings → where you set Column Value for salon_id
• App preview “Viewing as” your User (Mark), showing that no Customers appear
  
  
  
  
  
  
  
  

[Swift_Struck_24]

Hi marc, have you ensured that your salon_id column is indeed tagged to the ‘role column’? this can be configured by going into any user’s user profile screen from inside the builder.

[Darren_Murphy]

Before I attempt to answer all your questions, let me ask this. Have you set a Role column in your User Profiles configuration?

Unless/until you do that, most of what you are trying to do will not work.

[Swift_Struck_24]

once you ensure that glide’s role column is mapped to the salon_id column, all your problems shpould go away.. by this column assingment, you’re telling glide to consider the user’s email and WELL AS THE salon_id column to act and row owners across all other tables

[Marc1]

Hi,

i have a Role Column in Users:
But only as a text in Users…

photo:

[Marc1]

I Put in Role now salon I.
nothing happens…

[Darren_Murphy]

Okay.

Remove Row Owners from the salon_id column in your Users table. You don’t need that.

And in your Services_Template table, you need to change the values in the salon_id column. The values in this column must match the values that you have used in the Role (salon_id) column in your Users table.

[Marc1]

@Darren_Murphy

And in your Services_Template table, you need to change the values in the salon_id column. The values in this column must match the values that you have used in the Role (salon_id) column in your Users table.

Done: Remove Row Owners from the salon_id column in your Users table. You don’t need that.

Problem
And in your Services_Template table, you need to change the values in the salon_id column. The values in this column must match the values that you have used in the Role (salon_id) column in your Users table.

The Users are invisible because the Row Owner Problem…, thats the reason, why i cant go in the User area to put other Value Settings…
Only see that in Kunden_template (Customer)

[Darren_Murphy]

@Marc1

The Users are invisible because the Row Owner Problem…, thats the reason, why i cant go in the User area to put other Value Settings…
Only see that in Kunden_template (Customer)

You are introducing a new table here - Kunden Template. How have you applied Row Owners to this table - can you show me?
Note that when row owners are applied, which rows are visible in the layout will depend on which user you are viewing as, and their role and/or email address.

[Marc1]

That was the screen I’ve actually been working with the whole time. Glide is driving me crazy today… Is there a way to pay people from your team to help with issues like this?