Mar 27, 2024 11:15 AM
We used to have all of our employees invited to each base as a user rather than the workspace because we had some bases with sensitive info. We've now moved the sensitive bases to a new workspace and invited all of our employees to the workspace so they have access to everything. However, when we go under Account > Base Collaborators it still shows all of the individual bases that they were originally added to. For managing access it's much nicer to just see who has access to the whole workspace and who has access to only some individual bases as we still have some people that only need base access.
It seems the only way to clean this up would be to remove the workspace access, then painfully remove access for each individual on each of the probably over 100 bases we have, then re-grant access to the workspace. Is there any other way to fix this? To Airtable, suggestion that if someone goes from base access to the workspace access to clean up the view for us.
Mar 27, 2024 05:18 PM
You would need to use a script to do this.
This would leave you with just workspace level collaborators. You would then need to add people to bases as needed.
Mar 27, 2024 08:09 PM
Hmm, I think only Enterprise plans have access to the permissions related APIs, and so if you're not on Enterprise you might have to do it manually I'm afraid
Apr 01, 2024 10:06 AM
Hi @Dan_Montoya I did look at how to run a script but I'm not a tech so wasn't able to find this. I ended up having to manually go into each and every single airtable base and removing all the base level collaborators. This then made them show as a Workspace collaborator, but the amount of time this took was painful. While Airtable has been expanding features in amazing ways, the company seems to be lacking in the area of users/levels/permissions/collaborators etc with not a lot of help to do seemingly simple things to make managing user access better. Just my two cents.
Apr 01, 2024 10:15 AM
These features are available on the Enterprise plan.
https://airtable.com/developers/web/api/update-collaborator-base-permission