Hello folks. So I built a simple app for a few users. Other users can log in and open the app, but can’t see their data? They can enter new data, but then it isn’t visible. It’s in the data table, but just not visible to them. Same for when I am in the builder, when I switch to someone else as a user. I see no data. I can’ see my data fine when logged in as me. So, I don’t know. Anyone experience this?
Update: On further investigation, I can see that when the other user creates an item, it is embedding my User ID. That’s why they can’t see the data. Don’t know how that is happening.
What do you mean by “embedding”?
How are you presenting the data to them? Do you have row owners/roles setup? Do you have any filters or visibility conditions?
No row owner or roles setup, but filters, yes. By embedding, I mean the app is putting my user ID on the new entry and not the other user who enetered the new entry.
Can you show us some screenshots of your setup for the form? Sounds like something is wrong there. What filter are you using?
Sounds like you’re not filtering the screen or form experience to the signed in user. If the screen should pull user data, then make sure you’re adding a filter where “email is signed in user”
Figure out how you are filling that column with your user ID and that should be the source of your issue.
Yes, that is the issue. It is a simple to do app with the two tables as shows in the pics. I know I’m missing the element to filter the signed in user, but I don’t know yet where to add it in.
I see a lot of user specific columns in whatever that second table is. Is there a specific reason why you chose to make those columns user specific? User specific columns only make sense when different users will be setting different values in the same column cell in the same row. If each user has there own rows, then user specific columns are not necessary.
Not really getting a full picture of your app or what’s happening based on a couple screenshots of column headings, but the user specific columns feel like a red flag initially, especially if each row belongs to only one user. With a User ID, you should be able to apply filters to match the user ID to the id in the user profile, or if you want something more secure, then write the user’s email to each task row and apply Row Owners to the email column.
1 Like
Wow, I do appreciate your help. Once I get this concept, it will solve a lot of things for me. New picture attached of the layout. The third item was created with a different user (view as different user), and still in the data table, it adds my user ID and not the other person.
So that kind of brings me back to my original comment. How are you populating the user id? I imagine it’s part of your form to add a task.
Is that the id from the user’s user profile, or from the first row of the user table? Make sure you are getting the value specifically from the user. Honestly, though, I would probably store the signed in user’s email instead of an ID. That way you can utilize row owners.
1 Like
Yes, user ID profile. My assumption here is that when I view as a different user, and add a new item, I am active as that other user, and not still as myself. If so, that that would explain why it is pulling my user ID still. I will try you suggestion.
Hmmm. Same result, except now, my email is on all added items for any user, instead of the User ID, so other users see nothing. hmm.
Again, make sure you are getting the values from the user profile. Not the user table. Either of these should work.
Ahh, there we go. Two issues. That and using logged in user’s email. But your last email is the core issue. Many thanks Jeff!!!
Jeff
1 Like
I’ve never understood the difference between those two.
Technically nothing and they should never be different, but one is pulling from the user profile row, while the other is probably pulling from the user authentication cookie. Basically User Profile values come from a specific row in a specific table, while Special Value columns are just global values that aren’t necessarily linked to a specific table.
Email probably just shows up as an option under User Profile because it happens to be a column that exists in the user profile table as would any other columns that you have to set up in the user table. However, in some cases your app might not have a user profile configured, so there could be cases where there is no user profile email, but a user is still signed in, so you at least have access to email as a Special Value.
Long story short, use either one. The Special Value email option should always exist if you are signed in, but the User Profile email may or may not exist depending on if you have user profiles configured with an email column in the user profile table.
2 Likes
Thanks for sharing this, I would never have thought of these nuances.
Now I also wonder if in some cases an anonymized email address is returned if that feature is on. I would assume so.
I had never thought of this. I always set up user profiles when I also have sign-in access, whether mandatory or optional. I think that as soon as a user signs in, the email address is added to the users table, whether user profiles are set up or not. I need to test this.
I see the nuance though: email address in the users table vs. user profile email.