Example of User Table with email and role to manage view access and editable_if for fields

[Sam87]

Hi All, I have seen different posts on managing field level security, such as using Editable If …IN(USEREMAIL(), LIST(“xyz@gmail.com”,"abc@gmail.com"))

This is great for an app with few users and limited field level security, but what about larger solutions?

I brought in ‘Users’ table with an ‘Email’ column and a ‘Role’ column.
Assuming the role was ‘editor’ for a particular user, how could I create an editable_if statement to only allow the user role ‘editor’ to make such edits to this particular field, how would I achieve this?

I was trhing * IN(LOOKUP(USEREMAIL(), Users…but wasn’t working