View specific row for each user

Hello Everyone,

I have two table
First Table name: Report malfunctions
The Second Table Name: User Role
I give every user some role at table “User Role”

at first table the users just applied some malfunctions and show like this:

i want to show every specific row for the Responsible for type Equ. like:

  • If user has role Engineer i just want to show him Type equ. = “BM”

  • If user has role Technician i just want to show him Type equ. = “Other”

I don’t think it’s entirely clear what you’re trying to achieve but I think what you’re looking for are security filters/table settings where a user can only view rows from the table that match the settings you specify.

Security filters: The Essentials

Configure table settings

2 Likes