I want to allow person X edit access to table A where they can enter
in their available inventory and change it at any time.
I want to allow person Y edit access to table B where they can enter in their available inventory and change it at any time.
Tables A and B have the exact same fields and structure.
I want to set up a third table
that shows all entries in A and B and neither X or Y can view (they
can’t be able to see each other’s inventory).
The first three bullets are easy, but figuring out the structure to amalgamate them in a place where all permission can be removed from X and Y (collaborators on tables A and B) seems impossible.
Things I’ve tried:
- Two different bases, one for collaborator X and one for collaborator Y, and then a third base that amalgamates the other two. Problem: There doesn’t seem to be a way to share data across bases. I’ve tried using “links” as well, and those are from one table to another within the same base.
- Two tables in the same base. Problem: I can’t set collaborator sharing permissions at the table level, only the base.
- Two views in the same table with an “Owner” field. Problem: I can’t set collaborate sharing permissions at the view level, only the base.
Is there a feature set I may be missing? Or an assumption above I’ve got wrong? I am a fairly skilled developer so I am open to creative technical or API driven solutions as well. Thanks!