Lookup data not showing in inline list

I have a user profile sheet that contains a user name. In another sheet (Posts) I use the email address as a relation back to the user profile email. I then have a lookup column that extracts the “Name” value from the user profile using the email relation. That name is placed in my new Posts sheet in a column named Submitter. My Posts sheet does show all the user names in the Submitter column. The relation does not have the Match Multiple turned on…

In an inline list presentation of the Posts sheet I want to add the user name from the Submitter column as the “Detail” item on the post. The only values shown are the Submitter values that match the currently logged on email account. I suspect it is a visibility issue but I just don’t see where I have gone wrong. Any help would be greatly appreciated.

It sounds like you are close, but the relation may be the problem. I suspect one side of your match for the relation is using the user profile feature instead of the user profile sheet (I know that sounds weird). Can you share a screenshot of your relation column settings and your lookup column settings?

Here is the relationship

– Removed image due to content of data. –

Second reply contains the lookup…

Here is the lookup

image

Thank you for reviewing this…

Looks like the setup here is right. What are your visibility conditions for the items? Are they not showing the right name for the items or can you only see the posts made by the signed in user?

The only items that are visible are for the signed in user. The correct name is showing only on those posted by the signed in user.

Are you filtering the list by signed in user or using row owner feature?

Something looks off to me. In your lookup column settings, I’m used to seeing the relation name along with the column name. So in your case, instead of just ‘Name’ in the dropdown box, I would expect it to say ‘User Relation > Name’. Is there any chance that you had renamed your relation column after you had already created it? I have seen that cause issues with Rollups, but never for Lookups. I wonder if this is the case. Could you try to delete your lookup and relation columns, and recreate them with the final labels you want (ex. replace ‘New Column’ with ‘User Relation’ before clicking on Done to create the column).

2 Likes

image

To add to Jeff’s point, normally it should look like this.

1 Like

The Email address in the user profile is set to Row Owner.

I think that might be causing the issue so I duplicated the app and removed the Row Owner from the user profile email. The fallout from that is the user profile was reset to empty. I will have to spend a bit of time working thru that issue.

What I did do is change the list value to another value in the post sheet and that value shows across all items as expected. So I think it has everything to do with the user profile. Even though the user name is put in the Posts sheet.

I attempted to delete the lookup and the relation column and it would not let me. It indicates that there is a dependency on those and would not allow for the delete. I will spend more time tomorrow on this and try to isolate the issue.

As far as the indirection name in the Relation column on the lookup component, if I click the dropdown arrow the only item that is selectable is the relation item and if I expand that the name field is there and I clicked it. Don’t know why the indirection isn’t showing. I have seen the indirection on other sheets use of the relation value.

Thank you for all your assistance.

2 Likes

You would have to remove anything that uses that relation and/or lookup before you can delete them. As an alternative, just create a second set for testing purposes.

I’m probably leaning more towards a row owner issue. Row owner will only make those rows that match the signed in user’s email available throughout the app. I guess to me, having a submitter is pointless if you are locking down you app to only data from that specific user. To me you would only be viewing data where the signed in user is the submitter.

1 Like

I think that this is absolutely a Row Owner issue. The user profile rows contain the user name and I have set Row Owner on the email in the user profile. From my understanding all data in that row is restricted for use by only that user (Email account). The user profile row contains Name as one of the elements. If I am understanding, that name column is only visible when that matching email account is in use. So all other user’s name is not visible.

Now I have to figure out how to remove row owner without causing a mess. I tried this on a copy of the app (and copied the sheets as well) and when I remove the row owner all the rows of the user profile are removed as well.

What a tangled web I have woven… :nerd_face:

Thank you all for your assistance on this. I appreciate it very much.

Maybe you can make a copy of the user profile sheet, remove row owner, then restore the data from the copy.

User Profile functionality will always point the the row that matches the signed in user regardless of row ownership. Removing Row Owners will open up all the data to be accessible via relations and lookups, bit the User Profile functionality will still work as intended.

I don’t personally use Row Owners, bit I view it as a way to protect sensitive information by absolutely restricting access to that data if the email does not match that of the signed in user. If you intend for users to still be able to access and use that data, even if limited, then Row Owners will not work for you.

1 Like

Jeff,

I copied the user profile sheet and pasted into a new sheet. I then went into the data editor from the dev and removed the row owner. The contents of the sheet disappeared from the data editor view. When looking at the sheet in Google Sheets though the data is there. It appears that Glide contains some “shadow” data controls that have been removed.

So I think I am getting closer but now have to re-establish the sign on to the sheet (or something in the link is now broken)…

I will continue down this path now and should be able to figure it out, otherwise I will do research and if I don’t find an answer will post another question here.

Thank you

2 Likes

Just an update. The Row Owner on the user profile row was definitely causing the name value in the row to not be visible to all users. This was a misunderstanding on my part and a classic “user error”…

Thank you all for your time.

2 Likes