I am wanting to understand if the following scenario is currently achievable and if so, what “add ons” would be required:
Ideally I would like to be able to share a “filtered” view with a clients that only shows information relevant to them for a updating various aspects of a project, while the remaining fields which are for internal purposes are hidden. Obviously this can be done by setting up a view and hiding the relevant fields. Only issue here is that when sharing this view a guest can view it and not make any changes (I am amazed that this feature is still yet to be implemented having seen discussions on this topic go back quite a long way).
So, the only option is to send this information to Google Sheets (I am aware of various tools such as Airtable Importer, Coupler, Integromat etc that can do this one way). Now that the info is in Google Sheets, it can be shared with a client (either the full set of data and hide various columns and restrict editing access or importing a revised view from AT).
Once the client update the relevant fields in Google Sheets, is there any way of syncing this info back into Airtable so that the Master table is always updated and synced with the latest information and updates?
Appreciate any help or suggestions.