Happy to help. It does sound like you have it setup correctly. It might be as simple as changing who you are “previewing as”
In the top left of the editor are you previewing as a role who has permission to those rows?
Something I use often is the role of Admin (you could name it whatever you like) In tables where I want to have access to all the data… I add a separate row owner column with ‘Admin’ in every row.
I’m out of the office today but should have some bandwidth tomorrow to take a look at your app if you’d like… probably Darren will beat me to it
Thanks for offering to help. I really appreciate it. I logged out of the entire system. Logged back in. Changed users… and still no luck.
Here’s the User table entry:
Here’s the entry in Companies:
Ok if you see slightly greyed out rows you don’t have access to that row… like your first screenshot… ‘Monumental Shift’ is slightly greyed out and Davis 201 is solid black. Whoever you are “previewing as” in the builder has access to Davis 201 but not Monumental shift.
Try switching to someone who has the role ‘Monumental Shift’ and you should see what I’m talking about.
In your subsequent screenshots they are all grayed out.
Are you looking for an Admin account that has access to every row? If so I think my previous suggestion could work
Eric,
I’m previewing as Davis201 and as you can see the Davis201 co is greyed out. If I change to Monumental shift - the same thing happens. The monumental shift company is not able to be accessed.
Goal: a user has access to any table row where the company is the role. That’s it. I’m befuddled.
No matter who I chose their company in the company table (or any other table with their company name as role owner is inaccessible.
Ugh.
In your company table in column C-Name is ‘Monumental shift’ grayed out or just the relation? If monumental shift is grayed out in the C-name column then I’m stumped. If it’s just the relation that’s grayed out then we’re getting somewhere. Probably just need to add the appropriate row owner column to the target table of our relation.
I’m nearing the end of my patience for the day, and I’m starting to wonder if Glideapps is for me. I’m really bummed. Let me know if you think of anything. Thanks for helping.
Sorry I couldn’t solve this one today. I’m certain we will get to the bottom of it. I will tag some of the experts for an assist. If I think of anything I will be sure to let you know.
Double check your user profile configuration. I see you are pointing Image to a unique id column. It should be an image column. May not matter, but seems like you user configuration is half complete and I’ve seen weird results from not setting it up correctly.
I also see you are double utilizing the Companies column as both a role column as well as a row owner column. I would try splitting that up so you have a separate role column and a separate row owner column. They would have the same values in your case but but prevent some sort of conflict.
Thanks for the suggestions. I added an image column and set that in the user profile. No difference.
Removed the row owner on the Company (although ultimately, I will need that, I believe.) No change.
I’m pretty disappointed that after 4 days I can’t get this working right. I feel like a moron. Thanks for your help.
Okay, here’s something odd! I decided to duplicate the entire project and see what happens… guess what? In the duplicated project, everything works as expected!!! I didn’t change a thing. Just opened up the copy and BOOM, the roles are working.
Firstly, you can’t use computed columns in your User Profiles configuration, so that explains why your template column isn’t available. That’s correct and expected behaviour.
Secondly, I see that you have Row Owners applied to your Role column in the User Profiles table:
Whilst I believe it should work like that, I’d recommend splitting that up. That is, have a Role column without Row Owners applied, and then add a second Row Owner column with the company name (if required). I see that @Jeff_Hager made the same point earlier in the thread:
I’d at least recommend starting by removing Row Owners from that Role column and see if that changes anything.
Can you show us the setup in your duplicated (working) project? We might be able to spot something that you’re not seeing.
Thanks for the suggestions. I’ve removed the role owner from the Companies column and created a Row Owner column with the same information. No change in the system’s behavior.
Thanks again.
Andrew
Can you show us the setup in your duplicated (working) project? We might be able to spot something that you’re not seeing.
I’d have loved to show you the duplicated project… however, after that worked I deleted it and duplicated the project again… only to have the same issue. Sorry about that.
One other thing I did notice in your video (but didn’t comment on) is that you only have access to the first row in the Users table. But based on the settings as shown you should also have access to rows 3 through 7. So there’s something not right there either.
My gut feeling is that there is something simple going on that we’re missing.
If you’d be prepared to give one of us temporary access to your project, I suspect that we might be able to track down the issue fairly quickly. Or help confirm that there is a bug, if that’s the case.
