I love what I have found while playing with Coda, but am curious if there is a way to have row-level security.
Scenario:
I have a table/db for projects. I also have a tasks table that references the projects table.
I want some projects (rows) to be visible to some people, but not others. I also want tasks that reference that project to be visible (or hidden) depending on rights/roles. Is there a way to do this easily?
Example scenario (fake but shows the use case):
Project for Firing an Employee
Tasks Associated for firing said Employee
I only want the HR department & their manager to see these rows. Is this possible?