Editable table with user email filter -- How to also show view-only list of all records?

Thanks to any assistance / rationalizing on this!

Scenario: 1000 records, 50 users. Each user has 20 records assigned to them via email. Today I can either filter on that email condition (or I can create a slice with that filter, and have no other views to the records). This works perfectly - I can limit the user to only edit โ€œtheirโ€ record.

Question: How do I create an โ€œAll Recordsโ€ view that allows a user to see all 1000 records, but not edit any outside of the 20 assigned?

Ideally, we would have chunks of users who are not โ€œassignedโ€ to an entry via email, but should have Read Only rights.

I feel like Iโ€™m missing a configuration, any guidance is appreciated.

-B

Solved Solved
0 7 1,379
1 ACCEPTED SOLUTION

Bahbus
New Member

Define each columnโ€™s editable property to be if USERNAME()=[Assigned User]

View solution in original post

7 REPLIES 7
Top Labels in this Space