Filter records by user/dept

Support
1

Hi,

How can I filet / silo records between users.

I have full users who should only see records with value X in field Y. X is stored in the user table.

I do not want to create a version and then separate security groups for each but rather have it filtered by the value in the user record.

Thanks

2

Hi,

You may give the user group with “Survey User” access right level. In your sheet, create a “Select User” field with assign feature. Then, filter out entries with “X” in the “Y” field and use mass update to update the “Select User” field to that specific user.

3

Hi,

Thanks but we are looking for something dynamic and less manual.
Something like the variable $USER_Dept where Dept is a field in the users table, full or external users.

Thanks