This article describes how to add cell and range permissions within your ipushpull pages. You can control which cells and ranges of cells each user can view or update. For example, you could lock the header row to prevent anyone from updating it. You can add as many access-controlled ranges as you like to each page.
You must be a Folder Administrator in order to modify range permissions within a Page.
When you have selected the Page you want to add range permissions to, click the Settings button on the Page toolbar and select the Range Permissions tab.
1. Define the Range you want to protect
Navigate to the Range Permissions tab, name your range in Range Name and click CREATE. This will create a new range in the left column.
Click on the range name to see the configuration pane below:
To define the top two rows of the page to be a controlled range, set Start Row to 0 and End Row to 1. Then set Start Col to 0 and End Col to -1. Entering -1 instead of a real column ID will mean that the range will always cover all columns in the page, even if you add new ones. Hit Save.
2. Control user access to this range
A list of users with access to this page is listed below the range you have just defined. Toggle each of the square permission boxes to choose the permission you want. In this case we've restricted all users to read-only (RO) access to the range:
To get back to the page click the BACK TO PAGE button in top right of the page.
3. Check the page
The top 5 rows and 2 columns of the page now appear slightly faded (you may need to refresh your browser first) and you are not permitted to update them, even if you have read/write permission to the overall page:
If you want to completely hide the contents of some cells from some users, select NO instead of RO in stage 2.