How do I let users see data they have a relation to?

Ask for Help
1

This is the user layout I currently have:

image
image1471×116 16.8 KB

I have 3 row owners - email, role (e.g. admin) & hirer or worker.

I was hoping to let the workers see all listed jobs in their job list tab.

But even though, I’ve set the hirer or worker tab in the jobs data as row owner, they still can’t see the jobs.

So I made a relations & lookup tab on the users data as can be seen below:

image
image865×576 34.9 KB

My question is, how do I then give the workers the ability to see all the jobs listed for workers.

I’ve already tried setting the worker tab on the jobs section as row owner but its not working.

The admin row owner can see all the jobs though.

2

You cannot use computed columns as row owners. You must use basic columns (such as text columns).

For example, if you want workers 1, 2, and 3 to have access to a specific job, you can create three basic text columns, each marked as a row owner column, and assign each worker’s email to a separate column. Alternatively, you can assign a role to each worker in the users table (make sure to map this role column to the user’s configuration in the application). Then, you can use this role in one or more columns, marked as row owner columns, within the relevant table.

3

You are going to have an issue with your user table. You have two rows for the same user. You should only have one. When the user updates their profile, they should be editing the existing row that was auto generated for them instead of adding a new row.

I see a ‘Role’ column and a ‘Hirer or Worker’ column in your user table. Which one have you configured for Role functionality? They both cannot be used for Roles. You can have multiple Row Owners on a table, but a user can only have one Role. (There is a loophole with Google sheets, but I won’t get into that to avoid confusion.)

3 Likes
4

I have both set as row owners right now. The issue is I cannot get my onboarding choice component to update the row table for workers as workers, because apparently choice components & actions cannot be used to update a users role and it must be done through an external api call instead.

Hence why I created the Hirer/Worker column.

But that doesn’t seem to be working either.

5

A role is something you assign to a user. A row owner column can then contain a user’s email or role.

Show me how you have your user profile configured. Which column is assigned as your Role column?

6

as such

image
image237×402 4.95 KB

here’s an example of my users table:

image
image1586×110 16.5 KB

7

OK. Since you are using the Role column for Role functionality, and it appears to be empty, any row owner columns in other tables that attempt to use a role instead of email won’t show anything because there is no matching role from the user table that matches a role entered into a row owner column.

Also, your profile is configured to use a boolean column as an image. Probably not affecting anything, but that is not a proper configuration. It should point to an image column

2 Likes