Aug 07, 2024 11:39 AM
I am trying to build a shared database for ~30 research sites. There is a set of shared variables that all sites will track but sites also want the ability to track additional site-specific data points. Each site should get to see and edit ONLY their own records (i.e. they should not be able to see or edit any the individual records of any other sites). Each site should have access to an interface dashboard that shares summary data for the shared variables across all sites.
I've tried a few different approaches, but haven't found the solution yet.
Any tips would be very much appreciated!
Solved! Go to Solution.
Aug 07, 2024 05:35 PM
Hiya! I think interfaces are the way to go here!
If you want the "Grid" view that we have on the data side to appear on the Interface, just select any other visualisation first, ie List or Gallery. On the right panel, you can now add the grid as a visualization and remove the originally selected.
I'll also assume that each site is an individual collaborator. You can assign collaborators to specific records using the field type called "User". Then, in your Interface, you can set it to only display records assigned to the specific user.
I'm not sure if this answers your question, please let me know 🙂
Aug 07, 2024 05:35 PM
Hiya! I think interfaces are the way to go here!
If you want the "Grid" view that we have on the data side to appear on the Interface, just select any other visualisation first, ie List or Gallery. On the right panel, you can now add the grid as a visualization and remove the originally selected.
I'll also assume that each site is an individual collaborator. You can assign collaborators to specific records using the field type called "User". Then, in your Interface, you can set it to only display records assigned to the specific user.
I'm not sure if this answers your question, please let me know 🙂
Aug 09, 2024 10:50 AM
Thank you! I think this will work. My ideal version would allow each site to add and modify their own site-specific fields themselves (that only show in their site-specific interface) but NOT be able to modify the set of fields that are shared across all sites. They should be able to add records for the shared fields but not modify the field itself (e.g., change the field type, etc.). Do you happen to know if that is possible using interfaces?