Dec 19, 2021 03:12 AM
Not 100% sure on the best way to create a CRM & Project management setup.
Currently we have the pipeline in one tab, a list of jobs in another tab, all the shifts including £rates in another tab.
We want to keep the pipeline tab for selected people only.
We also want to hide the £rates fields in the shifts tab so to prevent certain people from viewing them.
How can we restrict views of tabs and certain fields please? Is it even possible to hide tabs?
Or is it better to create a separate base and have certain fields auto sync to the other base?
Thanks in advance.
Pete
Dec 19, 2021 04:46 AM
Welcome to the community, @Pete_Lindley!
In Airtable, it is not possible to hide anything in a base from the collaborators who have access to that base.
A workaround for hiding fields could be to do what you mentioned — sync certain fields from one base to another. (Note that syncs are one-way only from source view to destination table, and the data in the destination table is read-only.)
However, if you’re just looking for users to VIEW certain pieces of information (not EDIT information), you can share certain views by creating shared view links:
If you need people to edit information but not see certain fields, that is not possible to do within Airtable. You would need to pay for a portal tool such as MiniExtensions.com to do that:
Dec 19, 2021 05:39 AM
Thanks for confirming my thoughts Scott. Best look to restructure what we have so far before it gets too big.
Can you copy tabs from one base to another in the same space?
Dec 19, 2021 06:01 AM
No, that is not possible.
Dec 19, 2021 06:53 AM
Duplicate the base and delete what you don’t want in each then?
Dec 19, 2021 07:55 AM
Yes, you can do that.