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!
