On the multiple display layouts we have an option Allow users to add which has no conditions whereas on the detail option Allow users to edit has conditions which can be used to restrict including properties of the current User.
It would make developing much more consistent if the conditions could also be applied on Allow users to add as this can then be used to allow view only access without having to repeat all the layouts where add and view access needs to be controlled.
Would like to know if there is an ‘official’ list of requested features and how what can be done to up this on the list. Having to work around the concept of different user groups requiring different access levels to the same data seems like a big omission and just ends with many weird and wonderful work arounds like having to duplicate data in the source sheet to create a ‘read only’ copy and then a ‘read only’ tab.
Having the ability to restrict the add option would sort this in a straight forward manner as the users can be allocated to role based groups with defined access rights.
Thanks for the response, and thanks for highlighting your method or ‘working around’ this issue. If implemented then everyone would have a single and consistent method to control role based access.
One way I use to control this is by creating 2 tabs which are the exact copies of each other with just one having an add button.
Then the tab with the add button is visible to the admin or based on conditions I would have otherwise used for the add button.
Thanks for the response. If the functionality was available to restrict add to users on a single tab would you still choose to take the time and effort to create duplicate tabs, maintain duplicate tabs etc?