Restricting access with a collaborator or external user

[Tanya_Graw]

We have a base used to track tasks for all of our clients. I have shared views with specific clients showing only certain fields and only their tasks, but the read-only restriction is a problem. The client really needs to edit status, etc. But if I make them collaborators so they can edit, as far as I can tell there is no way to limit which records and fields they can see?
Is there any way to accomplish this? Is it possible to sync a view or a filtered table with a Google Sheet so I can give the customer access to the sheet? I can’t be the only one with this requirement!

[ScottWorld]

Welcome to the community, @Tanya_Graw!

Unfortunately, you can’t do this natively with Airtable, but you can do this with several of the tools from MiniExtensions.com. Depending on your specifications, here are a few of the tools that might be useful for you:

miniExtensions

miniExtensions Portal for Airtable

Share records with people without giving them full access to Airtable. Limit them to only see their records and allow them to update some parts of the records.

miniExtensions

View Editor for Airtable (Grid) - miniExtensions

Share a view editor for Airtable. Limit access by controlling which fields can be seen or edited.

miniExtensions

miniExtensions Form to Edit and Create Airtable Records

Send someone a form URL that updates a specific record in Airtable. A form for Airtable that's packed with plenty extra features!

p.s. If you have a budget for this project and you’d like to hire an expert Airtable consultant & MiniExtensions expert to help you set this up, please feel free to contact me through my website at ScottWorld.com.