Note: Visibility conditions are not a security feature.
If you want to restrict data access based on user roles, ensuring that only users with the appropriate level can view specific data, you should use row owners. To implement this, use a “Role” column in your user table to define each user’s level. Then, in your recipe table, create separate columns for each role level and set each of these as row owners. Since you are using Google Sheets, you can also leverage additional columns to store multiple values for each role level, adding flexibility to your setup.
