Row owners but Admin needs to see all

Please can someone guide me, i want to assign row owners to my “Contacts” table so that only the user that owns the contact, can see it, and optimise my app loading time.

however, my admin role, need to see ALL contacts - i have tried:

  • create array; template; single value column in my contacts table with admin email for a second row owner- doesnt work with computed columns

im trying to keep it basic but getting a bit stuck with the best solution amongst the variety of options

You need to have a separate owner column to hold your Admin email address (or role), and populate that as part of the action that creates each new row.