Hi @Howie Really enjoying Airtable - pretty new to it but I have already discovered it is a great product. Yes, more refined user permissions would certainly help us. We are a membership organisation/trade association involved with the wine industry and we hold a comprehensive wine inventory; the wines from which are used at our member events - receptions, lunches, dinners, banquets etc. We don’t trade wine as such but just buy, store and drink it
I would like to be able to control user access to certain sheets only and for that access to have view or edit options for each separate sheet. So, somewhere in sharing options some way to select permissions such as:-
Control access as follows:
Whole base - view only, edit or restrict to certain sheets
If ‘restrict to certain sheets’ thereafter on a per sheet basis
List of sheets and some method to select, on an individual sheet basis - no access, view only or edit
I guess the ultimate would then be to control permissions on each column within a specific sheet.
This would certainly help me give controlled access to certain members of staff who are involved in stock movement. On a very basic level I could then give our store-man access to one very basic sheet to record an order when it is delivered by simply changing order status from ‘On Order’ to ‘Delivered’ and entering the number of delivered items which would then show as available stock in the base. In essence, that would be all he needed in terms of interaction with the base.
I have tried this by embedding a sheet into a web site page but it doesn’t allow me to give editing permissions to the sheet which is embedded - that would be a simple solution if it was possible to edit via an embedded sheet.
Hope all this helps you guys progress this permissions issue. Many thanks