There’s a lot of ways to approach it. But here are some general guidelines.
- First, it should be known that you can assign Row Owners to multiple columns. It doesn’t necessarily have to be an array. You can mix emails and roles in a single column as well as in multiple columns.
- You can assign multi roles to each user, but this does have to be an array, and the only way to create that array is to sequentially number columns in an external database, such as google sheets.
- Computed columns, including lookup arrays, split text arrays, or any other array that’s created within glide cannot be used for row owners. The reason for that is because all computed columns are computed on the end user’s device. Data would have to first be sent to the user’s device for the computed columns to build the arrays to determine row owners. At that point, it’s too late and you’ve already exposed the unowned data, so the security of row owners would be useless.
If all locations are part of the same company, then maybe data security is not as important. In that case, you could consider just filtering the data, or use a mix of row owners and filters. Based on the role, you could use it for data security and/or use it for filtering and control over who can add and edit data.
Roles and Row Owners are for securing data. If you don’t necessarily need to secure the data, then you can use filters and visibility controls.